[thelist] Re: asp update existing record

Lightning oktellme at earthlink.net
Sat Jan 24 10:34:20 CST 2004


Hi Anthony and sgd!

I tried it. No go.
Tried a lot of variations.

I think there is something I am not understanding about calling a database
from asp.

Has anyone got a good plain-speak web-page that expalains this?

thanks
Laura





> 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



More information about the thelist mailing list