Re: Transactions: DBI vs. SQL

You need to turn AutoCommit off with: my $dbh = DBI-connect('dbi:Pg:dbname=test', 'postgres', '...', { PrintError = 1, RaiseError = 0, AutoCommit = 0 }); -- -- Tom Mornini On Mar 25, 2006, at 3:24 PM, John Siracusa wrote: I expect the following two pieces

Re: MySQL vs. DBI/DBD

by server; consider upgrading MySQL client at test.pl line 15 I hope you have the time to look into this. Regards, Börkur Gudjonsson - -- - -- Tom Mornini -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (Darwin) iD8DBQFCMrKpzaKkuvKwKvcRAqbLAJ46vD3l

Re: how to fetch all records

to retrieve all the records into an array first and process it later on. What would be the best way of doing it? from perldoc DBI... $ary_ref = $dbh-selectall_arrayref($statement); Looks like selectall_arrayref is your cup of tea. - -- - -- Tom Mornini -BEGIN PGP SIGNATURE- Version

Re: A note about ConceptDraw

. It works nicely but, doesn't work on OS X :( Not a recommendation, but something to keep our collective (OS X) eyes on: http://www.joshuahawcroft.com/products/xerd/ - -- - -- Tom Mornini -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (Darwin) iD8DBQFBqhZozaKkuvKwKvcRAs

Re: DBI (1.32, 1.37) transforms data before passing it to the driver? (XML and UTF-8 getting in the way?)

, or warning. At the very least, -w should be ejecting warning when this is happening! I don't see this as a DBI/DBD issue AT ALL. It's a Perl issue, plain and simple. -- -- Tom Mornini, InfoMania Printing and Prepress -- -- ICQ: 113526784, AOL, Yahoo, MSN and Jabber: tmornini -- PGP: http

Re: DBI (1.32, 1.37) transforms data before passing it to the driver? (XML and UTF-8 getting in the way?)

coming back from SOAP::Lite were UTF-8 internally, but had nothing but single byte clean 7 bit ASCII values inside. I think I would have solved the problem much more quickly had there been odd characters within. -- -- Tom Mornini, InfoMania Printing and Prepress -- -- ICQ: 113526784, AOL, Yahoo

Re: DBI (1.32, 1.37) transforms data before passing it to the driver? (XML and UTF-8 getting in the way?)

I *just* tracked down a similar problem in our system. It turns out that we were receiving data from SOAP::Lite that Perl had marked internally as UTF-8, even though there were NO characters that required it. Another value that was completely UTF-8 clear was being *magically* transformed by a

DBD::Oracle on OS X Success!

test 10) As admin user, install DBD::Oracle cd ~/DBD-Oracle-1.12 sudo make install -- -- Tom Mornini -- InfoMania Printing Prepress -- -- ICQ: 113526784, AOL, Yahoo, MSN and Jabber: tmornini

Progress (not success!) on DBD::Oracle for OS X

PHP against the Oracle libraries on OS X without a hitch. Surely we can do as well! Makefile.PL patch: http://www.mornini.com/Makefile.PL.patch configure, make and test results: (post patch) http://www.mornini.com/DBD_Oracle_OS_X.txt -- -- Tom Mornini -- InfoMania Printing Prepress -- -- ICQ

Can't make DBD::Oracle on OS X

on Linux and have had few problems. I'm completely new to building it on Mac OS X, of course, as the Oracle developer release has only been available for a couple of days. I've also attached output of Perl -V -- -- Tom Mornini -- InfoMania Printing and Prepress -- -- ICQ: 113526784, AOL, Yahoo, MSN

Can't make DBD::Oracle on OS X

only been available for a couple of days. I've also attached output of Perl -V -- -- Tom Mornini -- InfoMania Printing and Prepress -- -- ICQ: 113526784, AOL, Yahoo, MSN and Jabber: tmornini Makefile.txt Description: application/applefile bash-2.05a$ perl Makefile.PL Multiple copies

DBD::Oracle on OS X

I'm trying make DBD::Oracle on Macintosh OS X. DBI-1.30 compiled and tested cleanly. I'm attaching the entire output of: perl Makefile.PL for DBD::Oracle 1.12 Other than minor errors like: Multiple copies of Driver.xst found in: /Library/Perl/darwin/auto/DBI /Library/Perl/darwin/auto/DBI at