CFLOOP and insert query

[cdw0308]

I am trying to use an insert query in my cfloops.
I started out with this code that displays the values to the page. It works just fine. Now I wanted to modify it to include an insert query that sent the data to a database

<cfset j = #total_count#>
<cfloop index = "RowCount" from = "1" to = #j#>
   <cfloop index="ColumnCount" from = "1" to = "3">       
           <cfoutput>#Evaluate("txt" & ColumnCount & "Row" & RowCount)#</cfoutput>&nbsp;&nbsp;
    </cfloop><br><br>
   <cfset j = j + 1>
</cfloop>

So i tried putting an insert query in and it does not work.

<cfset j = #total_count#>
<cfloop index = "RowCount" from = "1" to = #j#>
   <cfloop index="ColumnCount" from = "1" to = "3">
           <cfquery name="add_asset" datasource="#conn#">
            INSERT INTO asset (item_num, manuf, model_num) 
            VALUES('#item_num#', '#manuf#', '#model_num#')
            </cfquery> 
           
               <cfoutput>#Evaluate("txt" & ColumnCount & "Row" & RowCount)#</cfoutput>&nbsp;&nbsp;
    </cfloop><br><br>
   <cfset j = j + 1>
</cfloop>

When I enter 3 rows of data on my form i wanted it inserted into the table in 3 differant rows.
Any help would be greatly appreciated.

 

[imstillatwork]

Work it out... whats the error? Where in the code does the error occur? where are item_num, manuf, and model_num coming from?

what does your form look like, can we see it? I can't figure out what your loops are actualy for if this is from form data.

can you post your form code and all of the processing code for the form?


Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!