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
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
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#
3 matches
Mail list logo