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

Re: Error: searching for customer by address field



On 6/10/07, Chris Travers <..hidden..> wrote:
> 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.

Ok.  Committed.  People who want the fix can copy CT.pm out of SVN.

Best Wishes,
Chris Travers

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