Assuming that your running from a SQLServer or access DB (although it should work with mysql) try
<CFQUERY name="PreviousDates" datasource="calendar"> SELECT * FROM Events WHERE eDate < <CFQUERYPARAM value="#now()#" CFSQLTYPE="CF_SQL_TIMESTAMP"> </CFQUERY> HTH -----Original Message----- From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 18:02 To: CF-Talk Subject: Query help! 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
