Single quotes on the date part fixed it:
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, DATE()) > 30
On Fri, Sep 12, 2008 at 9:09 AM, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 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/
>
--
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
-~----------~----~----~----~------~----~------~--~---
