[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Error: searching for customer by address field

OK, two things:
1.  why don't you use ILIKE instead of LIKE and you can forget about
case (and that OR clause that's giving you the error).
2.  your problem is in the second "%street%".  Change the double
quotes to single quotes and the error will go away.

Suggestions noted.  Will be committed shortly.


David A. Bandel
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
Ledger-smb-devel mailing list