[flexcoders] Re: SQL Question

2010-02-20 Thread Jeff
I strongly recommend that you modify your database structure so that you do not store comma separated lists in a field. Read up on many to many relationships and intersection/linking tables. If I had to theorize on your problem; SQL is seeing your 'ageGroups' and 'accountType' fields as a

Re: [flexcoders] Re: SQL Question

2010-02-20 Thread Wally Kolcz
Thanks Jeff. I already started that process. I was hoping that since I have so many relationships I would have to do that...just being lazy. On 2/20/2010 8:00 PM, Jeff wrote: I strongly recommend that you modify your database structure so that you do not store comma separated lists in a

[flexcoders] Re: SQL Question

2010-02-20 Thread Laurence
First off, I would suggest making your query much simpler, just to diagnose the problem. Then add complexity to it and see if/when it goes wrong... Start with (for example): SELECT roomDisplay, roomID, ageGroup, accountType FROM chatrooms WHERE cfqueryparam value=#arguments.accountType#