right except you're using the table aliases when outputting with cf down near the bottom.. simple mistake :)
what's up greg. Ken -----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 7:51 PM To: CF-Talk Subject: RE: Rock Band needs a Codie Let me try: <cfquery name="get_gig" datasource="annie?" maxrows="1"> SELECT gd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate >= #dateformat(now, "mm/dd/yyyy")# </cfquery> <cfoutput query="get_gig"> <cfif dateformat(get_gig.gigdate, "mm/dd/yyyy") eq dateformat(now(), "mm/dd/yyyy")> Tonight's Show (#gd.gigtime#) <cfelse> Next Show (#gd.gigdate# - #gd.gigtime#) </cfif> #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE#<br> </cfoutput> -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5:36 PM To: CF-Talk Subject: Re: Rock Band needs a Codie No promises. <!--- NOTE: the access date query may be wrong, but I believe the date delimiter is ## ---> <cfset todayÚteFormat(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 </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> HTH 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] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists