Variables for Field Names.

Question

This may be a silly one for ya but I am having a brain fart
now.
I am doing a dynamic form where the form questions are
created fro a database.
The different field names are dynamic variables generated via
itererations (++) from the database table.
The problem is that when I submit the form I need the field
names as the insert or update value to populate the values
statement in the query. I am having a problem locking down the
actual values to use for the insert or update statement.

I will need to use a loop to iterate through the variables.
Look at the code form the form.

Thanks in advance.
Gene

Anonymous · Answer

First change your form variable names to something like this:

<cfinput type="text" name="#measure1# _#getCommInsertData.currentrow#" size="7" enabled="true" visible="true">

adding the query name and currentrow to the end of the form name will give each input its own identity.

Once you have done this, and submit the form, you can run a loop for the "FIELDNAMES" defined from the form to return the values

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.

Scanning file for viruses.

This file cannot be downloaded