jeffcullina
Programmer
I have a variable in vb script at the top of a page to determine the correct WHERE clause for a query. Then I build a custom query through the Database Results Wizard. I would like to use the variable in the query, but I cannot figure out the syntax for it. In the custom query portion of the Database Results Wizard, I have
SELECT tblMEL.* FROM tblMEL WHERE <%=var%>
The problem is, the wizard also writes the code in VB script so the %> part of my <%=var%> entry unintentially closes the code written by the wizard. Is there some way to do this?
SELECT tblMEL.* FROM tblMEL WHERE <%=var%>
The problem is, the wizard also writes the code in VB script so the %> part of my <%=var%> entry unintentially closes the code written by the wizard. Is there some way to do this?