PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Paul S R Chisholm <psrc at corp dot airmedia dot com>
Subject: Re: Help using sybperl Sybase::DBLib sql routine
Date: Sep 24 1997 2:10PM

bbrown2@lindy.stanford.edu wrote:
> I'm using the Sybase::DBLib routines.
> I've called sql with
>         $db->sql("select field1, field2 from tablename");
> It returns something like:
> >>>> ARRAY(0x330f14)
>...

Note: If you're in the Perl debugger, looking at (say) a scalar variable
$r, typing "p $r" will give you something like "ARRAY(0x330f14)", but
typing "x $r" (eXamine) will show you what the referred-to value looks
like. For example, here's the difference between "p" and "x" when
looking at a Sybperl database handle:

  DB<4> p $db
Sybase::DBlib=HASH(0x33cc20)
  DB<5> x $db
0  Sybase::DBlib=HASH(0x33cc20)
   'ComputeID' => 0
   'DBstatus' => 0
   'MaxRows' => 0
   'UseDateTime' => 0
   'UseMoney' => 0
   'dbBin0x' => 0
   'dbKeepNumeric' => 1
   'dbNullIsUndef' => 1
   'dbproc' => 683016

Very helpful, in my experience.  --PSRC