I'm sure there's a more efficient way of updating records than what I am

currently doing...

I'm getting records out of a database to edit on a page with the usual SQL

statement or

from a stored procedure with adLockReadOnly and adOpenForwardOnly cursors...

that

part works really well and really fast.



Now, when the user updates the fields and submits them, the next page is

essentially a SQL

"Update" statement, using code like this:

<%

Dim objConn

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open "DSN=mydsn;uid=user;pwd=password"

objConn.Execute "Update Blah Set Blah = Blah where Blah = Blah"

objConn.Close

Set objConn = Nothing

%>



Is this really the most efficient and most effective way to accomplish what

I want?  I'm sure there

are differing opinions.



Thanks for everyone's input in advance!

Regards,

-Arbon Reimer