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 gi
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#
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
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
Subj
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.
-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
f
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 nee
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 PROT
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 Messa
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
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 wher
11 matches
Mail list logo