loop over flash array in cfc..

[fu-meng]

hi.

i'm passing a simple array from flash to a cfc and trying to understand how to
loop over it using an index loop to make my sql inserts. i just don't know the
proper way to loop over the array. here's the basic format of my array from
flash:

myArray = ["one", "two", "three'];

what i want to do is insert each element of this array into a separate field
in my table.

and this is what i'm doing in the cfc:

any help on how to just get started is very much appreciated. thank you.



<cffunction name="logStuff" access="remote">

<cfargument name="myArray" type="array" required="yes">

<cfset mLen = ArrayLen(myArray)>

<cfloop index="i" from="0" to="#mLen#">

<cfquery name="logStuff" datasource="myDB">
INSERT INTO myTable( id,
subject,
body,
field1,
field2,
field3 )

VALUES ( '??',
'??'',
'??',
'??',
'??'
'??')

</cfquery>

</cfloop>

</cffunction>

[fu-meng]

update: i'm able to pull one of the items in my array but the problem is that i
have 3 elements in my array and only 1 record is being created in my database.
here's my updated code:

<cffunction name="logStuff" access="remote">

<cfargument name="myArray" type="array" required="yes">

<cfset mLen = ArrayLen(myArray)>

<cfloop index="i" from="0" to="#mLen#">

<cfquery name="logStuff" datasource="myDB">
INSERT INTO myTable( id,
subject,
body,
field1 )

VALUES ( 'id',
'subject',
'body',
'#arguments.myArray[i]#' )

</cfquery>

</cfloop>

</cffunction>

[fu-meng]

got it. i was overwriting a key in my database and that was causing problems. my cf code was correct.

thanks for following along.

fumeng.