sql search and syntax errors in coldfusion search page

[grabit]

Hi Peoples

I am using sql to search for whole words in a string "listtext". on the search form my field is named "search" (without the ""'s)
to search for a whole word with a > in front of it I am using

OR listtext LIKE '%>#form.subject#%' 

this works all ok it seems.

HOWEVER
when i try and serach for a trailing < straight after the word like

OR listtext LIKE '%#form.subject#<%'

I get a syntax error when it runs

Also as soon as i add that < to the line of code the rest of the line after it changes color to blue indicating that there is something wrong with the code or there is something missing

Can anyone please help with just how i can use the sql to search for a word with a space infront of it and a < straight after it please?

[MMcCarthy]

This SQL statement is querying an Access database and I've been helping the OP out from the Access end.

For the purposes of Access query needs to read

OR listtext LIKE '%>SomeText%'

and

OR listtext LIKE '% SomeText<%'

The space after the first wildcard is deliberate in the second statement. Also Access would actually use * as the wildcard but I didn't want to confuse the situation.

Mary

[acoder]

I get a syntax error when it runs

What's the error message?

Also as soon as i add that < to the line of code the rest of the line after it changes color to blue indicating that there is something wrong with the code or there is something missing

Are you using an editor?

[grabit]

the only error msg i get is that there is a syntax error
and yes im using dreamweaver

[acoder]

I've not come across this problem before, but it seems as though < is being 'recognised' as the opening character of a tag.

Try constructing your query outside the cfquery tag as a string and then just use that variable within cfquery and see if that solves the problem.