Manipulating recordset from the DB

sri2004 · June 17th, 2003, 07:21 PM

I am having this problem with the
objRs.Fields. When I retrieve the record from SQL if the value is 9 I
have to change it to 0. This is not working - can any of you help me
point where exactly I am missing the logic.

If objRs.Fields ("CirusStatusIndicator") = "'9'" Then
SET objRs.Fields ("CirusStatusIndicator") = "'0'"
Response.Write "<TD align=left>" & objRs.Fields
("CirusStatusIndicator") & "</TD>"
Else
Response.Write "<TD align=left>" & objRs.Fields
("CirusStatusIndicator") & "</TD>"
End if

Thanks
Sri

pgtips · June 18th, 2003, 06:59 AM

If you want to change the 9's to 0's permanently in the db, just do an UPDATE query

Code:

UPDATE tableName
SET CirusStatusIndicator = '0'
WHERE <whatever identifies the record>