Displaying 2 results from an estimated 2 matches for "selectrow_array".
2006 Feb 08
1
Possible AGI Bug in Asterisk?
...on the time and extension dialed
$ti = time();
$dir = "/vol/recordings/";
$finame = $ti."_".$extn;
$fname = $dir.$finame;
$finame = $finame.".gsm";
# populate the DB with the required information
# Agent, Filename, date, time
# Get the Date and Time
$gdate = $dbh->selectrow_array ("SELECT current_date()");
$gtime = $dbh->selectrow_array ("SELECT current_time()");
$date_time = "$gdate $gtime";
# Cross reference the Agent Phone with extension
$phone = $dbh1->selectrow_array ("SELECT phone from map where extn =
'$extn'");...
2006 May 31
0
AGI MySql
...y $dbh = DBI->connect('dbi:mysql:voiceDb', 'test', 'test',
>{PrintError=>0,
>
> >RaiseError=>1});
> >my $sql = "select filename from contentTable where ext='$ext'" or die
> >$dbh->errstr;
> >my $filename = $dbh->selectrow_array($sql);
> >$dbh->disconnect;
> >
> >$filename =~ s/\.wav//i;
> >print "STREAM FILE $filename \"\"\n";
> >
> >exit;
> >
> >The return value of $filename from the database is supposed to be
> >/var/sounds/scoobie.wav.
> &g...