I have not tried and when I sent the email I was wondering on that although the error is an Access error and my wondering was based around maybe CF somehow thinking that was a CF function call even though it lacks the pound signs.. As far as the other suggestions, if the query works perfectly in Access then I have a hard time understanding why those changes. In regards to the Yes, that is how Access treats its Yes/No datatype, took me a minute or two to figure that out this morning because I kept trying to use 1. I did just try the restructuring of the query within Access and it does not like the "EQ" part
On Thu, Sep 11, 2008 at 11:59 AM, Angeli Wahlstedt <[EMAIL PROTECTED]>wrote: > 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. > > > > > > -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
