Cycling through fields in a recordset

[piersk]

Is there any way that I can cycle through the fields in each record in a recordset?

I am trying to write a script that will check every field in a MySQL database and if it is blank then change it to NULL (if anyone can think of an easier way of doing this, then please let me know :D )

Ta in advance,

P

[piersk]

Ta muchly.

[piersk]

On a similar note, does anyone know how to cycle through all the tables in a database (the db is MySQL)

Ta in advance again...