Dynamic variable inside cfloop

[Flashdakota]

Good day

I have a dynamic form which looks something like this...
<Cfloop from 1 to 6 indes i>
<cfinput type="text" name="description#i#" class="TextBlock">
</cfloop>

When submitting, I want to insert description#i# into a db

At the moment i have this...
<Cfset thedescription = description#i#">
<cfquery name="insertpic" datasource="#application.db#">
INSERT INTO tblpics
(description,)
VALUES ('#thedescription#')
</cfquery>

Its all inisde a loop

How do i set description#i# = somevar?

Please can someone assist?

Regards
Delon

[-__cfSearching__-]

> How do i set description#i# = somevar?

If you are using method="post", form field values are available in the FORM structure. For method="get" they are available in the URL structure. Since they are structures, you can use array notation to extract reference the dynamic field names: #FORM["baseFieldName"& counterVariable]#

<cfloop index="i" ...>
<cfset description = FORM["description"& i]>
...
</cfloop>

Also, consider using cfqueryparam for all query parameters. Especially when looping.

[Flashdakota · Accepted solution]

Thank you.
Sorted!