Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Tim Bunce
On Sun, Jul 25, 2004 at 01:31:51PM -0700, Dean Arnold wrote: caveat while not strictly a DBI issue, I'm going to kick this off here, since its pretty relevant (ala SQL::Statement). If I'm out of line, or should restrict this to one or the other lists, please advise /caveat It's not

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Tim Bunce
On Mon, Jul 26, 2004 at 07:15:13AM +0100, Tim Bunce wrote: On Sun, Jul 25, 2004 at 01:31:51PM -0700, Dean Arnold wrote: caveat while not strictly a DBI issue, I'm going to kick this off here, since its pretty relevant (ala SQL::Statement). If I'm out of line, or should restrict this

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Dean Arnold
Understood. Sorry. - Dean

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Tim Bunce
On Sun, Jul 25, 2004 at 01:31:51PM -0700, Dean Arnold wrote: A couple years ago, someone posted an RFC and some questions about building an Inline::SQL module. Alas, while I was pretty enthused about it, it never seemed to get off the ground. I don't see the point. What would be benefits

Re: DBI BOF @ OSCON ?

2004-07-26 Thread Patrick Galbraith
Hi all, I will be giving a presentation on DBD::mysql on Wednesday, 7/28: - Conference Session Session ID: 5485 Title: How DBD::mysql Enhancements Can Benefit the Perl Developer Date: 07/28/2004 Time: 2:35pm to 3:20pm Location: Salon D I'll be covering my work on server side prepared

Drivers that support server-prepare-statements?

2004-07-26 Thread Patrick Galbraith
Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? Does anyone know if such a list (authoritative list) exists? thanks in advance, Patrick -- Patrick Galbraith, Senior Systems Engineer MySQL AB,

Re: DBD::Oracle debugging

2004-07-26 Thread Reinhard Pagitsch
Mark Nettlingham wrote: Hi all, I was wondering if there's a way of enabling DBI's internal debugging? Essentially, I'm getting a fail when connecting to an Oracle Database, but no $DBI::err, or $DBI::errstr is being produced - both are null. This is especially frustrating as it only happens on

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Dean Arnold
Tim Bunce wrote: On Sun, Jul 25, 2004 at 01:31:51PM -0700, Dean Arnold wrote: A couple years ago, someone posted an RFC and some questions about building an Inline::SQL module. Alas, while I was pretty enthused about it, it never seemed to get off the ground. I don't see the point. What would be

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Michael Peppler
On Mon, 2004-07-26 at 09:15, Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? Does anyone know if such a list (authoritative list) exists? I don't know if there is a list,

Re: Oddity using placeholders w/ Oracle

2004-07-26 Thread Steven Lembark
I'm guessing it's a CHAR field. Thank blank-padded-comparison-sementics. It's an FAQ. USe bind_param(..., SQL_CHAR); d'oh... -- Steven Lembark 9 Music Square South, Box 344 Workhorse ComputingNashville, TN 37203 [EMAIL PROTECTED]

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Dean Arnold
Michael Peppler wrote: On Mon, 2004-07-26 at 09:15, Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? Does anyone know if such a list (authoritative list) exists? I don't know if

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Tim Bunce
On Mon, Jul 26, 2004 at 12:15:58AM -0700, Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? Does anyone know if such a list (authoritative list) exists? It's a little dated

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Jeff Zucker
[redirected to dbi-users] Dean Arnold wrote: use SQL::Preprocessor; EXEC SQL CONNECT TO 'mydsn' USER userid IDENTIFIED BY password; EXEC SQL SELECT * FROM mytable; foreach my $row (@$_) { print join(', ', @$row), \n; } EXEC SQL DISCONNECT; __END__ It seems to me, that wouldn't be a gain over

Re: DBI BOF @ OSCON ?

2004-07-26 Thread Tim Bunce
On Mon, Jul 26, 2004 at 12:14:27AM -0700, Patrick Galbraith wrote: Hi all, I will be giving a presentation on DBD::mysql on Wednesday, 7/28: - Conference Session Session ID: 5485 Title: How DBD::mysql Enhancements Can Benefit the Perl Developer Date: 07/28/2004 Time: 2:35pm to

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Jeff Zucker
Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? The various SQL::Statement drivers (DBD::CSV, DBD::DBM, DBD::AnyData, DBD::Excel, etc.), support server (in as much as there is

Re: DBI BOF @ OSCON ?

2004-07-26 Thread Patrick Galbraith
Tim, What's the status of the work? Is a patch available for Rudy to integrate? It's complete. I can run all tests using server prepare vs. emulated in the driver, and all pass. I've done benchmarking with my own script and found using the server is of course faster than emulation in the

RE: DBD::Informix Win32 problem

2004-07-26 Thread CAMPBELL, BRIAN D (BRIAN)
I built DBD::Informix on Win32 last fall. There was a lot of stuff I had to change to get it to compile under Win32, and it's all documented in this posting. http://www.mail-archive.com/[EMAIL PROTECTED]/msg19771.html Your problem below looks like it might be the free memory problem I ran

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Patrick Galbraith
So, Tim is going to be there after all? For some reason, I thought that he wasn't able to make it this year. I have been so busy, that I probably missed some of the emails. Jeff Zucker wrote: Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Jeff Zucker
Dean Arnold wrote: - embedded SQL syntax for various databases - possible feature requests/needs for optimal Perl integration - alternate namespace suggestions Are you actually going to be parsing SQL, or just looking for EXEC SQL and grabbing the SQL and feeding it to the drivers? If you're

Re: Drivers that support server-prepare-statements?

2004-07-26 Thread Mike Schienle
On Mon, July 26, 2004 12:19 pm, Patrick Galbraith said: Jeff Zucker wrote: Patrick Galbraith wrote: Hi all, I'm working on my OSCON presentation, and was hoping to get a list of DBD drivers that currently support server prepare statements? The various SQL::Statement drivers (DBD::CSV,

Re: RFC: SQL::Preprocessor - a SQL filter for Perl

2004-07-26 Thread Dean Arnold
Jeff Zucker wrote: Dean Arnold wrote: - embedded SQL syntax for various databases - possible feature requests/needs for optimal Perl integration - alternate namespace suggestions Are you actually going to be parsing SQL, or just looking for EXEC SQL and grabbing the SQL and feeding it to the

Re: Re: DBD::Informix Win32 problem

2004-07-26 Thread Nikolay Ananiev
Thanks Brian I compiled and tested the module successfully under perl 5.6.1 and 5.8.4. This is what I did: changed lines 642 and 643 to $opts{LD} = INFORMIXC='\$(FULLPERL) esqlld' . ESQLLD='$Config{ld} \$(LDDLFLAGS)' \$(ESQL) unless $NTConfiguration; and then edited dbdimp.ec and set

RE: Re: DBD::Informix Win32 problem

2004-07-26 Thread CAMPBELL, BRIAN D (BRIAN)
Nikolay, So it sounds like you were hit the same free memory issue. Regarding the tests, were they t51, and t58? I find that they don't run successfully when when run with the entire test suite, but they do run OK when run individually. So I attributed that to a test plan problem, not a DBD

Does DBI change behavior across platforms?

2004-07-26 Thread Kinyon, Rob
Using DBD::Mock, I've got a number of tests I'm using to validate my class that has-a DBI object. One set of tests verifies that I will return undef if handed the following SQL statements: SELECT 1 AS value FROM SELECT 1 AS value (with a bind param passed in)

Steps to install DBI/DBD when AIX server doesn't have a C compile r

2004-07-26 Thread Thomas Cullen
Hi, Trying to install DBI and Oracle DBD on an AIX 5.1 server. I have a C compiler on another AIX server with an identical layout. Can I tar up the compiled libs on the server with the compiler and then drop them into the directories on the server without the compiler and link from there? Is