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:312390
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
