SQL database update problem with an ASP page

[tterrapin]

Can someone possibly help me. I am trying to update an SQL database thru ASP and can't get the syntax right. Not sure if I need to do something with DBEngine or Workspace or something else. The below query works when doing a plain query but does not work when trying to do an update query. The error that is stated is "ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.

Here is my code:

set SQLConn = server.CreateObject("ADODB.Connection&quot
SQLConn.open "dsn=*****;uid=sql_usr_*****;pwd=*****;"

sqlQuery = "Update studentdemo " & _
"set pin = '" & wsPin & "' where " & _
" studnum = '" &PassStudnum & "' "

set SQLRs = server.CreateObject("ADODB.Recordset&quot

SQLRs.Open sqlQuery, SQLConn


Thanks .. any help would be appreciated.

 

[tlbroadbent]

You are trying to create a record set with an Update query. Updates do not return record sets. You should use the execute method to run the Update query and use a Select statement to return a record set. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.