RE: Rock Band needs a Codie
OK I got it. I had to change a few things, but thanks to all who helped. Ken, you win the CD since your's was closest to what I used. Send your address to me off board and I'll ship it out to you. Here is what I ended up with: SELECT* FROM gigdates, giglist WHERE gigname = name AND gigdate >= '#Dateformat (Now(), "MM/DD/")#' ORDER BY GIGDATE Tonight's Show (#gigtime#) Next Show (#gigdate# - #gigtime#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# Now to format all of that for use in Macromedia Flash and I am cooking with gas! (I got that ready to roll) Thank's again everyoneyou ROCK! M. Pool [EMAIL PROTECTED] -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:10 PM To: CF-Talk Subject: RE: Rock Band needs a Codie 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: SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate >= #dateformat(now, "mm/dd/")# Tonight's Show (#gd.gigtime#) Next Show (#gd.gigdate# - #gd.gigtime#) #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE# -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. select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate >=###today### and gigdate.gigname=giglist.name Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rock Band Needs a Codie> Updated
OK Guys This works EXCEPT I want the TONIGHT to take preference if it is an available date...as it stands the Greater Than date (next date) takes preference and only displays... SELECT* FROM gigdates, giglist WHERE gigname = name AND gigdate >= '#dateformat(now(), "mm/dd/")#' Tonight's Show (#gigtime#) Next Show (#gigdate# - #gigtime#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:10 PM To: CF-Talk Subject: RE: Rock Band needs a Codie 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: SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate >= #dateformat(now, "mm/dd/")# Tonight's Show (#gd.gigtime#) Next Show (#gd.gigdate# - #gd.gigtime#) #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE# -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. select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate >=###today### and gigdate.gigname=giglist.name Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rock Band needs a Codie
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: SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate >= #dateformat(now, "mm/dd/")# Tonight's Show (#gd.gigtime#) Next Show (#gd.gigdate# - #gd.gigtime#) #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE# -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. select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate >=###today### and gigdate.gigname=giglist.name Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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
RE: Rock Band needs a Codie
I will try to mix up my field values a little morehow does #sibilance#, #Check.test#, #1#, #2#, #3# grab you? Thanks..will check this out and see what comes of it.. MP -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5:25 PM To: CF-Talk Subject: RE: Rock Band needs a Codie Do a subquery selecting the min(gigdate) where gigdate >= today. Select the gig that is on that date, then in CF determine what text to show depending on the date of the gig. Something like select giglist.*, gigdates.gigdate, gigdates.gigtime fromgigdates, giglist where gigdates.gigname = giglist.name and gigdates.gigdate = (select min(gigdate) from gigdates where gigdate >= now()) tonight's show next show That was fun saying gig so many times ... Dan -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 1:21 PM To: CF-Talk 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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
RE: Rock Band needs a Codie
Let me try: SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate >= #dateformat(now, "mm/dd/")# Tonight's Show (#gd.gigtime#) Next Show (#gd.gigdate# - #gd.gigtime#) #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE# -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. select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate >=###today### and gigdate.gigname=giglist.name Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
Re: Rock Band needs a Codie
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/) > > Fields are as follows: > > GIGLIST > ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE > > GIGDATES > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rock Band needs a Codie
The problem you are having is your date in the Access table has a timestamp of 00:00:00 when you say now() that has a timestamp of the current time so you yield no results try: The long way: At 04:20 PM 9/12/2002 -0400, you wrote: >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/) > >Fields are as follows: > >GIGLIST >ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE > >GIGDATES >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 where gigdate >=###today### and >gigdate.gigname=giglist.name >order by gigdate > > > > >Tonight's Show (#GIGTIME#) > >Next Show (#GIGDATE# - #GIGTIME#) > > >#Name# #location# #address# #CITY_ST_ZIP# #PHONE# > > >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/) > >Fields are as follows: > >GIGLIST >ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE > >GIGDATES >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rock Band needs a Codie
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 Tonight's Show (#GIGTIME#) Next Show (#GIGDATE# - #GIGTIME#) #Name# #location# #address# #CITY_ST_ZIP# #PHONE# 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
RE: Rock Band needs a Codie
Do a subquery selecting the min(gigdate) where gigdate >= today. Select the gig that is on that date, then in CF determine what text to show depending on the date of the gig. Something like select giglist.*, gigdates.gigdate, gigdates.gigtime fromgigdates, giglist where gigdates.gigname = giglist.name and gigdates.gigdate = (select min(gigdate) from gigdates where gigdate >= now()) tonight's show next show That was fun saying gig so many times ... Dan -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 1:21 PM To: CF-Talk 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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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
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/) Fields are as follows: GIGLIST ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATES 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] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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