Hi,

I made a application form and stored values of the field in the database, so i can allow them to change the field values. IE.
ID | FIELD NAME
---------------
1 | First Name:
---------------
2 | Last Name:

etc...

Is there a way that i can store the data when the user completes the form in a database. Do i have to create another database? And the column names have to be Field1, field2, field3 right, since the field names are dynamic and there is no way i can have column names the same as the field names?

Column name can be anything as you like, as long as not the reserved words if you using the SQL statment.

for Stored value, first you should insert the record, and you should have a field as autonumbered, so you can got the the record as form the autonumber, afterward you can update, and stored value.

What type of database are you using?

accesss

Here you go. Let me know how it works for you.

Page1.asp as follows...
<form method="Post" action="Page2.asp">
<input type="text" name="FirstName" value="">
<input type="text" name="LastName" value="">
<input type="Submit" Value="Submit">
</form>


Page2.asp as follows...
<%
    db = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=whatever.mdb"

    FirstName = request("FirstName")
    LastName = request("LastName")

    set rs = server.createobject("adodb.recordset")
    sql = "select * from table"
    rs.open sql, db, 3, 3
    rs.addnew
    rs("FirstName") = FirstName
    rs("FirstName") = LastName
    rs.update
%>

NOTE:
rs("FirstName"), rs("LastName") are the fields in the database itself.

FirstName = request("FirstName"), LastName = request("LastName") are the values that you are requesting from the page that has the form that the user submits.

thanks. works great.