You might try it this way. I have had to make several modifications between
Access and SQL databases to accommodate Access "funnies"
UPDATE FAILUREREPORT SET STR_DISPOSITION = 'SCRAP' WHERE STR_DISPOSITION eq
"" AND INT_PARTRETURNED = 1 AND DT_PARTRETURNED neq "" AND DATEDIFF("d",
DT_PARTRETURNED, NOW()) > 30
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Aaron Rouse
Sent: Thursday, September 11, 2008 11:50 AM
To: [email protected]
Subject: [houcfug] Anyone use MS Access Much?
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.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "Houston ColdFusion
Users' Group" discussion list.
To unsubscribe, send email to [EMAIL PROTECTED]
For more options, visit http://groups.google.com/group/houcfug?hl=en
-~----------~----~----~----~------~----~------~--~---
