Try: where peopleid IN (#form.availabletest#)
-----Original Message----- From: Toby King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 9:52 PM To: CF-Talk Subject: Re: code not working For some reason when I dumped the form neither of the boxes were displayed as being in the form and I have not been able to figure out why - its a mystery. So I have decided on an alternative strategy initially. Hi there I have now placed a select list on a page which is working properly. I have dumped the form and if I select 3 records from the list I have 3 items selected. So good so far. These 3 items are recordids - I want to use them in a query such as The code shows the select list and then after that is the query to select the records to use later on in the page. Thanks in advance. Toby <select name="availabletest" size="10" multiple style="width:200;"> <cfloop query="getpeople"> <option value="#people_id#">#People_LastName#, #People_FirstName#</option> </cfloop> </select> SELECT p.people_id, p.people_FirstName, p.people_LastName >From tbl_people p where peopleid = #form.availabletest# order by p.people_Lastname Thanks in advance for feedback T >I usually use javascript to loop through the box and select all the >option items prior to submitting the form. > >Something along the lines of: > >if(formref.fldname.length > 0){ > for (i=0; i<formref.fldname.length; i++) { > formref.fldname[i].selected = true; > } >} > >Cheers, >Kris > >> I'm struggling with how to use the names in the right hand side box. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
