I have the following update command:
'Set Command2 = Server.CreateObject("ADODB.Command")
Command2.ActiveConnection = MM_bspc_database_STRING
Command2.CommandText = "Update Property_Street_View set pSVlive = 'Y' "
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Set Command2 = Nothing'
I would like to update the pSVlive to Y ONLY where another the field 'pMemberCode' is equal to a form variable that is posted from the previous page.
Can anyone suggest on the syntax to achieve this ?
Many thanks for any help.