[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: table_info bug with Sybase - switches database ?
From:       Tim Bunce <Tim.Bunce () pobox ! com>
Date:       2001-11-22 1:27:50
[Download RAW message or body]

FYI, the dbi-dev list isn't really for users to report bugs with drivers.
Mail to dbi-users with a CC to the author is generally good for that.
I really want to keep dbi-dev as a forum for DBI and driver developers.
Thanks.

Tim.

On Tue, Nov 20, 2001 at 10:23:00AM -0500, Hall, Roger wrote:
> Hi,
> 
> I am using DBI-1.14.tar.gz and DBD-Sybase-0.91.tar.gz and am getting
> some behavior that I do not understand... I guess its either me or a bug.
> 
> When I use table_info, I seem to be switching to the default database of the
> login id that I use. An example of some code I was testing stuff with is
> shown
> below. The two prints show me a different database.
> 
> Roger.
> 
> 
> ##################################################
>       my($sth_1, $sth_2, $sth_3);
>       $sth_1 = $sybh->prepare("select db_name()"); 
>       $sth_1->execute();
>       while (my($d) = $sth_1->fetchrow_array()) {
>           print "***** $d *****\n";
>       }
> ##################################################
> 
>    my $tabsth = $dbh->table_info();
>    my $colsth;
>    my $sql;
>    my $table;
> 
> ###############################################################
>       $sth_1 = $dbh->prepare("select db_name()");
>       $sth_1->execute();
>       while (my($d) = $sth_1->fetchrow_array()) {
>           print "***** $d *****\n";
>       }

[prev in list] [next in list] [prev in thread] [next in thread]