Re: Rock Band needs a Codie 2nd attempt

Try createODBCdate At 05:37 PM 9/12/2002 -0400, you wrote: >Forgot to cut the latest code, so I pasted an older version. notice the >order by in the query > > >Still no promises. > > > > >select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, >GIGTIME from gigdates,giglist wher

Re: Rock Band needs a Codie 2nd attempt

Forgot to cut the latest code, so I pasted an older version. notice the order by in the query Still no promises. select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate >=###today### and gigdate.gigname=giglist.name order by gigdate