[sql html] tag

["Greg LaPolla" <glapolla@earthlink.net>]

I am having a hard time figuring out why the following statement doesnt
work:

[sql html]select * from locator where zip='[value zcode]' order by
city[/sql]

for reasons I cannot figure out '[value zcode]' does not expand out.

yet I have a debug line set :

<h2>Value of zcode: [value zcode]</h2>

This line tells me that zcode has the correct value, however it will not
expand in the sql statement.  If I replace '[value zcode]' with some
arbitrary data like '94539'  it will grab the data and build the table
correctly.


I am stumped on this, any help is greatly appreciated.