>>>>>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.
>>>>
>>>>i think this means that it doesn't see one (or more) of these fields as a field in footable...
>>>Exactly. variable isn't a field in footable, it is passed in by the user.
>>>
>>>How can I get VFP to recognize this?
>>
>> did u try m.variable ?
>>

What if you were to try macro substitution that would use the value of the variable instead of just the name of the variable...

Peter