Manipulating the records in ASP

[Sri2003]

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

[Memnoch1207]

if it is an integer you don't need the quotes.

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

[Sri2003]

Thanks a lot I shall try and let you know how it worked in few hours..
Thanks much!