Recordset with filter condition

I have a client list database query that works fine without an parameters or filter.
However, when i add a condition to the query like ‘firstname contains’ i get an issue with the database query running.

here is a screenshot of what i have
Here is the Query setup

image1920×1080 250 KB

here is the output when i test it

image1920×1080 136 KB

here is the link to the query
http://mymondaymorningcoffee.com/dmxConnect/api/client_list.asp