at a rough guess, i suspect that you cannot use an explicit cf function such as
datediff in the query.
>I have this small project that I inherited that uses MS Access for its data
>source. I am trying to run an update query via a cfquery but keep getting
>an error. I can open up Access and paste the query in there and it runs
>fine which leads me to believe there is nothing wrong with the query itself
>but ColdFusion is just hating me. If it matters this is ColdFusion 8. here
>is the query:
>UPDATE FAILUREREPORT SET STR_DISPOSITION = 'SCRAP' WHERE STR_DISPOSITION IS
>NULL AND INT_PARTRETURNED = Yes AND DT_PARTRETURNED IS NOT NULL AND
>DATEDIFF("d", DT_PARTRETURNED, NOW()) > 30
>
>And here is the error:
>[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
>Access Driver] Too few parameters. Expected 1.
>
>--
>Aaron Rouse
>http://www.happyhacker.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
