Dynamic Where variable

[web-eng]

I'm attempting to create a complete "Where" statement and save it to a variable.
It works fine when comparing a numeric field against a number but errors when
comparing a text field with text.

Using MS Access and CF7.

Suggestions please.



This code works.
<cfset where_variable = "where people.id =" 1>

<cfquery name="staff" datasource="company">
SELECT people.*
FROM people
#where_variable#
</cfquery>

This code doesn't
<cfset where_variable = "where people.first_name = 'bob' ">

<cfquery name="staff" datasource="company">
SELECT people.*
FROM people
#where_variable#
</cfquery>

[PaulH *TMM*]

web-eng wrote:

> <cfquery name="staff" datasource="company">
> SELECT people.*
> FROM people

#preserveSingleQuotes(where_variable)#

> </cfquery>

[web-eng]

Thanks Paul,

works a treat.

:)

[raulriera]

I know that solved ur error, but I tried using that and it doesnt work for me

<cfset lineaSQL = lineaSQL & " AND Usuario.sexo = '" & formulario.sexo & "'">

WHERE #PreserveSingleQuotes(lineaSQL)#

Trows an error

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'm'

that "m" is the data of that formulario.sexo variable

[web-eng]

Try <cfset lineaSQL = lineaSQL & " AND Usuario.sexo = " '#formulario.sexo#' >