[ic] HELP! query returns wrong values (but right number)

Bill Eichin subscriptions at eichin.org
Tue Mar 29 20:25:59 EST 2005

> This is wrong:
> my $sqm="SELECT DISTINCT id,name FROM aisle WHERE aisle.id=prodcat.aisle
> AND prodcat.dept=".$deptrow[0];
> Should be:
> my $sqm="SELECT DISTINCT aisle.id, aisle.name FROM aisle, prodcat
> WHERE aisle.id=prodcat.aisle AND prodcat.dept=".$deptrow[0];
> Without the second table in the from you won't get the relationship.
> It also probably isn't valid sql without it, but of course I have not
> checked that ;)
> I always find it best to ::Log("sql = $sqm\n") then cut N paste that
> into mysql when I have sql errors, it makes debugging a bit easier.
> Jeff

As it turns out, that part works fine.  Both ways.  The problem I'm
having is, once I have a valid list of SKUs, I can't figure how to pass
them back to IC to display them in a "results" format...

More information about the interchange-users mailing list