grantballantyne
asked on
Update Command Syntax
Dear Experts
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
Command2.Execute()
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.
I have the following update command:
'Set Command2 = Server.CreateObject("ADODB
Command2.ActiveConnection = MM_bspc_database_STRING
Command2.CommandText = "Update Property_Street_View set pSVlive = 'Y' "
Command2.CommandType = 1
Command2.CommandTimeout = 0
Command2.Prepared = true
Command2.Execute()
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi - I tried the following and got an error - 'Cannot use parentheses when calling a Sub
/membersarea/propertylist_ SV_confirm .asp, line 63
Command.Parameters.Append. CreatePara meter( "pSVMemberCode", adChar, adParamInput, 10, Request.Form("MemCode") )'
any suggestions?
Thanks
/membersarea/propertylist_
Command.Parameters.Append.
any suggestions?
Thanks
ASKER
will this work:
Command..Parameters.Append
thanks