[thelist] asp woes

Scott Dexter sgd at ti3.com
Fri Jul 20 10:32:52 CDT 2001


Use an update query, not a recordset to update data. Using a recordset
is bloated and slow.

> line 13    Set pdbFSDB = Server.CreateObject("ADODB.Connection")
> line 14    pdbFSDB.open "FSDB", "",""

then do:

pdbFSDB.Execute "Update ...."

and das it. no muss, no fuss.

sgd





More information about the thelist mailing list