Hi all. I'm trying to work out a web-base query with web-link, and I'm having trouble including a variable in the SQL SELECT command:

SELECT foo, foo2, foo3 FROM footable where foo1 = variable
^^^^^^^^

This is where it goes boom, with an error message of can't find column viariable.