Update method error

[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]

rsEdit1.Fields("authorMemo").Value = "test"

-or-

rsEdit1.Fields("authorMemo") = "test" ' .Value is the default property

-or

rsEdit1("authorMemo") ' Field is the default property

Cheers
Ken

"Poppy" <paul.diamond@NOSPAMthemedialounge.com> wrote in message
news:uyYrhCImDHA.2404@TK2MSFTNGP12.phx.gbl...
: 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 ?
:
:

[Bob Barrows]

Poppy wrote:

> I use the following to update:

Don't. It's very inefficient.

>

<snip>

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

<snip>

Ken pointed out your error, but I just want to point out that using a SQL
statement to do your update will be much more efficient, especially if you
encapsulate it in a stored procedure or saved parameter query depending on
what your database is*. I will illustrate with dynamic sql for the sake of
example:

Dim cn,sSQL
Set cn=server.createobject("adodb.recordset")
cn.Open MM_shop_STRING
sSQL = "UPDATE products SET [authorMemo]='TEST' " & _
"WHERE pautoid = 12"
cn.Execute sSQL,,129
cn.Close
Set cn=nohing

HTH,
Bob Barrows

*What IS your database? I suggest in the future that you specify your
database type and version in every question to this or any newsgroup where
you are asking a database-related question. You will receive more focussed
help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"