Hmm.what happens if you leave that last part with the DateDiff out?
n Angeli Wahlstedt 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 -~----------~----~----~----~------~----~------~--~---
