WHERE empid IN (<cfqueryparam list="yes" value="#form.empid#" cfsqltype="cf_sql_varchar">)
hth Azadi Saryev 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:301230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4