Hi there,

I try to build a dynamic where. Since I always used it on numeric values, I didn’t encounter any problems. But now I want to build one to search columns of text.
And then it doesn’t work at all and I can’t seem to find the right syntax.
When amending the sql string with single quotes so the recordset knows the input is a string instead of numeric, Dreamweaver persists in making the single to double quotes. Even when inserted in a string like:
<%
Dim sql
If (request.form("naam"<>"" and (request.form("kleur"<>""then
sql="WHERE Product = " & "'" & Request.form("naam"& "'" & " AND kleuren = "& "'"& Request.form("kleur"& "'"
end if
%>
So I’m stuck trying to use a dynamic where clause on columns containing text. And I still don’t understand how Dreamweaver can make single to double quotes and how to prevent it from doing so.
Down below I made an example of what I try to do. So you can see it is based on numeric values. When these columns should be text, how can I amend my code to function?
Who can help me out here?

JJF