Dynamic Variables

[hlywd7]

I have an insert statement with a dynamic variable that I can not get to work. The dynamic variable is the form.judge_first_name.
Here is what I have so far: The judge_first_name field actually is going to have a number at the end of the name after each time though the loop. I want to reflect that in the insert statement.

<cfset num = form.number_of_elements>
<cfloop index="h" from="1" to="#num#">
<cfparam name="form.judge_first_name#h#" default="" type="any">

<cfquery name="insert_judge_first_name" datasource="#Application.DSN#">
INSERT INTO JUDICIAL_DIVERSITY_JUDGE (judgeid, stateid, judge_add_date, judge_first_name)
Values((#nextvalue#,
<cfqueryparam value="#form.stateid#" CFSQLType="CF_SQL_VARCHAR" maxlength="100">, sysdate,
<cfqueryparam value="#form.judge_first_name##h#" CFSQLType="CF_SQL_VARCHAR" maxlength="1000">)
</cfquery>

[Kevin_Schmidt · Accepted solution]

Try using this:

value="#form["judge_first_name#h#"]#"

Also, are you getting an error, or is it just not inserting a value?

[hlywd7]

Well its inserting into the table field the value judge_first_name1

[hlywd7]

So the cfqueryparm would look like this?

<cfqueryparam value="#form["judge_first_name#h#"]#" CFSQLType="CF_SQL_VARCHAR" maxlength="1000">

[Kevin_Schmidt]

Glad that worked for you.

[Newsgroup_User]

Close you need to alternate quotes, something like this:
<cfqueryparam value="#form['judge_first_name#h#']#"
CFSQLType="CF_SQL_VARCHAR" maxlength="1000">

OR a little cleaner way to do the same thing:
<cfqueryparam value="#form['judge_first_name' & h]#"
CFSQLType="CF_SQL_VARCHAR" maxlength="1000">



hlywd7 wrote:
> So the cfqueryparm would look like this?
>
> <cfqueryparam value="#form["judge_first_name#h#"]#" CFSQLType="CF_SQL_VARCHAR" maxlength="1000">