That is not a solution at all though. Looks l like the problem is coming from the last line. So down to figuring out how to manipulate it so that the driver communicates things to Access correctly. Tried adding the last two optional arguments to the function and tried using the date() function instead of now() but neither had any change to the error.
On Fri, Sep 12, 2008 at 8:23 AM, Kraegan <[EMAIL PROTECTED]> wrote: > > 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 - > > > -- 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 -~----------~----~----~----~------~----~------~--~---
