ANNOUNCE: DBD::Oracle 1.16 release candidate 6 - request for testing

2004-08-07 Thread Tim Bunce
A mature, and hopefully final, release candidate of DBD::Oracle 1.16 is available for testing at: http://homepage.eircom.net/~timbunce/DBD-Oracle-1.16-rc6-20040807.tar.gz =head1 Changes in DBD-Oracle 1.16 (svn rev 425) 7th August 2004 NOTE: This release has major changes to Unicode

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Patrick Galbraith
Tim, It won't. We will work with the maintainer to ensure that CPAN and mysql.com's source is the same. No matter how we internally manage DBD::mysql code internally, we will go through CPAN/cvs to merge our work. regards, Patrick On Aug 7, 2004, at 12:54 PM, Tim Bunce wrote: On Fri, Aug 06, 20

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Patrick Galbraith
Alan, The macro is D_imp_dbh_from_sth, regards, Patrick On Aug 6, 2004, at 5:51 AM, Jochen Wiedmann wrote: Alan Burlison wrote: One other question - how do I get the parent DBH from a STH from within the XS code for a DBD driver? There's a DBI macro for that, I do not remember the name, but most

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Patrick Galbraith
On Aug 6, 2004, at 9:19 AM, Alan Burlison wrote: Alexey Stroganov wrote: It was already implemented in my tree with the same behaviour as for 'mysql_server_prepare' attribute: - attribute 'mysql_use_result' on dbh level, this allows to enable/disable mode for all new statements: - DBI->co

Re: Drivers that support server-prepare-statements?

2004-08-07 Thread Patrick Galbraith
Mike, No difference at all. I've simply implemented dbh->prepare to use the server to prepare and sql statement (which is now supported in mysql 4.1.3) as opposed to the driver emulating a server prepare. Nothing that a DBI developer has to worry about from a high level of using "$dbh->prepare"

Re: DBD::ADO - Multiple "unnamed" columns clobber themselves.

2004-08-07 Thread Tim Bunce
On Sat, Aug 07, 2004 at 04:53:44PM +, amonotod wrote: > > From: Olivier Poulet <[EMAIL PROTECTED]> > > Date: 2004/08/07 Sat AM 09:39:59 GMT > > my $sql =<<'EOFSQL'; > > SELECT > > LOWER(field_one) > > as field_one > > >, field_two, UPPER(field_three) > > as field_three > > > FROM sample_ta

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Tim Bunce
On Fri, Aug 06, 2004 at 07:39:11PM +0300, Alexey Stroganov wrote: > > It was already implemented in my tree with the same behaviour as for > 'mysql_server_prepare' attribute: How are you intending to ensure that the DBD::mysql source at mysql.com doesn not diverge from that on CPAN? Tim.

Re: DBD::ADO - Multiple "unnamed" columns clobber themselves.

2004-08-07 Thread amonotod
> From: Olivier Poulet <[EMAIL PROTECTED]> > Date: 2004/08/07 Sat AM 09:39:59 GMT > my $sql =<<'EOFSQL'; > SELECT > LOWER(field_one) as field_one >, field_two, UPPER(field_three) as field_three > FROM sample_table (NOLOCK) > WHERE > field_one = ? > EOFSQL That should do it... HTH, amonotod

Re: Perl / DB2 administrative API

2004-08-07 Thread Darin McBride
On August 6, 2004 6:54 am, [EMAIL PROTECTED] wrote: > [ Not really DBI related, but Tim suggested I post here ] > > We're starting to write our own administration functions for DB2, and > are currently developing a perl module that provides access (through > XS code) to the DB2 administrative API.

DBD::ADO - Multiple "unnamed" columns clobber themselves.

2004-08-07 Thread Olivier Poulet
Hello to all, I am running a snippet similar to this against MSSQL 2000, on a Win32 box. my $sql =<<'EOFSQL'; SELECT LOWER(field_one), field_two, UPPER(field_three) FROM sample_table (NOLOCK) WHERE field_one = ? EOFSQL my $sth = $dbh->prepare($sql) or die; my ($field_one, $field_two, $field_th

Re: ORA-904 "invalid column name": wrong error message?

2004-08-07 Thread Dr. Frank Ullrich
Andy, thanks a lot for this hint and that you really took the time to go through my lengthy posting! You were absolutely right, after I corrected the insert statement the error went away just like that! Andy Hassall wrote: You have ARTIKEL in the insert statement, but ARTIKELNUMMER in the table

Re: DBD::Oracle seems not working through Apache

2004-08-07 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi John, U dont define $ORACLE_HOME in the connection string. Either you define it in httpd.conf using SetEnv, or if in a perl section using PerlSetEnv or even $ORACLE_HOME = '/your/oracle/home' in your startup script in a BEGIN block. Thanks Raj John wrote: > Well, how could i define the $ORACL

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Jochen Wiedmann
Alan Burlison wrote: One other question - how do I get the parent DBH from a STH from within the XS code for a DBD driver? There's a DBI macro for that, I do not remember the name, but most probably its DBIxxx_parent or similar.

Perl / DB2 administrative API

2004-08-07 Thread Hildo . Biersma
[ Not really DBI related, but Tim suggested I post here ] We're starting to write our own administration functions for DB2, and are currently developing a perl module that provides access (through XS code) to the DB2 administrative API. This allows us to perform tasks like getting database snapsh

Re: DBD::mysql and mysql_use_result

2004-08-07 Thread Alexey Stroganov
On Fri, Aug 06, 2004 at 01:38:48PM +0100, Alan Burlison wrote: > I want to use the DBD::mysql 'mysql_use_result' attribute to make the > driver use mysql_use_result instead of mysql_store_result, and I want to > do it for all the queries I'm submitting against the database. Having > to set it o

PERL: DBD issue: (DBD-Oracle-1.15) Installation Problem in Solaris [SunOS 5.8]

2004-08-07 Thread Papuswamy, Shanmugam
Hi, We have the following installed on our Sun Solaris Server [SunOS 5.8]: 1. Perl 5.8.0 2. Perl DBI Module - Version 1.43 We are trying to install DBD (DBD-Oracle-1.15) Installation in Solaris [SunOS 5.8]. We are facing issues while executing "make test" after completing perl Makefile.PL, fol