Michael Traher Systems Manager ICLP (London) Tel: UK +44 (0) 20 8256 9072 Fax: UK +44 (0) 20 8681 0234
This e-mail may contain privileged and confidential information and/or copyright material and is intended for the use of the addressee only. If you receive this e-mail by mistake please advise the sender immediately by using the reply facility in your e-mail software and delete this e-mail from your computer system. You may not deliver, copy or disclose its contents to anyone else. Any unauthorised use may be unlawful. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of ICLP. >Isaac, cheers for your time, I really do appreciate it but I am now >halfway built on a method as time is now short..... Probably too late but I did have some thoughts which you might want to develop regarding the use of string functions in SQL. You could extract 'meta-data' about your parent_answers by using something like locate(parent_answer,',') and shift(parent_answer,-(locate(parent_answer,',')) or similar string functions if available on your DBMS locate finds the first occurrence of ',' and shift chops the front of the string off so you can start looking for the next ','. so rather than your UDF separating the items sql can do this using locate, shift and substring or left and right functions. You can explore this idea if it performs badly Michael Traher ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
