I&#039m trying to update an html table that has multiple records where only the last column gets updated using an input box, this is where I used an input within the table at rppo_remarks and submitting thru <BR>&#060;form action="Dverify.asp" method="post" id=form1 name=form1&#062;<BR><BR>This is where I&#039m trying to traverse thru all the records from the html table so theye can be updated. but the only thing that happens is a comma deliniation between each record. <BR>Any help would be highly appreciated.<BR><BR>&#060;--! Dverify.asp --&#062;<BR>Dim Connect, rs, sql<BR>Dim doc_num, rppo_remarks <BR>rppo_remarks = Request.Form("rppo_remarks")<BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR>Connect .Open "PROJDLR"<BR>Set rs = Server.CreateObject("ADODB.Recordset") <BR>sql = "UPDATE DLR"<BR><BR>do while rs.eof<BR> if (rppo_remarks = "") then<BR> sql = sql & " SET rppo_remarks=NULL"<BR> else<BR> sql = sql & " SET rppo_remarks=&#039"&rppo_remarks&"&#039"<BR> end if<BR> sql = sql & " WHERE doc_num=&#039"&doc_num&"&#039"<BR> rs.Open sql, Connect<BR>loop<BR><BR><BR>