Need Help writing cfloop query

i have form variables in duplicate. example have id1, id2, id3. have loop , query set this:

<cfloop index="i" from="1" to="3">
<cfquery name="insert_info" datasource="#dsn_slave#">
insert new_samples (email, id, od, id_min, id_max, cs_min, cs_max, material, durometer, quantity, units_of_measure, timestamp) values (#email#, #id#, #od#, #id_min#, #id_max#, #cs_min#, #cs_max#, #material#, #durometer#, #quantity#, #measure#, #createodbcdatetime(now())#)
</cfquery>
</cfloop>

how set id1 in loop meaning how write use index=i add 3 sets of values?

assuming you're form fields required, validated, checked existence, etc., take following approach:

<cfloop from="1" to="3" index="i">
<cfquery name="instform" datasource="dsn">
insert new_samples (email)
values ('#form["email"&i]#')
</cfquery>
</cfloop>

naturally, add in other fields...i'm lazy write whole query :)!

hope helps!
craig

More discussions in ColdFusion

adobe