sql search and syntax errors in coldfusion search page

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
this works all ok it seems.

HOWEVER
when i try and serach for a trailing < straight after the word like
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?

re: sql search and syntax errors in coldfusion search page

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

and

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

re: sql search and syntax errors in coldfusion search page

What's the error message?
Are you using an editor?

re: sql search and syntax errors in coldfusion search page

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

re: sql search and syntax errors in coldfusion search page

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.