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:301229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
