I have multiple records in my SQL database and the number of records changes constantly.
I would like to let this records appear in textboxes so that I can edit them via the GUI.
Does any one have any idea how about going to do it?
Thanks.

Mou

Yeah,


   dim conn,rs,strQry,strHTML
   set conn=server.createObject("ADODB.connection")
   conn.connectionstring="..."
   set rs=server.createObject("ADODB.recordset")
   strQry="select fld1,fld2,fld3 from table..."
   rs.open strQry,conn

   strHTML="<form name='frm1' action='page.asp' method='post'><table align='center' cellpadding='3' cellspacing='0'>"
   while not rs.eof
   strForm=strForm & "<tr><td><input type='checkbox' name='chk1' value='Y'></td><td><input type='text' name='txtFld1' value='" & rs("fld1") & "'></td><td><input type='text' name='txtFld2' value='" & rs("fld2") & "'></td></tr>"
       rs.movenext
   wend
rs.close

strForm=strForm & "<tr><td colspan='3' align='center'><input type='button' value='Edit' onclick='chkData()'></td></tr></table></form>"

' then do your coding

sorry!

  replce strForm with strHTML

I would never suggest this way of editing rows. How many records would you edit at a time? Does that not complicate things? Considering usability and code management perspectives, this method of editing is not advisable.

I would suggest listing of values on a page in a row/column format and allow the user to edit one row at a time. That is the better and most commonly used method of editing rows using web applications.

Cheers!

_________________________
- Vijay G
Strive for Perfection