If you open your database with the right kind of cursor, you can do the
update.
Do While not objRS.EOF
objRS("MyField")="new value"
objRS.MoveNext
Loop
objRS.Update
I prefer to use an UPDATE Sql statement, to make the changes
if objConn is my connection....
Dim sSQL
Dim newValue
newValue="new value"
sSQL="UPDATE tablename SET MyField='" & newValue & "' WHERE columnUniqueID=
X"
objConn.Execute sSQL
In this way you aren't pulling down a recordset just so you can do an
update.
If you need to display the "updated" data, just do the UPDATE first.
"Bullschmidt" <pa**@bullschmidt.com-nospam> wrote in message
news:u$**************@tk2msftngp13.phx.gbl...
In the updating to the database:
objRS("MyField") = str
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!