what change? this doesn't make sense.... if it's just in openums, the $dbh
is global:
kenglish@comtel-prod:~/linuxvm/src$ grep dbh openums
my $dbh = &get_dbh();
my $recorder = new Voicemail::RecordMessage($ctport,$dbh);
&vmta2($dbh,$msg_id,$ctport,$log);
my $UserMenu = new Voicemail::UserMenu($ctport,$dbh);
my $aa = new Voicemail::AutoAttendantCT($ctport,$dbh) ;
$dbh->disconnect();
if u wanna make a sub in common.pl or something and use, then just pass it
to the sub as the first argument....
sub use_it {
my $dbh = shift ;
my $sql = "select *....." ;
my $sth = $dbh->prepare($sql);
.... etc ...
}
call it like this from openums:
&use_it ($dbh) ;
k
> Kev,
>
> I would make this change but I don't know how to use the "shared" $dbh.
>
> my $sql = qq(UPDATE VM_Users SET mwi_status = '0' WHERE extension =
> XXX);
>
> XXX = the extension for the mailbox that is hearing the prompts.
>
> This will reactivate their MWI if they go into their mailbox and do not
> listen to their messages.
>
> -Matt
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> Linuxvm-developer mailing list
> Lin...@li...
> https://lists.sourceforge.net/lists/listinfo/linuxvm-developer
|
