< = "before" Try WHERE last_attempt > #DateAdd('n',15,Now())#;
On Wed, Jun 30, 2010 at 2:31 PM, Robert Harrison <rob...@austin-williams.com > 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