Still Struggling to use DBIx

2001-06-27 Thread JCervoni
I have written a library of functions which wrap around the the DBI library This library I have named DBIv.pm: $dbh = OpenDBConnection($server, $database, $uid, $password) ; CloseDBConnection($dbh) ; $rh_results = SelectQuery($dbh, $query) ;

FW: DBI/ODBC Installation problems

2001-06-27 Thread Sterin, Ilya
perl_env.txt install.log This is not a development question, so please forward to correct list next time [EMAIL PROTECTED] Ilya -Original Message- From: Patricio M. Rueda To: [EMAIL PROTECTED] Sent: 06/27/2001 8:43 AM Subject: DBI/ODBC Installation problems Could some one help me!

DBD::Pg - BYTEA - fails for range outside chr(0)-chr(127)

2001-06-27 Thread Randal L. Schwartz
I'm getting core dumps when I try to use a BYTEA value with a byte outside 0..127. use DBI qw(SQL_BINARY); my $dbh = DBI-connect(dbi:Pg:dbname=merlyntest, user, pass, { RaiseError = 1 }); $dbh-do(CREATE TABLE test (a BYTEA)); my $insert = $dbh-prepare(INSERT INTO test

ANNOUNCE - AnyData 0.04

2001-06-27 Thread Jeff Zucker
Ok, no more promises, here it is. It's should be on a CPAN near you by now, or grab it from the site listed at the bottom of the attatched README. This is the tied-hash, non DBI/SQL version. The DBD version will be announced in the next message. For the tied hash version, you only need

ANNOUNCE -- DBD::AnyData 0.04

2001-06-27 Thread Jeff Zucker
Ok, no more promises, here it is. It's should be on a CPAN near you by now, or grab it from the site listed at the bottom of the attatched README. This is the DBI/SQL version. The tied hash version was announced in the previous message. For the tied hash version, you only need AnyData.pm,

Re: DBD::Pg - BYTEA - fails for range outside chr(0)-chr(127)

2001-06-27 Thread Edmund Mergl
Alex Pilosov wrote: Oy, just when I sent it, I realised what the problem is: Please apply following patch to dbdimp.c Edmund, please, apply this patch to DBD::Pg for next release. ok, on its way to CPAN. Edmund -- http://www.edmund-mergl.de fon: +49 700 edemergl

Problems running DBD::mysql

2001-06-27 Thread Stefan Antonowicz
Hello All. I've searched hi and low, and have come up with nada that can help me. I'm hoping someone out there might have an idea of what's wrong. I inherited a RH 7 box running Perl 5, specifically a Perl script that is going to query a MySQL database and email users with updates. I parsed

Re: problem executing Oracle PL/SQL functions that return ADTs

2001-06-27 Thread Tim Bunce
Add code into your PL/SQL block that 'unpacks' the ADT and returns the field(s) within it as simple string types. Tim. On Tue, Jun 26, 2001 at 03:14:07PM -0700, Jeff Holt wrote: I've searched the DBI mailing list archive, the perldoc, and various example sites and have found no way to

RE: DBD::Pg - BYTEA - fails for range outside chr(0)-chr(127)

2001-06-27 Thread Alex Pilosov
I'm one to blame for the bytea support, so :) Something is mangling chr(128) somewhere. If you do this one with DBI_TRACE=2, you'll see: INSERT INTO test VALUES ('\\3777600') I'm looking what's causing it... ---cut--- I'm getting core dumps when I try to use a BYTEA value with a byte

RE: DBD::Pg - BYTEA - fails for range outside chr(0)-chr(127)

2001-06-27 Thread Alex Pilosov
Oy, just when I sent it, I realised what the problem is: Please apply following patch to dbdimp.c Edmund, please, apply this patch to DBD::Pg for next release. 1169c1169 dest+=snprintf(dest, strlen(imp_sth-statement) + max_len + (statement - dest), %03o, *val); ---