On 8/3/06, Mark A Kruger <[EMAIL PROTECTED]> wrote: > Patrick, > > You can create a UDF that allows for list functions. Here's blog post on the > topic. > > http://mkruger.cfwebtools.com/index.cfm?mode=entry&entry=87616A7F-D611-F201- > A72DB4B567CFA1F7 >
The UDF that Mark is blogging about looks like it will get you what you want, but do keep in mind that if you use a UDF like this in the WHERE clause, it will be executed for every potential row. This might be fine if you have a small dataset, but for a large amount of data, it will slow your query down quite a bit. It would be better to put category information into a separate table, if possible. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
