RE: Select different records based on user input.

Do you want to OR or AND those fields? If OR, the SQL IN clause lets you specify a list if values, something like WHERE key IN (117,123,141). So, if #cb# is the field with the list you can do WHERE key IN (#cb#). If AND, then just loop through the list and AND conditions. -- Ben

Re: Select different records based on user input.

Wow, I appreciate the quick response. That solved the problem perfectly! Thank you very much. Now I'm inspired to buy your CF8 books :) Do you want to OR or AND those fields? If OR, the SQL IN clause lets you specify a list if values, something like WHERE key IN (117,123,141). So, if #cb# is

Re: Select different records based on user input.

be sure to pick up this one as well http://www.amazon.com/Sams-Teach-Yourself-SQL-Minutes/dp/0672325675/ref=pd_bbs_sr_3?ie=UTF8s=booksqid=1198826200sr=8-3 and if you are using mysql then get his crash course one instead the one above..