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!

 

[JayKusch]

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


Thanks

J. Kusch

 

[ecobb]

UPDATE Tmembers
SET towhere = "H"
WHERE HOMEEMAIL is null

Is the correct syntax for SQL Server.


Hope This Helps!

Ecobb
- I hate computers!

 

[swampBoogie]

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

Is HOMEEMAIL null or an empty string?

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

 

[halukorhan1]

Thanks a lot with my best regards!