Order BY GDATE
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:53 PM
To: CF-Talk
Subject: QUERY PROBLEM
I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001 Any ideas?
<cfset today = dateformat(NOW(), 'm/d/yyyy')>
<CFQUERY name="NextGame" datasource="#dsource#" maxrows="1">
SELECT *
FROM schedule
WHERE gdate >= #today#
</CFQUERY>
ALSO HAD IT AS
<CFQUERY name="NextGame" datasource="#dsource#" maxrows="1">
SELECT *
FROM schedule
WHERE gdate >= NOW()
</CFQUERY>
Thanks.
Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists