Also NAME is a reserved word in access -- you may need to rename that field to giglistname or when you do a select on it wrap it in [ ]
Tim P. ----- Original Message ----- From: "Michael Pool" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 4:20 PM Subject: Rock Band needs a Codie > OK I give up. I know when I am beat. This is a simple one. I know this > but I just can't get it to work for some reason. I saw something similar > in an old post, but it was not informative enough. > > Here's the deal: > > I have 2 tables in a Rock Band's database. (annie.mdb) > > GIGLIST and GIGDATES > > I have a template page that I want to show TONIGHT'S SHOW data if there > is a show tonight and IF NOT, then the NEXT SHOW date data. > > as I am sure you can tell by the extension, this is an ACCESS Database, > I have the GIGDATE field set to a "date" field. (MM/DD/YYYY) > > Fields are as follows: > > GIGLIST<Tablename> > ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE > > GIGDATES<Tablename> > ID, GIGNAME, GIGDATE, GIGTIME > (GIGNAME = giglist.name) > > > > So, let me reitterate.... I want to show all of the current variables > for the show record that has tonight's date (if there is a show tonight) > and set a variable "NEXTSHOWTIME" to either display the text "Tonight's > Show" or set to "Next Show" if no show tonight and then show the next > available showdate's recordset from the GIGDATES table and the > corresponding venue location info from the GIGLIST table. > > GIGNAME=NAME in the GIGLIST table > > > > > > > > FREE MUSIC CD to the first one who sends me code that makes this thing > work! > > Thanks! > > M. Pool > [EMAIL PROTECTED] > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
