On 6/10/07, Chris Travers <[EMAIL PROTECTED]> 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 > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel > > > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
