Update field held in variable.

[struth]

Hi

I am just writing an update that works with various parameters and variables and I don't know how to get this update routine to update just the one field. I have tried as follows but it doesn't work.

Set db = Session("db&quot
Set rsUpdate = Session("rs&quot
sTableName = Session("sTableName&quot
sOK = Session("svOK&quot
sKey = Session("pKey&quot


sSQL = "SELECT * FROM " & sTableName & " WHERE " & sKey & " = " & Request.QueryString("record&quot


set rsUpdate = Server.CreateObject("ADODB.Recordset&quot
rsUpdate.Open sSQL, db, adOpenDynamic, adLockOptimistic, adCmdText

*****How do I get it to update the field held in the parameter sOK --

rsUpdate.Fields("sOK&quot ="1"

rsUpdate.Update

TIA
Struth
"It's life Jim, but not as we know it!"

 

[Tarwn]

If I remember correctly you can't update fields in a subset of the table, you could, on the other hand, write an update statment that updated all records that met the criteria above:

sSQL = "UPDATE " & sTableName & "Set sOK = '1' WHERE " & sKey & " = " & Request.QueryString("record")

That would update the sOK field to "1" for all records that had sKey = your querystring value.

-Tarwn "If you eat a live toad first thing in the morning, nothing worse will happen all day long." - California saying
"To you or the toad" - Niven's restatement of California saying
"-well most of the time anyway..." - programmers caveat to Niven's restatement of California saying
(The Wiz Biz - Ri

 

[Tarwn]

Correction, i missed a spcae:

sSQL = "UPDATE " & sTableName & " Set sOK = '1' WHERE " & sKey & " = " & Request.QueryString("record")

"If you eat a live toad first thing in the morning, nothing worse will happen all day long." - California saying
"To you or the toad" - Niven's restatement of California saying
"-well most of the time anyway..." - programmers caveat to Niven's restatement of California saying
(The Wiz Biz - Ri

 

[struth]

Thanks Tarwn

That seems to have sent me in the right direction

Thanks "It's life Jim, but not as we know it!"