[freeside] cust_main.cgi error when executing a search for customer by lastname

[ivan at 420.am]

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