Error making a search system

[raulriera]

Hi all, this is a simple search system to lookup proyects that contains the
words in the querystring "palabras", but when running the code I get this error

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'FIRST WORD
HERE'. <---thats an example heh

The code is this one, the error ocurrs even if I use single quotes on the
words


<cfset palabrasClaves = #URL.palabras#>
<cfset lineaSQL = "">
<cfloop index="palabraBusqueda" list="#palabrasClaves#" delimiters = " :/">
<cfset lineaSQL = lineaSQL & "titulo LIKE " & "'%" & palabraBusqueda & "%'"
& " OR ">
</cfloop>
<!--- Borrar los ultimos 3 caracteres del string lineaSQL --->
<cfset lineaSQL = RemoveChars(lineaSQL,Len(lineaSQL) - 3,4)>
<!--- Hacer el query --->
<cfquery name="busquedaPropuestas" datasource="DNS">
SELECT * FROM ListadoPropuestas WHERE #lineaSQL#
</cfquery>

[jdeline]

You need to use PreserveSingleQuotes in the WHERE clause. See code below.



<cfquery name="busquedaPropuestas" datasource="DSN">
SELECT * FROM ListadoPropuestas WHERE #PreserveSingleQuotes(lineaSQL)#
</cfquery>

[raulriera]

thanks that worked like a charm... you are the man