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
I get the error:
Turning it to table
does something confusing and I cannot find a solution in Condition.pm
Thanks for any hint
Niko
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 namedTurning 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