Aaron, Charlie, Besides the pipe on list, I've actually been debating whether to use this approach even for the simplest requirement. Yep, I'll just throw it on a table, what the heck! Many thanks, guys.
-----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 2:16 PM To: CF-Talk Subject: Re: Using Pipe character "|" as a list delimeter in varchar fields Yeap, I'd highly recommend against an approach like this. People at my work do this a lot and then struggle with how to search on it since you can not write a simple query to find all "lists" that contain "foo" I am sure there are many other reasons not to, that is just the first one that comes to mind with what I see at work. On 3/17/06, Charlie Griefer <[EMAIL PROTECTED]> wrote: > > ermm...the question will arise as to why you're storing delimited > lists in a relational database :) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
