Hi Azadi
That works but if a user selects 2 employees, it is only handling the first id. Thanks On Fri, Mar 14, 2008 at 4:19 PM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > WHERE empid IN (<cfqueryparam list="yes" value="#form.empid#" > cfsqltype="cf_sql_varchar">) > > hth > > Azadi Saryev > Sabai-dee.com <http://sabai-dee.com/> > http://www.sabai-dee.com/ > > > > Toby King wrote: > > Hi there > > > > I am developing a form for an organisation for their HR section to > report on superannuation contributions etc. > > > > HR want to be able to select 1 or more staff members to report on at any > one time. > > > > I have a list/menu in the form where a user can select 1 or more names > to report on. > > > > After a user fills in the form I pass them to a confirmation screen to > allow them to either proceed or return to the form to make amendments. > > > > If a user selects only one prson everything works fine when displaying > the names. If 2 or more people are selected the names are not displayed. > > > > >From the selection form I am passing over multiple empids in the > format, 3173B704-19-02-08,E6A2E4D1-05-02-08 (just shown are 2 empids. > > > > Now in the confirmation screen I have a query > > > > > > SELECT * FROM tbl_employees WHERE empid = '#form.empid#' > > > > > > How do I handle this - I am guessing I will have to do an unstring or > something > > > > Thanks in advance. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
