well, the condition INT_PARTRETURNED = Yes , could be the problem. I am
assuming that its varchar type, so I suggest below based on this assumption.
Either it should be in single quotes or sometimes access thinks its a column
name and you have to enclose it with square brackets. Either of the two
could be the solution.i.e. 'Yes'
or if its not varchar type, try [yes]
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, DT_PARTRETURNED) > 30
I hope it helps.
Ajas Mohammed.
On Thu, Sep 11, 2008 at 12:49 PM, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> 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.
>
> >
>
--
<Ajas Mohammed />
http://ajashadi.blogspot.com
We cannot become what we need to be, remaining what we are.
No matter what, find a way. Because thats what winners do.
You can't improve what you don't measure.
Quality is never an accident; it is always the result of high intention,
sincere effort, intelligent direction and skillful execution; it represents
the wise choice of many alternatives.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
