Multiple select of list boxes

[sage703]

I am allowing my users to select multiple items in a list box, and I've set
that up so it works swell. However, I'm unsure how to set each of the values
selected into a Coldfusion variable. Do I need to use arrays? If so, how would
I go about doing this with multiple selections from a listbox?

FYI: Here's what my listbox looks like currently:

<cfselect query="location" multiple="yes" size="5"
name="Location" value="Location" selected="#SESSION.ProgWiz.Location#"/>

Thanks,
S./:confused;:|

[MikerRoo]

You don't need arrays.
CFSelect returns multiple values as a comma-seperated list.

So the form's action page would see the variable FORM.Location and if multiple
values were selected, FORM.Location's value might look like
"Apple,Banana,Cherry".

You could use <CFLOOP index="Fruit" List="#FORM.Location#"> to get at and
process the selections.

-- MikeR

[sage703]

Ok, so in another segment of code (let's say on the session processing page), I
could insert each of the values in the list into my table as separate records
using code such as this:

<cfif IsDefined("#SESSION.ProgWiz.Location#">
<cfloop index=i loc_list="#SESSION.ProgWiz.Location#">
<cfset index(i) = loc_list>
</cfif>

INSERT INTO <tablename>(
<fieldname1>
<fieldname2>
etc...
VALUES (
<cfif index>
index(i)
</cfif>
<fieldname2>
etc....)

That seems sort of right, but not quite (for example, i'll need to loop the
index value in the INSERT statement so I can make multiple entries at once. Do
you have any more useful tips Mike?

S./