RE: Rock Band needs a Codie

2002-09-12 Thread Dan Haley
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

Re: Rock Band needs a Codie

2002-09-12 Thread Jerry Johnson
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#

Re: Rock Band needs a Codie

2002-09-12 Thread Steven A. del Sol
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

Re: Rock Band needs a Codie

2002-09-12 Thread Tim Painter
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

RE: Rock Band needs a Codie

2002-09-12 Thread Greg Luce
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.

RE: Rock Band needs a Codie

2002-09-12 Thread Michael Pool
-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

RE: Rock Band needs a Codie

2002-09-12 Thread Ken Beard
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

RE: Rock Band needs a Codie

2002-09-12 Thread Michael Pool
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

RE: Rock Band Needs a Codie> Updated

2002-09-12 Thread Michael Pool
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

Re: Rock Band needs a Codie 2nd attempt

2002-09-12 Thread Jerry Johnson
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

Re: Rock Band needs a Codie 2nd attempt

2002-09-12 Thread Steven A. del Sol
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