creating a SQL update statement using forms collection

[blexman]

I have a form with 96 fields. I need to find a way to create an SQL Update statement for all these fields without explicitly specify each field in my asp file.

Can this be done from the form collection ?

I know you can get the form element values like this :

For Each MyItem in Request.Form
Response.Write Request.Form(MyItem).Item
Next

but how do I get the SQL server table columns names ? Can I get it from the Command Object ?

thanks
hanton

 

[rac2]

q = "SELECT * FROM tableA"

rs.open q, conn

For Each col in rs.Fields
Response.write col.name & &quot;<br>&quot;
Next