Loops and Lists - ColdFusion rookie 1

[ryanrat]

I have a variable, #form.AddUserID#, that is passed into the page in a list format, sepearted by a comma. The list length is variable(guessing i need to use #ListLen()# at some point). From what I've read in the forums, a <cfloop> is what I need to use, but I'm a little confused on the structure of the loop, and how I should use the index to reference the list. Thanks for all the help.

 

[JHoarty]

<cfset myList = &quot;#form.AddUserID#&quot;>

<cfloop list=&quot;#myList#&quot; delimiters=&quot;,&quot; index=&quot;ListElement&quot;>

<cfquery ...>
INSERT INTO myTable (userID, Name)
VALUES ('#ListElement#', '')
</cfquery>

</cfloop>

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[ryanrat]

John -

Thanks! That has totally explained the usage!