Hi,

I would like to list all links with Field1 not equal to Field2.

This is producing the desired result but how to convert this into a global

SELECT ID, Title
FROM `Links`
WHERE Field1 != Field2


Thanks in advance!

Maybe;


Untested, but it should work

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Thanks Andy!

I ended up using:


sub {
my $output;
my $cond = GT::SQL::Condition->new('Field1','!=','Field2');
my $sth = $DB->table('Links')->select($cond) || return $GT::SQL::error;
my @output;
while (my $hit = $sth->fetchrow_hashref) {
push (@output, $hit);
}
return {
diff_loop => \@output };
}



But, somehow this caches results.

If I change values to match (Field1 = Field2) this global will still show this ID/link ...

Thanks in advance!

Not certain but I think you probably need a \ before 'Field2' - otherwise it will be looking for the text 'Field2' rather than the field value.

Yes!

Thanks afinlr!