epipko
09/21/2022, 11:13 PM<CFLOOP query = "ship_details">
<tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('f8f8f8'))#">
<TD class="TDC" align="right"><INPUT TYPE="CHECKBOX" name="MYCHECKBOX" value="#ship_details.cust_po_nbr#" ID="chkPo" checked></TD>
<TD class="TDC">#ship_details.cust_po_nbr#</TD>
<TD class="TDC">#ship_details.store_id#</TD>
<TD class="TDC">#ship_details.numb_of_cart#</TD>
<TD class="TDC">#ship_details.total_qty#</TD>
<TD class="TDC">#ship_details.weight#</TD>
<TD class="TDC">#ship_details.volume#</TD>
<cfif form.soldto EQ "AMAZON">
<TD class="TDC"><cfinput name="pallets" type="text" size="10"></TD>
</cfif>
</TR>
</CFLOOP>
When I try to do streight insert into a table, I am getting an error (too many values) because value for "pallets" comes across as "1,1,3,4,6"
How do I loop over checked lines?Michael Schmidt
09/22/2022, 1:01 PMepipko
09/22/2022, 3:15 PMMichael Schmidt
09/22/2022, 3:28 PMepipko
09/22/2022, 4:17 PMMichael Schmidt
09/22/2022, 4:57 PMEvil Ware
09/22/2022, 5:47 PMcfloop from="1" to="100" index="i">
<cfif ((i MOD 100) EQ 1)>
INSERT INTO MyTable
(
[MycolName]
)
VALUES
</cfif>
(
'#i#'
)
<cfif (i LT 999)><cfif ((i MOD 100) NEQ 0)>,</cfif>#CHR(13)##CHR(10)#</cfif>
</cfloop></cfquery>