try <cfquery name="previousDates" datasource="calendar"> SELECT * FROM events WHERE eDate < <cfqueryparam value=createODBCDate(now())>; </cfquery>
(assuming your eDate field is a date/time datatype...i don't think you'd need a dateFormat() function) hth, charlie Scott Wilhelm writes: > Can someone tell me what's wrong with this line: > > <CFQUERY name="PreviousDates" datasource="calendar"> > SELECT * FROM Events WHERE eDate < <CFQUERYPARAM > value=#formatdate(now(),"mm-dd-yy")#> > </CFQUERY> > > I can't figure out how to get a date query to work right... > > Thanks, > > Scott > > -----Original Message----- > From: Costas Piliotis > Sent: Mon 01/13/2003 01:01 PM > To: CF-Talk > Cc: > Subject: RE: ASP to ColdFusion > > > > Woo hoo... Another convert :-) > > A quick search on google gets some good introductury > tutorials... > > > http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut > oria > l2.html > http://www.macromedia.com/support/coldfusion/tutorial_index.html > http://kongtechnology.com/index.asp?im=cf1 > > > > -----Original Message----- > From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 9:53 AM > To: CF-Talk > Subject: ASP to ColdFusion > > > I'm originally an ASP developer now working with > ColdFusion...Does anyone > know of any resources that would help in the conversion? > (ASP->CF > translations, tutorials, etc.) > > Thanks, > > Scott > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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