Re: (Fwd) suggestion for DBI

2006-04-12 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I would like to suggest a new feature/function in DBI. It would really > be nice if there was a way to print out the actual sql statement for > debugging purpose, in particular in cases with placeholders like this > example: I'm not really seeing

Re: Setting the MySQL client character set

2006-04-12 Thread Ron Savage
On Wed, 12 Apr 2006 20:03:35 +0200, Peter J. Holzer wrote: Hi Peter > That's in the manual. What is not in the manual is that the order > is crucial. If you swap them, it does not work, and you will get > very strange results. Geez. Congratulations on your great detective work! -- Cheers Ro

Re: Running DBI, ODBC in the crontab

2006-04-12 Thread Tim Bunce
On Wed, Apr 12, 2006 at 04:33:39PM +0200, Dr.Ruud wrote: > "Jeffrey Seger" schreef: > > > perl -MData::Dumper -e' print Dumper @INC' > > Alternative: > > perl -MData::Dumper -e' print Data::Dumper->Dump([EMAIL PROTECTED], > [qw(*INC)])' Alternative: perl -V Tim.

(Fwd) suggestion for DBI

2006-04-12 Thread Tim Bunce
- Forwarded message from Tomas Karlsson <[EMAIL PROTECTED]> - Date: Wed, 12 Apr 2006 16:47:18 -0400 From: Tomas Karlsson <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Organization: 10 East Corp. To: [EMAIL PROTECTED] Subject: suggestion for DBI Hi Tim, I would like to suggest a new fea

Re: Setting the MySQL client character set

2006-04-12 Thread Paul DuBois
On 4/12/06 13:03, "Peter J. Holzer" <[EMAIL PROTECTED]> wrote: > This just cost me a few hours of debugging, so I am posting it to spare > others: > > The mysql client character set can be set to UTF-8 with: > > $dbh->do("set character set utf8"); > $dbh->do("set names 'utf8'"); How does the re

Setting the MySQL client character set

2006-04-12 Thread Peter J. Holzer
This just cost me a few hours of debugging, so I am posting it to spare others: The mysql client character set can be set to UTF-8 with: $dbh->do("set character set utf8"); $dbh->do("set names 'utf8'"); That's in the manual. What is not in the manual is that the order is crucial. If you swap the

Need help to convert text

2006-04-12 Thread Nayeem \(Zajil Com\)
Dear All, Actually I'm facing problem when I'm trying to write in perl same function which is available in VB and Function code is mention below Public Function EncodeArabic(ByVal arabicString As String) As String Dim _targetEncoding As System.Text.Encoding Dim _encodedCharsArray(

Re: Problem on Solaris 8 64-bit.

2006-04-12 Thread Rhugga Harper
It is looking in $ORACLE_HOME/lib: adcnaa02:/usr/local/internal/log #dump -Lv Usage: dump [-agcd:fhn:oprstvCLT:V?] file(s) ... adcnaa02:/usr/local/internal/log #/usr/local/lib/perl5/site_perl/5.8.7/sun4-solaris/auto/DBD/Oracle/Oracle.so adcnaa02:/usr/local/internal/log #dump -Lv /usr/local/lib/p

Re: Running DBI, ODBC in the crontab

2006-04-12 Thread Dr.Ruud
"Jeffrey Seger" schreef: > perl -MData::Dumper -e' print Dumper @INC' Alternative: perl -MData::Dumper -e' print Data::Dumper->Dump([EMAIL PROTECTED], [qw(*INC)])' -- Affijn, Ruud "Gewoon is een tijger."

RE: Running DBI, ODBC in the crontab

2006-04-12 Thread Kong, Alan
Have you try to set LD_LIBRARY_PATH and LD_RUN_PATH in your perl script? I had the same problem before and it was fixed by setting these variables in the perl script. Cron jobs are not having the same environmental variables even with the same users. -Original Message- From: [EMAIL PR

DBD-Oracle-1.16 installation Error | Help

2006-04-12 Thread Mohit Hemant Maniar
Hi all, I am facing issue with DBD-Oracle-1.16 installation with DBI-1.50. Kindly help me with the same. bash-3.1# iwperl Makefile.PL Multiple copies of Driver.xst found in: /apps/iw-home/iw-perl/site/lib/auto/DBI/ /apps/iw-home/iw-perl/vendor/lib/auto/DBI/ at Makefile.PL line 39 Using DBI 1.

Re: Oracle

2006-04-12 Thread Ron Savage
On Tue, 11 Apr 2006 17:13:47 -0600, Tim Gorman wrote: Hi Tim > Called "Oracle OLE DB" > (http://www.oracle.com/technology/tech/windows/ole_db/index.html), Yes, thanx. -- Cheers Ron Savage, [EMAIL PROTECTED] on 12/04/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Au