Gossamer Forum
Home : Products : DBMan SQL : Development, Plugins and Globals :

Problem in the globa .. extracting data from databasel

Quote Reply
Problem in the globa .. extracting data from databasel
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
Subject Author Views Date
Thread Problem in the globa .. extracting data from databasel sdsouza 3298 Oct 21, 2003, 4:17 PM
Post Re: [sdsouza] Problem in the globa .. extracting data from databasel
jai 3185 Oct 21, 2003, 4:59 PM