Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Bad columns / column clash cannot be solved

Quote Reply
Bad columns / column clash cannot be solved
Hi,

I ran over a promblem while trying to select from multiple tables.
There are Column Names which are in two tables. When I use a condition

Code:
my $cond = GT::SQL::Condition->new(SUPPLIER_ID => LIKE => "$query->{SUPPLIER_ID}");

I get the error:

Quote:
GT::SQL::Relation (3980): Bad columns / column clash: columns named

Turning it to table

Code:
my $cond = GT::SQL::Condition->new(TABLE.SUPPLIER_ID => LIKE => "$query->{SUPPLIER_ID}");

does something confusing and I cannot find a solution in Condition.pm

Quote:
Failed to execute query: 'SELECT * FROM ... AND (TABLE_SUPPLIER_ID LIKE ...)': Unknown column 'TABLE_SUPPLIER_ID' in ...

Thanks for any hint

Niko

Last edited by:

el noe: Dec 29, 2008, 1:08 AM
Subject Author Views Date
Thread Bad columns / column clash cannot be solved el noe 3501 Dec 29, 2008, 1:07 AM
Thread Re: [el noe] Bad columns / column clash cannot be solved
Andy 3455 Dec 29, 2008, 1:11 AM
Thread Re: [Andy] Bad columns / column clash cannot be solved
el noe 3420 Dec 29, 2008, 1:20 AM
Thread Re: [el noe] Bad columns / column clash cannot be solved
Andy 3421 Dec 29, 2008, 1:24 AM
Thread Re: [Andy] Bad columns / column clash cannot be solved
el noe 3414 Dec 29, 2008, 1:28 AM
Post Re: [el noe] Bad columns / column clash cannot be solved
Andy 3415 Dec 29, 2008, 1:28 AM