If you have a form that gathers an element where the user can enter several items separated by commas, coldfusion gives you a couple of ways to deal with the sql statement. In older versions you might loop through the formelement.values. But in CF8 forward you can use CFQueryParam with the LIST=”yes” attribute.<\/p>\n
Example
\nFormElement Favorite_fruits [apples,oranges,pears]<\/p>\n
You may also need to deal with spaces between fruits by using character replacement. In this case I get rid of all spaces.<\/p>\n If you have a form that gathers an element where the user can enter several items separated by commas, coldfusion gives you a couple of ways to deal with the sql statement. In older versions you might loop through the … Continue reading SQL -- Who else likes your favorite foods?
\nselect people from favorite_foods_table
\nwhere favorite_fruits in (<cfqueryparam value=\"#favorite_fruits#\" list=\"yes\" \/>)
\n<\/code><\/p>\n<cfqueryparam value=\"#rereplace(favorite_fruits, ' ', '','ALL')#\" list=\"yes\" \/><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"