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