[freeside] cust_main.cgi error when executing a search for customer by lastname
ivan at 420.am
ivan at 420.am
Fri Oct 4 02:27:35 PDT 2002
It's not a typo. ILIKE does a case-insensitive LIKE. I didn't realize
it was introduced in Pg 7.1, not 7.0. I've updated the documentation.
I'll look into a more portable solution.
--
_ivan
On Fri, Oct 04, 2002 at 02:03:50PM +1200, Gordon Smith wrote:
> >
> > Error message reported by query - cust_main.cgi
> >
> > Errors Output
> > Error executing "SELECT * FROM cust_main WHERE last ILIKE ?":
> > ERROR: parser: parse error at or near "ilike" at
> > cust_main.cgi line 503 ,
>
>
> Edit cust_main.cgi and fix the typo. ILIKE is not a valid command -
> change it to LIKE
>
> Gordon Smith CCNA
> Network Operations Manager
>
> MoreNet Ltd
>
>
--
_ivan
More information about the freeside-users
mailing list