|
|
sybperl-l Archive
Up Prev Next
From: "BAHRI, SOFIENNE" <sofienne dot bahri at bell dot ca>
Subject: Re: Unsubscribe from the list
Date: Apr 17 2000 1:26PM
A QUESTION;
HOW TO Unsubscribe from the list....
ye wei a écrit :
>
> Michael Peppler wrote:
>
> > ye wei writes:
> > >
> > > Compare with DBI, I perfer Sybperl, because sybperl is much more
> > > flexiable, but
> > > I wonder if is there any way to implement a statement handle or have
> > > more than 1 database
> > > handles in a script but only keep 1 database connection in CTLib?
> >
> > > So, I wonder is there any way to implement something like
> > > DB_Handle/Statment_Handle (DBI conception) in CTLib?
> > > I spent some time to study DBD::Sybase, it seems that ct_dynamic() is
> > > used for allocate a statement handle.
> > > But ct_cynamic() is not supported in CTLib.
> >
> > Read the documentation for DBD::Sybase closely. If you open more than
> > one statement handle on a connection handle DBD::Sybase will create an
> > additional physical connection to the database.
>
> Yes, that's true. However, it seems that with DBD::Sybase, I can
> use only *one* database connection to call do() to execute non-query
> statements with a db handle,
> while I open a statement handle to hold some pending results.
>
> $sth = $dbh->prepare("select foo from tblBar");
> $sth->execute();
> while(@row=$sth->fetchrow()) {
> ## with dbh execute SQL while statement handle is open
> $dbh->do("update tblBar set balance=2 ...");
> ...
> }
>
> But I can not do that with Sybase::CTlib with only 1 database connection.
> I have to open an additional db connection for the update sql.
>
> Any help is very appericiated!!!
>
> >
> >
> > So you just need to open additional connections if you absolutely need
> > to have pending results on various statement handles.
> >
> > Michael
> > --
> > Michael Peppler -||- Data Migrations Inc.
> > mpeppler@peppler.org -||- http://www.mbay.net/~mpeppler
> > Int. Sybase User Group -||- http://www.isug.com
> > Sybase on Linux mailing list: ase-linux-list@isug.com
>
> --
>
> Sincerely,
>
> Ye wei
--
Sofienne Bahri Bell Canada
DIRECTEUR/MANAGER
Soutien Operationnel/Operational Support
Centre de Surveillance Du Réseau/Network Management Center
700 DE LA GAUCHETIERE O. - mezz MONTREAL (Quebec) H3B 4L1
Tel:(514) 391-4114
Fax:(514) 874-0163
Pag:(514) 801-2186
Email:sofienne.bahri@bell.ca
|
