Hi,
The default format of date function is date with time. Ms-Access has also
the same format. If you want to compare two date values, change the target
value to default format and make the comparision. Like <cfset today=Now()>
which is the default for both CF & MS-Access. Now try with this default
format,
good luck,
Regards
kishore
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 12:23 AM
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