adding multiple row and column data with a form

Question

I need to add multiple row and column data to a database
using an online form and am not sure what the best method of data
entry and inserting would be.

The data should look like this:

COLUMN1 COLUMN2
var1 var1
var2 var2
var3 var3
etc.......

When creating the form should I have individual text fields
for every var or would it be better to have a text field where they
list the data. I'm just not sure where to start.

Any advice would be great.

dempster · Accepted Answer

You can use row numbers in your field names to associate thecolumns with a particular record. For example, let's say you want 5rows to enter last names and first names:Last name: First name:
This will give you a series of fields such as lname1, fname1,lname2, fname2, etc.In your form, you can also include a hidden field to indicatethe number of rows.When you process the form, you loop again to insert each row:INSERT INTO mytable (lastname, firstname)VALUES ('#Form["lname" & onerow]#)', '#Form["fname" &onerow]#')

Dan_Bracuk · Answer

Regarding:If I create a unique text field for each variable won't theyeach need their own column in the database?No.As long as you know the name of the form field and what youare supposed to do with it, write your code accordingly.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.