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. > ><!--- NOTE: the access date query may be wrong, but I believe the date >delimiter is ## ---> ><cfset today=dateFormat(now(),"mm/dd/yyyy")> ><cfquery name="nextgig" datasource="annie?"> >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 ></cfquery> > ><cfoutput query="nextgig"> ><cfif dateCompare(gigdates.gigdate,today,"d") eq 0> >Tonight's Show (#GIGTIME#) ><cfelse> >Next Show (#GIGDATE# - #GIGTIME#) ></cfif> > >#Name# #location# #address# #CITY_ST_ZIP# #PHONE#<br> ></cfoutput> > >Jerry Johnson > > >>> [EMAIL PROTECTED] 09/12/02 04:20PM >>> >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] > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
