Re: Oracle qouting ?

2005-11-08 Thread Martin Hall
I usually use an additional single quote when I'm attempting to insert a single quote. E.g. 'don''t'. Alternatively, if it gets too difficult to read, I concatenate the appropriate ascii code (39). SQL select 'don''t' from dual; 'DON' - don't SQL select 'don'||chr(39)||'t' from dual;

Re: InactiveDestroy with Class::DBI

2005-11-08 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Aaron Turner asked: So I'm trying to track down a problem with my program which forks needing both parent and children to have access to the database via Class::DBI. The basic issue I'm having is that after the first child exits, the parent's

ShowErrorStatement changing how my script runs

2005-11-08 Thread Martin J. Evans
I may being really daft here but I can't see why changing ShowErrorStatement should change what happens here (unless it is consuming errors before the error handler is called). bash-2.05$ perl -MDBI -e 'print $DBI::VERSION\n;' 1.48 bash-2.05$ perl --version This is perl, v5.8.7 built for

Bug in DBD::DBM

2005-11-08 Thread Stuart Lemmen
Tim, I originally wrote this mail to Jeff Zucker but didn't receive a reply so I thought I might as well send it to you as well - it isn't entirely clear to me exactly who is the maintainer of this package. Thanks for reading. - Sorry if this is the wrong approach to this

Apache-DBI

2005-11-08 Thread Paul Harrison
p5-DBD-mysql50-3.0002 p5-DBI-1.48 p5-Apache-DBI-0.94_1 I upgraded the database server from the 4 version to 5, so I updated the Perl database Drivers - DBD,DBI, and Apache-DBI. Once I updated the software, I get the following text in the Apache error log -- [Tue Nov 8 10:41:04 2005]

Re: Apache-DBI

2005-11-08 Thread Philip M. Gollucci
Paul Harrison wrote: p5-DBD-mysql50-3.0002 p5-DBI-1.48 p5-Apache-DBI-0.94_1 [Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211. [Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in

Re: ShowErrorStatement changing how my script runs

2005-11-08 Thread Tim Bunce
On Tue, Nov 08, 2005 at 04:26:38PM -, Martin J. Evans wrote: I may being really daft here but I can't see why changing ShowErrorStatement should change what happens here (unless it is consuming errors before the error handler is called). bash-2.05$ perl -MDBI -e 'print $DBI::VERSION\n;'