While working on a multi-option search function for a client, I kept encountering a ColdFusion error, ‘Invalid Parameter Binding’. After much googling, I had found no solution that worked for me. Then I noticed that I had coded my parameter as such:

Maybe a silly mistake, but the solution was profoundly simple, even if the error message was not very informative. Updating my code to remove the single quotes and include the % inside of the cfqueryparam tag was all that needed to be done.