Peter J. Boettcher — Wed, 21 Mar 2001 14:35:53 +0000

Got into this one kind of late.

You can update multiple recordsets at once when using ADO. Make sure the cursortype is "adOpenKeyset" and the locktype is "adLockBatchOptimistic". Then you can use the UpdateBatch method.

bhorstkotte — Wed, 21 Mar 2001 04:39:09 +0000

No, a recordset is just a container for result rows - to execute SQL on it, it has to be connected to an ADO provider. For the original problem you asked about, look into the options you can set for the CursorType.

Mark Hensler — Tue, 20 Mar 2001 07:21:40 +0000

ahhh...
No, I've never seen/heard anything like that.

ShinNathan — Tue, 20 Mar 2001 07:18:55 +0000

Well this here:

do while not rs.eof
SQL2 = "UPDATE Rankings SET dname='" & Replace(rs("dname")," ","%20") & "' WHERE dname='" & rs("dname") & "'"
dbopen.execute(SQL2)
rs.movenext
loop

If instead of updating the 'dname' feild in the 'Rankings' table, I could be updating the 'dname' feild in the rs recordset. That way I would not have to create another recordset just to get the data back form that table.

Mark Hensler — Tue, 20 Mar 2001 07:11:25 +0000

ummm...
To my knowledge, no.

But what exactly do you mean?

ShinNathan — Tue, 20 Mar 2001 07:09:18 +0000

One more question

Can you execute sql on a recordset? Would be so great if you could...

Mark Hensler — Tue, 20 Mar 2001 06:52:26 +0000

That's why we're here. Please, feel free to share all your web related problems with us... LOL!

ShinNathan — Tue, 20 Mar 2001 06:49:29 +0000

I looked it up and it means that you can't use nextRecordset when using access.

I did not think that it mattered what database I was using once the data was pulled out of it into recordsets...?

Anyway, I don't think I can solve this using ado. I can work around it using a sub program. I'll do that. A little more sloppy, but will get the job done.

Thanks you all your help

Edit:

I made a new page with just this:

<?php
option explicit
dim dbopen
dim SQL
dim rs


    'DB CONNECTION
set dbopen=Server.CreateObject("ADODB.Connection")
dbopen.Provider="Microsoft.Jet.OLEDB.4.0"
dbopen.open Server.MapPath("/SHINNATHAN/database/CDR.mdb")


    'SETUP RECORDSET
SQL="SELECT dName FROM Drivers"
set rs=dbopen.execute(SQL)
?>

Testing recordset update

<?php
response.write rs("dname") & "<p>"
rs("dname")= "this"
rs.Update

rs.close
dbopen.close
set dbopen=Nothing
set rs=Nothing
?>

And still I got the error... I am giving up

Mark Hensler — Tue, 20 Mar 2001 06:47:10 +0000

are you making any other queries to that tables later or before in that script?

Mark Hensler — Tue, 20 Mar 2001 06:44:45 +0000

I don't know.