Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jai] Condition Object

Quote Reply
Re: [jai] Condition Object In reply to
I seem to have got it working using the code below.

I have also incorporated the DISTINCT function which was the topic of another thread in this forum (http://gossamer-threads.com/...orum.cgi?post=232191)

my $cond1 = GT::SQL::Condition->new (
'fieldname', '=', $home->{cgi}->{fieldname},
'fieldname2', '=', $home->{cgi}->{fieldname2});
$cond1->bool ('OR');
my $sth = $table->select ('DISTINCT fieldname', $cond1);

I will assume this is the correct way to do it, unless anyone comes back with another solution.


Subject Author Views Date
Thread Condition Object jai 2551 Feb 13, 2003, 3:57 PM
Thread Re: [jai] Condition Object
jai 2454 Feb 14, 2003, 4:58 AM
Post Re: [jai] Condition Object
Paul 2452 Feb 14, 2003, 5:08 AM