My advice is convert to a MySQL DB. Access, outside of itself is a very unstable platform and will continue to result in unexplained query errors. The post above are absolutely correct. Break down the query and try it line by line until you reach the problem area. Odds are, the problem is in the tranlation Coldfusion driver between and Access.
On Sep 11, 6:12 pm, "Aaron Rouse" <[EMAIL PROTECTED]> wrote: > 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 Rousehttp://www.happyhacker.com/- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
