Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [Andy] About perl, doing SQL with an array

Quote Reply
Re: [Andy] About perl, doing SQL with an array In reply to
Code:
my $cond = GT::SQL::Condition->new(
'isValidated' => '=' => 'Yes');

$links_db->select_options ("GROUP BY Links.ID ORDER BY Mod_Date DESC", "LIMIT 30");
my $sth = $links_db->select( ['Links.ID','Title','URL'] => $cond );

while (my $link = $sth->fetchrow_array) {

print $link->{'ID'};

}

It is empty. :(
Subject Author Views Date
Thread About perl, doing SQL with an array Robert 8679 Mar 14, 2014, 6:50 AM
Thread Re: [Robert] About perl, doing SQL with an array
Robert 8547 Mar 14, 2014, 6:55 AM
Post Re: [Robert] About perl, doing SQL with an array
Andy 8491 Mar 14, 2014, 7:09 AM
Thread Re: [Robert] About perl, doing SQL with an array
Andy 8519 Mar 14, 2014, 6:58 AM
Thread Re: [Andy] About perl, doing SQL with an array
Robert 8536 Mar 14, 2014, 7:08 AM
Thread Re: [Robert] About perl, doing SQL with an array
Andy 8593 Mar 14, 2014, 7:12 AM
Thread Re: [Andy] About perl, doing SQL with an array
Robert 8530 Mar 14, 2014, 8:15 AM
Thread Re: [Robert] About perl, doing SQL with an array
Andy 8585 Mar 14, 2014, 8:18 AM
Thread Re: [Andy] About perl, doing SQL with an array
Robert 8508 Mar 14, 2014, 9:53 AM
Thread Re: [Robert] About perl, doing SQL with an array
Andy 8499 Mar 14, 2014, 9:54 AM
Thread Re: [Andy] About perl, doing SQL with an array
Robert 8491 Mar 14, 2014, 10:15 AM
Thread Re: [Robert] About perl, doing SQL with an array
Robert 8488 Mar 14, 2014, 2:57 PM
Post Re: [Robert] About perl, doing SQL with an array
Andy 8464 Mar 15, 2014, 1:15 AM