Re: ShowErrorStatement

2007-08-14 Thread Tim Bunce
On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with or die... statements. I recommend that everyone who doesn't carefully read the release notes

(Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-14 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - X-IP: 216.150.208.7 From: [EMAIL PROTECTED] To: Tim Bunce [EMAIL PROTECTED] Subject: Re: DBD::Oracle won't install for Oracle 10G XE Date: Mon, 13 Aug 2007 22:42:59 -0700 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with or die... statements. I recommend that everyone who doesn't carefully read the

Re: ShowErrorStatement

2007-08-14 Thread jeff
From: Robert Hicks [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 14, 2007 01:16 PM So I should still or die... even if I set ShowErrorStatement? I ask, because if true, then I would like to let the author of the paper I am reading know to make corrections if needed. To oversimplify

DBI DBD-ODBC

2007-08-14 Thread robert . v . simmons
I created an MSACCESS Database on my Windows XP O/S, set up the System Name in the DATA SOURCES panel associating the Microsoft Access Driver(*.mdb) with my database name (db1). I installed the DBI Module and DBD-ODBC and I still get the following error when I run my PERL script.. Could

Re: ShowErrorStatement

2007-08-14 Thread jeff
Oh, one addendum: the ability to use RaiseError instead of or die statements applies *only* to DBI-related errors. It means you can omit or die on DBI methods such as prepare() and execute(). For methods and functions that are not DBI, you'll need to use or die if you want to trap other kinds

Re: ShowErrorStatement

2007-08-14 Thread Tim Bunce
On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with or die...

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with

Re: ShowErrorStatement

2007-08-14 Thread Robert Hicks
Tim Bunce wrote: On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: Tim Bunce wrote: On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: First off, I had no idea it existed until I started going through a dbi tutorial. The idea is you don't have to litter your code with

Multiple statements within one $dbh-do()

2007-08-14 Thread Loo, Peter # PHX
Hi, I am trying to execute two SQL statements within one call to $dbh-do() and Perl DBI is not happy. Here is a sample call: $sql = qq{delete from some_table where condition_one andcondition_two; insert into some_table (col_1, col_2, col_3)

RE: Multiple statements within one $dbh-do()

2007-08-14 Thread Garrett, Philip \(MAN-Corporate\)
Loo, Peter # PHX wrote: Hi, I am trying to execute two SQL statements within one call to $dbh-do() and Perl DBI is not happy. Here is a sample call: $sql = qq{delete from some_table where condition_one andcondition_two; insert into some_table