Re: getting postgresql's client output from DBI

2006-08-14 Thread Alexander Foken
DBI has a dump_results() method that may help you. Read the DBI docs for details. Do not use this method for data transfers. Alexander On 15.08.2006 01:36, Gene Zhang wrote: instead of getting back an array or hash for each row of my SELECT, I want the results in one string, so that I can pri

Re: getting postgresql's client output from DBI

2006-08-14 Thread Tyler MacDonald
Gene Zhang <[EMAIL PROTECTED]> wrote: > instead of getting back an array or hash for each row of my SELECT, I > want the results in one string, so that I can print it just like the > psql shell client: > > e.g. > > " > id | name | myid | tsid | comment > -++--+--+

getting postgresql's client output from DBI

2006-08-14 Thread Gene Zhang
instead of getting back an array or hash for each row of my SELECT, I want the results in one string, so that I can print it just like the psql shell client: e.g. " id | name | myid | tsid | comment -++--+--+- (0 rows) " is there a way to do this? -gene

Solaris 8, Perl 5.8.7, DBI 1.5.1, DBD::Oracle 1.18a, Instant Client (basic) 10.2.0.2 and NLS settings

2006-08-14 Thread Duncan Ferguson
Some advice please... I am trying to build/package a perl module where I do not have to set LD_LIBRARY_PATH before use (there can be a number of oracle installations on the machines I want it for and cannot generically set it in case I break something else, and cannot use those installs since I ca

Re: Minor gotcha with bind variables and type CHAR.

2006-08-14 Thread Peter J. Holzer
On 2006-08-11 18:25:39 -0700, Stephen Carville wrote: > [EMAIL PROTECTED] wrote: > >I would expect to have to pad the field in my where clause against a > >char field, regardless of how I submitted the query to Oracle. > > Until I switched to using bind variables, I'd never had a problem. > Trimme