Select Query works but not Update

[TheDoubleB]

I am using the following codes:

<CFQUERY name=&quot;SNNote&quot; dbtype=&quot;ODBC&quot; datasource=&quot;Afr&quot;>
Select * from Notes
Where
SNID =#NR#
</CFQUERY>

This works and I can display the data. However, when I try an update with:

<CFQUERY name=&quot;SNUpdNote&quot; dbtype=&quot;ODBC&quot; datasource=&quot;Afr&quot;>
Update Notes
Set
FirmName=&quot;#Form.Firm#&quot;,
ContactPerson=&quot;#Form.Person#&quot;,
ContactPhone=&quot;#Form.Phone#&quot;,
Notes=&quot;#Form.Note#&quot;
Where
SNID =#NR#
</CFQUERY>

and I get:

ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

Anyone have any ideas? This is driving me nuts....

 

[TheDoubleB]

Never mind....must have been temporarily brain-dead...just changed the double quotes to single quotes....

 

[scripter73]

Thanks, Calista,

No offense taken. But, yes, I output the data I want to insert right before outputting the &quot;supposedly&quot; updated query.

One thing I did change was instead of <cfoutput query=&quot;newdata&quot;>, I now say <cfloop query=&quot;newdata&quot;> and I get the same results. No updated query.

So frustrated....

Thanks for your help, though.
scripter73


Change Your Thinking, Change Your Life.