Need help with SQL IN clause regarding a multiple selection box
Posted on 2007-04-02
In the middle of an SQL query i have the following line:
WHERE location IN ('#form.categories#') where the form.categories is the list returned from a multiple selection list box. This query is not behaving properly because that last term gets evaluated as, for instance, the following: Where location in ('Long Island, New York') Where what i really need is the following: Where location in ('Long Island', 'New York') So you see, the quotes are not in the right place for proper functionality. Can anyone tell me what I am doing wrong or how to fix it? thank you.