cfquery - multiple combinations

[TiGGi]

Hi, Can someone plz point me into the wright direction,
I have a search query that takes comma-delimited list from form and search a field with comma delimited list.
so WHERE 1,3,56,78 = 1,2,3,4,56,53
How can I accomplish this?

[Dan_Bracuk]

Normalize your database and you won't have problems like this.

[Newsgroup_User]

yep. normalize it.
hmm... iirc a lot of people told you that on one of your previous posts
about something else about this list in a db field...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Newsgroup_User]

> Hi, Can someone plz point me into the wright direction,
> I have a search query that takes comma-delimited list from form and search a
> field with comma delimited list.
> so WHERE 1,3,56,78 = 1,2,3,4,56,53
> How can I accomplish this?

The best place to ask SQL questions might be on an SQL forum, rather than a
ColdFusion one. And answers will vary depending on which DB system you're
using, so it's always a good idea to ask this sort of question on a
vendor-specific forum.

I do agree with theother respondents that - given the limited information
you've presented - that it does look like your data model needs some work,
if you're finding yourself needing to do this sort of thing.

--
Adam