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 :
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
