Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Selecting data where column not equal?

Jun 13, 2008, 1:21 AM
EZFrag
User (141 posts)
EZFrag's avatar
Jun 13, 2008, 1:21 AM
Post #1 of 3
Views: 3198
Shortcut
Quote Reply
Selecting data where column not equal?
Hi there Smile,I am using the following statement to pull some data from the database:
Code:
my $sth = $DB->table('mytable')->select({owner => $USER->{Username}, id => $rowID } );

My delema is that I don't want the rows 'where id = $rowID',
I want the rows 'where id != $rowID'.

I have searched through the forums and read through the documentation, but all I found was
information about 'larger than'('id-gt => $rowID') and 'less than'('id-lt => $rowID').

Sacrifice is not about what you lose,
it is about what you gain in the process.
Jun 13, 2008, 1:33 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 13, 2008, 1:33 AM
Post #2 of 3
Views: 3089
Shortcut
Quote Reply
Re: [EZFrag] Selecting data where column not equal? In reply to
Hi,

This should work:

Code:
my $sth = $DB->table('mytable')->select( GT::SQL::Condition->new('owner','=',$USER->{Username},'id','!=',$rowID) );

Hope that helps =)

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!
Jun 13, 2008, 1:48 AM
EZFrag
User (141 posts)
EZFrag's avatar
Jun 13, 2008, 1:48 AM
Post #3 of 3
Views: 3066
Shortcut
Quote Reply
Re: [Andy] Selecting data where column not equal? In reply to
Yes, that worked.
Thank you Andy Smile

Sacrifice is not about what you lose,
it is about what you gain in the process.