I think the script dropping the prefix to the database table might be a bug. I've managed to get around it by manually getting and adding the prefix to the table name like this...
my $prefix = $DB->prefix ;
my $cond = GT::SQL::Condition->new( "easy_pols.pol_id" => '!=' => \"${prefix}easy_relations.pol_id_fk");
I'm developing on LinkSQL Version: 2.2.0 so I'm not sure if this may have been addressed in the new version - if you're part of the dev team or can put a word in andy perhaps you could find out?
Regan
Code:
my $table = $DB->table('easy_pols', 'easy_relations'); my $prefix = $DB->prefix ;
my $cond = GT::SQL::Condition->new( "easy_pols.pol_id" => '!=' => \"${prefix}easy_relations.pol_id_fk");
I'm developing on LinkSQL Version: 2.2.0 so I'm not sure if this may have been addressed in the new version - if you're part of the dev team or can put a word in andy perhaps you could find out?
Regan