Re: [flexcoders] SQL Question

2010-02-22 Thread Tim Romano
Hard to know for sure from the way you've put the question, but the IN lists seem malformed to me. Correct: IN (a, b, c) Incorrect: (a, b, c) Regards Tim Romano On 2/20/2010 6:04 PM, Wally Kolcz wrote: I know this is out of the core topic, but I am banging my head on this simple

Re: [flexcoders] SQL Question

2010-02-21 Thread Jochem van Dieten
On Sun, Feb 21, 2010 at 12:04 AM, Wally Kolcz wrote: I have a record where 'ageGroups' is '0, 1, 2, 3, 4, 5, 6, 7, 8' and the 'accountType' is 'kids, siblings, parents' As other have said, your schema is all wrong. But for this simple scenario it is doable to fix it with string manipulation:

[flexcoders] SQL Question

2010-02-20 Thread Wally Kolcz
I know this is out of the core topic, but I am banging my head on this simple issue..or probably is... I am trying to write a SQL query (in ColdFusion) for my database (MySQL 5) when I am looking for a passed in argument value in the column (which is set as a varchar). I am passing in '0' for