[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.

Ciao,

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.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel