Multiple Form Database Inputs

[mostlySimple]

I have a paragraph with multiple html drop down boxes scattered throughout and
a hidden field assigned to it for ID puposes. Problem is when I have more than
1 paragraph in a page and try to do a database insert looping through the ID's
is easy, the problem is the mulitple dropdowns don't insert correctly....end up
all together instead of seperated. Any ideas???

[mostlySimple]

Forget it.....I usedt he #evaluate()# functiont to complete task.....
Originally posted by: mostlySimple I have a paragraph with multiple html drop
down boxes scattered throughout and a hidden field assigned to it for ID
puposes. Problem is when I have more than 1 paragraph in a page and try to do a
database insert looping through the ID's is easy, the problem is the mulitple
dropdowns don't insert correctly....end up all together instead of seperated.
Any ideas???

[Mike Nimer]

can you post some code?

---nimer

"mostlySimple" <webforumsuser@macromedia.com> wrote in message
news:cv4u0s$47k$1@forums.macromedia.com...

> Forget it.....I usedt he #evaluate()# functiont to complete task.....
> Originally posted by: mostlySimple I have a paragraph with multiple html
> drop
> down boxes scattered throughout and a hidden field assigned to it for ID
> puposes. Problem is when I have more than 1 paragraph in a page and try to
> do a
> database insert looping through the ID's is easy, the problem is the
> mulitple
> dropdowns don't insert correctly....end up all together instead of
> seperated.
> Any ideas???
>

[mostlySimple]

<cfset counter = 0> <cfloop index='I' list='#form.stateID#'> <cfset counter =
counter+1> <cfquery datasource='#ds#' username='#username#'
password='#password#'> INSERT INTO hpReports
(jobid,clientid,catid,stateid,canid) VALUES
(#form.jobid#,#form.clientid#,#form.catID#,'#listg etat(stateid,counter)#','#eval
uate('form.dropID#I#')#') </cfquery> </cfloop>