#dateformat(FORM.start_date, "MM/DD/YYYY")# should be
#createODBCDate(form.start_date)# Or use cfqueryparam. Regards Dale Fraser http://learncf.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 16 November 2007 7:33 AM To: CF-Talk Subject: CF date values in Access Shouldn't this be working? I'm more familiar with SQL Server 2000. <CFQUERY name="promomag" datasource="con_relations_magxml"> SELECT * FROM tblPromotionParticipants where promotionalID = 85 AND DateReceived >= #dateformat(FORM.start_date, "MM/DD/YYYY")# AND DateReceived <= #dateformat(FORM.end_date, "MM/DD/YYYY")# </CFQUERY> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred in D:\Inetpub\wwwroot\SfConsumersdb\cds2.cfm: line 22 20 : FROM tblPromotionParticipants 21 : where promotionalID = 85 AND DateReceived >= #dateformat(FORM.start_date, "MM/DD/YYYY")# 22 : AND DateReceived <= #dateformat(FORM.end_date, "MM/DD/YYYY")# 23 : </CFQUERY> 24 : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
