update statement

[halukorhan1]

I want to update the field (towhere) as "H" where the field is homeemail = null (empty)

------------
SQL_update = "UPDATE Tmembers"
SQL_update = SQL_update & " SET towhere = '" & "H" & "'"
SQL_update = SQL_update & " WHERE HOMEEMAIL is null"

Set objRS_update = Server.CreateObject ("ADODB.Recordset&quot
objRS_update.Open SQL_update, strConnect
-----------------

Does not do anything!

Any help is appreciated!

 

[Nowell]

Hi,

I normally do my update statements with a stored procedure, not saying thats the best way to do it, but it works!

Nowell