Update without form using ASP

Question

Hi, I am able to update records with forms. I now need to update records without the use of forms but keep getting stuck. Your help is very much appreciated. I don't think dreamweaver supports this, so I started adapting my code as as follows:

<%
Dim rsRespondents
Dim rsRespondents_numRows
Set rsRespondents = Server.CreateObject("ADODB.Recordset")
rsRespondents.ActiveConnection = MM_CHRdsn_STRING
rsRespondents.Update="SurveyEmployees SET FirstName='Changed' WHERE EmployeeID='17'"
rsRespondents.CursorType = 0
rsRespondents.CursorLocation = 2
rsRespondents.LockType = 1
rsRespondents.Open()
rsRespondents_numRows = 0
rsRespondents.Connection.Execute
%>

I get the following error:
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/chr_cms/CHROTupdatewithoutform1.asp, line 19 <-- this is the line starting with rsRespondents.Update

I have also used rsRespondents.Update="UPDATE SurveyEmployees .......

but same error message

What am I doing wrong here ?

[Thread moved by moderator to correct forum]

bregent · Answer

I've never seen the update method used that way - are you sure it's valid? Typically, you would select the record you want to modify into the recordset, change it, and then call the update method. Or, you can specify the fields and values you want to update as arguments to the method. But I've never seen it include an actual update statement.

http://msdn.microsoft.com/en-us/library/ms676529(VS.85).aspx

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded