< = "before"
Try WHERE last_attempt > #DateAdd('n',15,Now())#;
On Wed, Jun 30, 2010 at 2:31 PM, Robert Harrison <[email protected]
> wrote:
>
> This creates my time (SQL Insert):
>
> SET last_attempt=#CreateODBCTime(Now())#
>
> This is the query to get (after 15 minutes have passed):
>
> WHERE last_attempt < #DateAdd('n',15,Now())#;
>
> But it's selecting all records regardless of the time.
>
> What the heck?
>
>
>
> Robert B. Harrison
> Director of Interactive Services
> Austin & Williams
> 125 Kennedy Drive, Suite 100
> Hauppauge NY 11788
> P : 631.231.6600 Ext. 119
> F : 631.434.7022
> http://www.austin-williams.com
>
> Great advertising can't be either/or. It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
>
>
> __________ Information from ESET Smart Security, version of virus signature
> database 5241 (20100630) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
