Aaron, Try making the Yes a -1 if the data type in the Access database is a Yes/No. Access actually stores a 0 or -1 in the column. The ODBC driver is not translating the Yes to a -1 for you.
RObert At 02:24 AM 9/13/2008, you wrote: >Date: Thurs, Sep 11 2008 4:12 pm >From: "Aaron Rouse" > > >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. > > Robert Stewart ProjecTools.com 713-371-9840 X1305 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
