[ic] Product Search by Alphabet

Greg Heath interchange-users@interchange.redhat.com
Tue Sep 18 01:07:00 2001


Lets try a new thread.
Basicly, it is a problem with the results of a search using % and LIKE to
find db entries starting with a letter.
The code has worked for several years under MV and when I upgraded the sites
to IC4.7 it still worked. It doesn't now that I have done a clean install of
Redhat 7.1 / Interchange 4.8.1 / Perl 5.6.1
I figure that it must be a missing perl module or a change in IC code.
1. Is the search parameter op=LIKE not valid under IC
2. or is the sql symbol % rejected by perl
Hit the page http://www.hwon.com.au/cgi-bin/products/results_index and try
the links yourself.
The code I use is here
Subject: [ic] FYI: Product Search by Alphabet
Date: Mon, 12 Mar 2001 11:41:57 +1000
http://developer2.akopia.com/archive/interchange-users/2001/msg02382.html

BTW: there is nothing in the error logs

Greg Heath
Web Development
Pacific Technologies International P/L
www.pacifictech.com.au
greg@pacifictech.com.au