Re: Use of inherited AUTOLOAD for non-method DBI::DESTROY() is deprecated

2003-06-26 Thread William R Ward
Tim Bunce writes: >On Tue, Jun 24, 2003 at 06:18:41PM -0700, William R Ward wrote: >> We recently installed Perl 5.8.0 and have started seeing this error. >> I think it's an error in DBI but I'm not 100% sure. Has anyone else >> seen this, and what can be d

Use of inherited AUTOLOAD for non-method DBI::DESTROY() is deprecated

2003-06-24 Thread William R Ward
oLoader.pm line 115 during global destruction. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - "A foolish consistency is the hobgoblin of little minds, adored by littl

Re: How to find what version of Oracle *client* from Perl?

2002-03-23 Thread William R Ward
q $perlVersion ) { > $ohome = q{/u01/app/oracle/product/8.1.5}; > } elsif ( '562' eq $perlVersion ) { > $ohome = q{/u01/app/oracle/product/8.1.7}; > } > > return $ohome; >} > >1; > > woh.pl > >#!/usr/bin/perl > >use

Re: How to find what version of Oracle *client* from Perl?

2002-03-21 Thread William R Ward
[EMAIL PROTECTED] (William R Ward) writes: > [EMAIL PROTECTED] (William R Ward) writes: > > Where I work we have a variety of versions of Oracle installed in > > various possible values of $ORACLE_HOME. It is necessary to have the > > environment variable $ORACLE_HOME ma

Re: How to find what version of Oracle *client* from Perl?

2002-03-20 Thread William R Ward
[EMAIL PROTECTED] (William R Ward) writes: > Where I work we have a variety of versions of Oracle installed in > various possible values of $ORACLE_HOME. It is necessary to have the > environment variable $ORACLE_HOME match the version under which > DBD::Oracle was compiled, in ord

Re: How to find what version of Oracle *client* from Perl?

2002-03-20 Thread William R Ward
; errors when I try that. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

Re: mysqladmin tasks from Perl?

2002-03-11 Thread William R Ward
REATE DATABASE command after I already learned it (and wrote the earlier versions of the install scripts I was referring to). If so, nevermind. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

Re: mysqladmin tasks from Perl?

2002-03-11 Thread William R Ward
hink the version of MySQL that I learned first didn't have that; if so, maybe that's what's mixing me up. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/

Re: How to find what version of Oracle *client* from Perl?

2002-03-11 Thread William R Ward
he ORACLE_HOME doesn't match, a segmentation fault can occur. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

Re: mysqladmin tasks from Perl?

2002-03-08 Thread William R Ward
Paul DuBois writes: >At 15:41 -0800 3/7/02, William R Ward wrote: >>I have passwords enabled in my MySQL server, and it's rather >>unpleasant having to deal with the mysqladmin program from a Perl >>script. For example, installing the software means you have to >

mysqladmin tasks from Perl?

2002-03-08 Thread William R Ward
to do these tasks through DBD::msyql? --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

How to find what version of Oracle *client* from Perl?

2002-03-08 Thread William R Ward
. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

Re: To find a just-inserted record

2001-12-21 Thread William R Ward
bh->prepare( 'select @@identity'); > $sth->execute(); I believe it's the same in Sybase and MS SQL Server. In MySQL, there's a DBD variable you access instead of executing another query: $sth->{insertid}. --Bill. -- William R Ward[

Re: security and dbi

2001-12-18 Thread William R Ward
e account, and use the password that the user supplies for the database connection. You could have a "generic" account with read-only permissions in the database, whose password therefore doesn't need to be as strictly protected. --Bill. -- William R Ward[E

Re: Open cursors after disconnection

2001-12-12 Thread William R Ward
a record containing some metadata and a BLOB field. Can you have a "helper" web server running on a different box? Then you can have your Sisqo's webserver just act as a reverse proxy for that box to return the file. --Bill. -- William R Ward

Re: DBD::Oracle Invalid Character Error

2001-12-12 Thread William R Ward
rks in PL*SQL but not through DBI. If you are concerned about one succeeding and the other failing, use a transaction and a commit/rollback at the end. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.

Re: Question regarding to DBI::quote and CGI

2001-12-11 Thread William R Ward
gt;quote() function call, and see what the results are. Also check defined($p->{'abc'}) and exists($p->{'abc'}). If you are interested in "quoting" characters for display in HTML, use CGI::escapeHTML. For quoting characters in URLs, use CGI::escape or the URI module. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.

Re: OO object storage of $dbh?

2001-12-11 Thread William R Ward
rt of the object: $self = bless { DBH => DBI->connect() } => $class; Then, in each method, access $self->{DBH} instead of $dbh when making DBI calls. --Bill. -- William R Ward[EMAIL PROTECTED] http:

Resetting error code?

2001-12-06 Thread William R Ward
better way? Thanks. --Bill. -- William R Ward[EMAIL PROTECTED] http://www.wards.net/~bill/ - If you're not part of the solution, you're part of the precipitate.