Re: Is it possible to print the values for which a dynamic query failed.

2002-10-12 Thread Tim Bunce
The driver needs to support the (new) ParamValues attribute. If it does then setting the ShowErrorStatement attribute will include both the Statement text and the ParamValues in the error message. Assuming you're using a recent DBI version. Tim. On Fri, Oct 11, 2002 at 02:35:18PM -0700, Naveen

5.8, NLS_LANG, and the utf8 flag

2002-10-12 Thread Kevin Scaldeferri
I didn't see anything which explicitly confirmed this in a couple google searches on this group, so... I observe that when I set NLS_LANG=AMERICAN_AMERICA.UTF8 that while I retrieve the correct bytes from the database, the utf8 flag is not set. Is this correct or am I possibly not setting up my

DB multiplexing (was Re: Which shared memory module to use?)

2002-10-12 Thread Henri Asseily
On Friday, October 11, 2002, at 02:39 PM, Tim Bunce wrote: There hasn't been up to now (or at least I haven't found any) a widely available Perl/DBI-based system for system architects who handle high-availability groups of servers, either in read-only load-balanced mode or read-write

Perl/flash/mysql

2002-10-12 Thread Tee-Man
Hello! I'm brand new to the list, and I'm wondering if anyone has used a flash interface with mysql, specifically using perl. I have been successful in using PHP to interact with a flash front-end, but my small provider's server currently does not support PHP (they didn't even have DBD until I

Re: Which shared memory module to use?

2002-10-12 Thread Tim Bunce
On Fri, Oct 11, 2002 at 12:50:15PM -0700, Henri Asseily wrote: This is somewhat OT, but I need an answer from within the DBI community: I want to release a new DBIx module, DBIx::HA (for High Availability). What will it do, and how? In this module I need to do some work on shared memory

zeugma

2002-10-12 Thread Naveen Prabhakar
I get this kind of error when I try to execute after binding parameters. DBD::DB2::st execute failed: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 at ./dbinit2.pl line 326, USERDATA chunk 1. I am binding around 20 parameters,some of them are of this type

DBI long read problem

2002-10-12 Thread Daniel Olson
I'm writing a CGI script in Perl to extract longs from an Oracle database that contain jpeg images and package them for display in a web page. I've got a script to put them into the database, which I thought would be the hard part. But I'm struggling with this. I'm using Perl 5.004_01, DBI

Re: Is DBD:proxyServer available for Windows NT platform???

2002-10-12 Thread KAWAI,Takanori
Hi. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 6:02 AM Subject: Is DBD:proxyServer available for Windows NT platform??? Hi Expert Is DBD:proxyServer available for Windows NT platform??? You say

Re: string data right truncation error sqlstate 22001 while working with dbi:db2

2002-10-12 Thread jmelesky
On 11 Oct, Naveen Prabhakar wrote: I get this kind of error when I try to execute after binding parameters. DBD::DB2::st execute failed: [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 at ./dbinit2.pl line 326, USERDATA chunk 1. That error occurs when you have a

Re: DBD::Oracle

2002-10-12 Thread Stephen Clouse
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Oct 11, 2002 at 04:51:26PM -0700, Michael A Chase wrote: This is getting to be a very common problem. Is there any reliable way to detect the integer size used by Perl and Oracle so Makefile.PL can do this? [snip] Funny, I emailed Tim