I´ve got a HTML Form that has about 30 fields to fill in, and the management are forever making changes. What I was trying to do was create an ASP form processor that would dynaically handle all these fields and add them to the database.<BR><BR>All I´d have to do is add/change fields in the database which would save me time and extrawork.<BR><BR>I had an attempt at this but realised that my code would add a seperate record for each field and also it takes the submit button as an entry.<BR><BR>Any ideas, I can´t be the first person to do this. <BR><BR><BR>&#060;html&#062;<BR><BR>&#060;head&#06 2;<BR><BR>&#060;title&#062;Form Processor&#060;/title&#062;<BR>&#060;/head&#062;<BR><BR>&#060;body&#062;<BR><BR>&#060;%< BR>REM Open Database<BR><BR>set myconn = server.createobject("ADODB.Connection")<BR>myconn. open "FILEDSN=d:datadsnMydsn.dsn"<BR><BR>REM Set up loop to process all elements in form. <BR><BR>for each formkey in request.form<BR>tempfield = formkey<BR>tempvalue = Request.form.item (formkey)<BR><BR>REM Build SQL String<BR><BR>sqlstr= "INSERT INTO friends "<BR>sqlstr= sqlstr & "(" & tempfield & ") VALUES "<BR>sqlstr= sqlstr & "(´" & tempvalue & "´)"<BR><BR>response.write sqlstr & "<BR><BR>&#060;hr&#062;"<BR><BR>REM Execute SQL Instruction<BR><BR>myconn.execute(sqlstr)<BR><BR>n ext<BR><BR>myconn.close<BR><BR>%&#062;<BR><BR><BR> &#060;b&#062;Record added succesfully<BR><BR>&#060;/b&#062;<BR><BR><BR>&#060;center&#062;&#060;a href="showdb.asp"&#062;Show the Entire Database&#060;/a&#062;&#060;/center&#062;<BR><BR>&#060;/body&#062;<BR><BR>&#060;/html&#062;<BR><BR>