Hi,
I am new to DBMan SQL.. have started using it just few days back . ,, I wrote a global to extract data from the database and it gave me an error
here is the global
sub {
use GT::Date qw/:all/;
my($tags) = shift;
my $accountid = $tags->{AccountID};
my $table33 = $DB->table(\'tblClients\');
my $sth33 = $table33->select ([\'ClientID\'], {AccountID => $accountid});
$sth33->execute();
my $clientid = $sth33->fetchrow();
my $output= $clientid;
return $output;
}
the error message is :
Unable to compile 'inv_po'. Reason: Can't find string terminator "'" anywhere before EOF at (eval 18) line 4.
Can somebody help me with this . please .. also i would like to know ... what exactly is the use of putting
"my" before the variables
I am new to DBMan SQL.. have started using it just few days back . ,, I wrote a global to extract data from the database and it gave me an error
here is the global
sub {
use GT::Date qw/:all/;
my($tags) = shift;
my $accountid = $tags->{AccountID};
my $table33 = $DB->table(\'tblClients\');
my $sth33 = $table33->select ([\'ClientID\'], {AccountID => $accountid});
$sth33->execute();
my $clientid = $sth33->fetchrow();
my $output= $clientid;
return $output;
}
the error message is :
Unable to compile 'inv_po'. Reason: Can't find string terminator "'" anywhere before EOF at (eval 18) line 4.
Can somebody help me with this . please .. also i would like to know ... what exactly is the use of putting
"my" before the variables