DataAssist Search to Test that a column contains a value

I am trying to add a search parameter to search a column that contains URLs. I want the user to be able to either select a checkbox or maybe a yes/no dropdown to find results if a field contains a value or not. It doesn't need to match the value...only show results that contain a value. I tried using the "Check" type but it is saying that the recordset must match a NULL or "" entry and I would get an error if it tried to match anything else. Of course, I did get a SQL error. So would the strategy be to add a recordset column that already had the logic of that URL column set to either Yes or No?

You can use a checkbox or a yes/no dropdown. You can use the check type. I'd have to see the page and error to tell you what is wrong.

The error I am getting is: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"")' at line 1". Attached is a screenshot of the settings and I only get the error when checking the box for this field.

The RecordingLink is basically a URL and I am just trying to return results where there is an entry. It doesn't have to match anything.

Please attach the page you are working on.

I think the checked value setting should be set to "IS NOT" and the value "NULL"

If you give me a url and ftp access I can debug this more efficiently instead of guessing.

Thank you, Ray. I was able to address this by creating a conditional statement in my SQL statement to output yes or no if the column was empty or not and then do a direct comparison to that. Perhaps I could have solved this with Dataassist only, but I don't allow Nulls in that column and it seemed that was the issue I was hitting.