Getting key names from DB results

[Crundy]

Hello,
I'm ripping info out of a database and I want to loop through all the field names in each record replacing ' with '', but I don't seem to be able to get the key names into an array. I've tried this:

Set Conn = server.CreateObject ("ADODB.Connection&quot
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & dbpath & ";"

set RS=Conn.execute("select * from depts&quot

do until RS.EOF
for each keyname in RS.keys
RS(keyname) = Replace(RS(keyname), "'", "''", 1, -1, 1)
next

'Do some stuff with the row here
loop

but I get an error saying "Object does not support this property or method 'RS.KEYS'"

I've tried looping though as an array as well, but that didn't work. Can anyone help? C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!

 

[FengShui1998]

crundy,

In your loop, change to this:

do until RS.EOF
RS(keyname) = Replace(RS(keyname), "'", "''", 1, -1, 1)
' Do some stuff with the row here
rs.update
rs.movenext
loop

Cheers;
fengshui_1998

 

[Crundy]

The problem isn't the update, it's getting the key names and using them.

Don't worry about it now, I just took the easy way out (replaced all the 's in the database itself!!) C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!