Looping an array into a DB

saves it into one DB field

If you mean storing a delimited list like: "1,5,6,8" in a single column ... definitely do not do that.

I was thinking I would need to change the DB fields to

something like:

itemname1

itemname2

itemname3

...

It sounds like you could also use some assistance on the table structure. When you find yourself creating the same column name over and over, only differentiated by a number (like Widget1,Widget2,Widget...), the data is better represented as separate records. Then you can have as few or as many entries as needed.

Columns: ItemID (FK), ItemQuantity, ItemPrice, ItemTotal

One way might be to store the array as a session variable. Then it wont get lost. For example,

<cfset session.order = arrayNew(2)>

<!--- for product item 1 --->

<cfset session.order[1][1] = orderID>

<cfset session.order[1][2] = itemname1>

<cfset session.order[1][3] = itemname2>

... etc

<!--- for product item 2 --->

<cfset session.order[2][1] = orderID>

<cfset session.order[2][2] = itemname1>

<cfset session.order[2][3] = itemname2>

... etc

OrderID is the primary key of the database table.

This will do it...

<cfset myArray = ArrayNew(2) />
<cfset myArray[1][1] = "apples" />
<cfset myArray[1][2] = "bananas" />
<cfset myArray[1][3] = "cherries" />
<cfset myArray[2][1] = "1.00" />
<cfset myArray[2][2] = "2.00" />
<cfset myArray[2][3] = "3.00" />
<cfset myArray[3][1] = "10" />
<cfset myArray[3][2] = "20" />
<cfset myArray[3][3] = "30" />
<cfset myArray[4][1] = "10.00" />
<cfset myArray[4][2] = "40.00" />
<cfset myArray[4][3] = "90.00" />

<cfloop index="i" from="1" to="#ArrayLen(myArray)#" step="4">
    <cfloop index="j" from="1" to="#ArrayLen(myArray)#">
        <cfquery datasource="#request.dsn#">
        INSERT INTO
            ITEM
        (
            ITEMNAME,
            ITEMPRICE,
            ITEMQUANTITY,
            ITEMTOTAL
        )
        VALUES
        (
            '#myArray[1]#',
            #myArray[2]#,
            #myArray[3]#,
            #myArray[4]#
        )
        </cfquery>
    </cfloop>
</cfloop>