[thelist] asp update existing record

[Scott Dexter]

--- Lightning <oktellme at earthlink.net> wrote:
> I am trying to update an existing record. The sql
> statement is fine.

> rsActivity=Server.CreateObject("ADODB.RecordSet")
>  rsActivity.Open sql,dsn,,3


Why open a recordset to execute a
non-recordset-returning function? <semi-rhetorical>

just do a connectionObject.Execute "sqlstatement"

:)

sgd