my $variable = "12,23,34";
my $variable = "'12','23','34'";
my $variable = "['12','23','34']";
my $variable = "(12,23,34)";
my $variable = "('12','23','34')";
I tried all of them for that:
my $all_db = $DB->table('Links');
$all_db->select_options ("ORDER BY Contact_Name", "");
my $sth = $all_db->select ( ['ID','Title','aLogo','Contact_Name','Hits'],
GT::SQL::Condition->new (
ID => IN => $variable
) );
while (my ($id,$title,$logo,$name,$hits) = $sth->fetchrow_array) {
...
I stuck with passing IDs to this SQL. Anyone here with help, please?
my $variable = "'12','23','34'";
my $variable = "['12','23','34']";
my $variable = "(12,23,34)";
my $variable = "('12','23','34')";
I tried all of them for that:
my $all_db = $DB->table('Links');
$all_db->select_options ("ORDER BY Contact_Name", "");
my $sth = $all_db->select ( ['ID','Title','aLogo','Contact_Name','Hits'],
GT::SQL::Condition->new (
ID => IN => $variable
) );
while (my ($id,$title,$logo,$name,$hits) = $sth->fetchrow_array) {
...
I stuck with passing IDs to this SQL. Anyone here with help, please?