Re: command line from browser

2002-02-02 Thread Steve Sapovits
Jeff Thies wrote: > Is it possible to print the same kind of messages that you would get > running SQL (MySQL) from the command prompt, with a browser? > > Say I want to describe a table: > > my $sth=$dbh->('describe some_table'); > > my $sth_return=$sth->execute($sql) ) or die "Cannot execu

command line from browser

2002-02-02 Thread Jeff Thies
Is it possible to print the same kind of messages that you would get running SQL (MySQL) from the command prompt, with a browser? Say I want to describe a table: my $sth=$dbh->('describe some_table'); my $sth_return=$sth->execute($sql) ) or die "Cannot execute: $DBI::errstr\n"; may

RE: DBI Oracle Database Handle trouble

2002-02-02 Thread Jeff Urlwin
David, It would be helpful if you attached a small script which demonstrates the error. I have had numerous instances using Oracle to have multiple sql statements executed and, in fact some executing concurrently. All using the same connection. Regards, Jeff > > I am a novice Perl DBI progra

DBI Oracle Database Handle trouble

2002-02-02 Thread David Wren
I am a novice Perl DBI programmer currently having trouble referencing the same database handle (in Main) from within REPEATED calls to a perl subroutine I wrote as an engine to process multiple SQL statements (one call per SQL statement). (I'm on Solaris 2.6.???, Oracle 8i, Perl5) In other

[Unexciting] ANNOUNCE: IBM Informix Database Driver for Perl Version

2002-02-02 Thread Jonathan Leffler
IBM Informix Database Driver for Perl Version 1.00.PC2 (2002-02-01) has been uploaded to CPAN. This is a purely administrative release. It changes the version number from 1.00.PC1 to 1.00.PC2 solely to fix the email addresses for reporting problems. Functionally, it is identical to 1.00.PC1 -

Re: connect question RE: RaiseError

2002-02-02 Thread Tim Bunce
Someone else reported this a while ago and I'll look into it before the next release. Tim. On Fri, Feb 01, 2002 at 09:02:22AM -0800, Gavin Sherlock wrote: > Hmmm. You think I'd be able to use the || die, but the following: > > eval { > > $dbh = DBI->connect("dbi:Oracles:$database"

Re: Not found subroutine - DBD::Informix

2002-02-02 Thread Douglas Wilson
- Original Message - From: "Jonathan Leffler" <[EMAIL PROTECTED]> > Craig Sharp wrote: > > > I need to be able to determine if a value is not found within a database and if so, report that the data and or row is not available back to the browser. > > > > > If the update statement cannot

Re: Not found subroutine - DBD::Informix

2002-02-02 Thread Jonathan Leffler
Craig Sharp wrote: > I need to be able to determine if a value is not found within a database and if so, >report that the data and or row is not available back to the browser. This is a classic instance of why the DBD::Informix docs says "when you ask about problems related to DBD::Informix, i