Hi,
i need to put a condition in my global, like:
Select only the datarecords, which are "MagArt = "gumag".
How can i insert this condition?
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
my $ausgabe = $IN->param('Ausgabe');
$search_db->select_options ('ORDER BY Add_Date ASC Limit 20');
$sth = $search_db->select ( { Ausgabe => $ausgabe });
while ($link = $sth->fetchrow_hashref) {
if (length $link->{Title} > 200) {
$link->{Title} = substr($link->{Title}, 0, 20) . '...';
}
$output .= Links::SiteHTML::display ('login_gutscheine_include', $link);
}
return $output;
}
Thanks in advance!
Coyu
i need to put a condition in my global, like:
Select only the datarecords, which are "MagArt = "gumag".
How can i insert this condition?
Code:
sub { my ($output,$sth,$link);
my $search_db = $DB->table('Links');
my $ausgabe = $IN->param('Ausgabe');
$search_db->select_options ('ORDER BY Add_Date ASC Limit 20');
$sth = $search_db->select ( { Ausgabe => $ausgabe });
while ($link = $sth->fetchrow_hashref) {
if (length $link->{Title} > 200) {
$link->{Title} = substr($link->{Title}, 0, 20) . '...';
}
$output .= Links::SiteHTML::display ('login_gutscheine_include', $link);
}
return $output;
}
Thanks in advance!
Coyu