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
from gigdates, giglist
where gigdates.gigname = giglist.name
and gigdates.gigdate = (select min(gigdate) from gigdates where
gigdate >= now())
<cfif gigdate eq today>
tonight's show
<cfelse>
next show
</cfif>
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/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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
