[ic] stumped on another sql query

Aaron Hazelton interchange-users@icdevgroup.org
Fri Sep 6 16:08:01 2002


> Scott Andreas wrote:
> > Aaron Hazelton wrote:
> > 
> > Hi All,
> > 
> > You may recall that I was working on a [query sql.....]
> > yesterday to get the no-match to work.
> > 
> > I have taken the same exact results page code from the
> > local server that I was testing it on and put it on a production
> > server and you *never* get results.  inputting the exact
> > query string into the production servers mysql command
> > line provides results with no problems and logged in as the
> > same user that IC is set up with.
> > 
> > the only differences are:
> > production server IC 4.8.3, mysql 3.23.36
> > local server IC 4.8.6, mysql 3.23.52
> > 
> > any ideas where im off?
> > 
> > thanks,
> > Aaron
> > 
> > sounds like a mysql permission problem to me. double check 
> > them, make sure
> > you have access rights and check the mysql log file as that 
> > will give you
> > hints as to what is happening.
> > 
> > Scott
> > 
> As I said, I can log into mysql using the *exact same* user/
> password that is set in IC and it works just fine.  Also, all of 
> the other searches set to st=db work also, wouldn't they fail
> too??  there is no IC error either.
> 
here is some more (possibly helpful) information.... I was
messing around with the quotes ( " ) and so IC did not 
interpret the query, then on the page you see this:

SELECT sku, title, price, description FROM products 
WHERE description LIKE %ARRAY(0x8370584)%;

instead of:

SELECT sku, title, price, description FROM products 
WHERE description LIKE % (the search value) %;

im in the dark, does that mean anything?

Aaron