Update method

[Poppy]

I use the following to update:

Dim rsEdit1
Set rsEdit1 = Server.CreateObject("ADODB.Recordset")
rsEdit1.ActiveConnection = MM_shop_STRING
rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12"
rsEdit1.CursorType = 2
rsEdit1.LockType = 3
rsEdit1.Open()

rsEdit1.("authorMemo") = "TEST" *Error message from this line
rsEdit1.update

rsEdit1.Close()
Set rsEdit1 = Nothing

The problem is that I keep getting the following error message :

"Microsoft VBScript compilation (0x800A03F2) Expected identifier"

Can anyone help ?

 

[Ken Schaefer]

Please post to one newsgroup onlye

Answered in asp.db

Cheers
Ken

: I use the following to update:
:
: Dim rsEdit1
: Set rsEdit1 = Server.CreateObject("ADODB.Recordset")
: rsEdit1.ActiveConnection = MM_shop_STRING
: rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12"
: rsEdit1.CursorType = 2
: rsEdit1.LockType = 3
: rsEdit1.Open()
:
: rsEdit1.("authorMemo") = "TEST" *Error message from this line
: rsEdit1.update
:
: rsEdit1.Close()
: Set rsEdit1 = Nothing
:
: The problem is that I keep getting the following error message :
:
: "Microsoft VBScript compilation (0x800A03F2) Expected identifier"
:
: Can anyone help ?
:
: