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:
<cfquery name="get_gig"
datasource="#DBPath#"
dbtype="OLEDB"
provider="Microsoft.Jet.OLEDB.4.0"
providerdsn="#DBPath#"
username="Admin"
password=""
maxrows="1">
SELECT *
FROM gigdates, giglist
WHERE gigname = name
AND gigdate >= '#Dateformat (Now(), "MM/DD/YYYY")#'
ORDER BY GIGDATE
</cfquery>
<cfoutput query="get_gig">
<cfif #gigdate# eq #Dateformat (Now(), "MM/DD/YYYY")#>
Tonight's Show (#gigtime#)
<cfelse>
Next Show (#gigdate# - #gigtime#)
</cfif>
#Name# #location# #address# #CITY_ST_ZIP# #PHONE#<br> </cfoutput>
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 everyone....you 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:
<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]
______________________________________________________________________
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
