On the actionpage:
<cfloop list="#FORM.dlo_id#" index="id">
<cfquery name="ins" datasource="YourSource">
INSERT INTO YourTable (YourField)
VALUES (#id#)
</cfquery>
</cfloop>
rgds
* Holger Lockertsen, Solutions Developer, Horisont Information Systems AS
* Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
* 23 31 03 04 / 91 83 20 51
* [EMAIL PROTECTED] http://www.horisont.no/
NB! Horisont har fått nye nummer, og mitt INTERNNUMMER er: 23 31 03 04
-----Original Message-----
From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 3:58 PM
To: [EMAIL PROTECTED]
Subject: Processing multiple selections from a select list box
How do I process multiple selections from a list box?
My list box is populated with values from a query (see code), and I want the
user to be able to select one or more values. I then want to insert the
values selected into an Oracle table, along with the user's ID, which is
determined elsewhere.
Sorry if this is a newbie question, but I can't find ANY info on this topic.
Thanks.
<cfquery datasource="cdev" name="get_del_locn" debug="yes">
select dlo_id, dlo_locn
from del_locn
order by dlo_locn
</cfquery>
...
<select name="dlo_id" size ="5" multiple width="150">
<cfoutput query="get_del_locn">
<option value="#dlo_id#">#dlo_locn#
</cfoutput>
</select>
~~~~~~~~~~~~~~~~~~~~~~~~
Ricq Pattay <[EMAIL PROTECTED]>
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
