Re: tough one

At 16:51 2001/08/09 +0200, Tony Grant wrote:
>festival | filmid
>------------------------------------------
>1979 | 102, 103, 104
>1980 | 258, 369, 489, 568
>
>How can I simulate an ARRAY of this type? If I can't - where is the
>nearest bridge?

you could define a table with this data:

festival | filmid
------------------------------------------
1979 | 102
1979 | 103
1979 | 104
1980 | 258
1980 | 369
1980 | 489
1980 | 568

with a query like this:

select filmid from films where festival = '1980'

and use a loop like this to generate an array

Vector films = new Vector();
while ( rs.next() )
{
films.add ( rs.getString ( "filmid" ) );
}

bye
John