asked on 7/1/2012

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.

ASP Web Languages and Standards Adobe Dreamweaver

Last Comment

grantballantyne

7/1/2012

ASKER CERTIFIED SOLUTION

Big Monty

7/1/2012

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

grantballantyne

7/1/2012

ASKER

Thanks for this suggestion - the member code is char (10)

will this work:

Command..Parameters.Append .CreateParameter( "pMemberCode", adChar, adParamInput, 10, Request.Form("pMemberCode") )

thanks

grantballantyne

7/1/2012

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.CreateParameter( "pSVMemberCode", adChar, adParamInput, 10, Request.Form("MemCode") )'

any suggestions?

Thanks