Dynamic "Where" Clause

[bjr3g]

I'm trying having trouble building a dynamic "where" clause for a search page.
I'd like to use the cfqueryparam tag to pass the values. However, every time I
try to inlude angle braket tags within a tag contained in a string, I either
get an error or no string at all.

Here's my code which isn't working:

<cfset whereclause = "dbo.mytable.state = <cfqueryparam value=""#state#""
cfsqltype=""CF_SQL_VARCHAR"" >" >

Could anyone help with the syntax. I tried several variations with single and
double quotes but no luck.

Still a newbie,

Thanks

[WebXperience]

Try using "<>"

[bjr3g]

Thank you for responding. That seemed to get me a little closer, however, when
I execute the Select statement, it doesn't seem to translate the angle brackets
and an error message appears.

<cfset whereclause = "dbo.mytable.state = " & "<" & "cfqueryparam
value='#state#' cfsqltype=""CF_SQL_VARCHAR""" & ">">


<cfquery name="table1" datasource="myDB">
SELECT FirstName, Fullname, LastName, Address1,
City, State, Zip, Country FROM dbo.mytable
WHERE #PreserveSingleQuotes(whereclause)# ORDER BY dbo.mytable.state
</cfquery>


Here's the SQL statement in debug mode (doesn't translate the html code).

SELECT FirstName, Fullname, LastName, Address1, City, State, Zip, Country FROM
dbo.mytable WHERE dbo.mytable.state = <cfqueryparam value='CA'
cfsqltype="CF_SQL_VARCHAR"> ORDER BY dbo.mytable.state

Thanks!