I forgot to mention that the page will keep refreshing so the value would change all the time.
What I want to do is set it once an stays the same. Maybe set a session var in another browser frame using Now(). Thanks Tony! ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 12:21 PM Subject: RE: Date question > you can do this... > > <cfquery name="blah" datasource="foo"> > select * from foo where TheDate >= #Now()# > </cfquery> > > and that value can be anything that is acceptable date format > > ...tony > > Tony Weeg > Senior Web Developer > UnCertified Advanced ColdFusion Developer > Information System Design > Navtrak, Inc. > Mobile workforce monitoring, mapping & reporting > www.navtrak.net > 410.548.2337 > > -----Original Message----- > From: Frank Mamone [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 27, 2003 12:16 PM > To: CF-Talk > Subject: Date question > > > What is the nest way to format a date to compare to a database datetime > column. > > Basically I want to pull all records created after the original request > was > made. > > So, > <CFSET RequestTime = "this is what I need"> > > <CFQUERY.....> > SELECT ...... > > Where datecolumn >= RequestTime > > </CFQUERY> > > I'm really bad with date stuff and I need to learn how to work with > them. > > Thanks, > > Frank > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
