your asking for everything its got that doesn't have a date equal to greater
than the exact second your run the query. Which is probably everything in
the table.
----- Original Message -----
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 1:25 PM
Subject: query date problem
> This query gives me all records in the database instead of just what I
asked
> for. What am I doing wrong?? This NewDateArc field is a DateTime field in
> Access
>
> <cfquery datasource="Articles" name="DeleteOldArc">
> select * from ArchivesCopy
> WHERE NewDateArc < NOW()
> </cfquery>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
