Re: OT Perl Optimizations Was: undef NULL

2001-09-14 Thread Peter J . Holzer
On 2001-09-13 17:01:20 -0400, Rob Ransbottom wrote: On Thu, 13 Sep 2001 [EMAIL PROTECTED] wrote: I have a minor optimization suggestion. Instead of this: unless ($sth_routine_name) { #setup statement handle } Do this: $sth_routine_name ||= $dbh-prepare(); pretty

Strange error when doing insert into DB

2001-09-14 Thread Riyaad Miller - MWeb
Hi ALL Has anyone come across the following error: Can't mix placeholder styles (:foo/:1) at /usr/local/lib/perl5/site_perl/DBD/Oracle.pm line 293, LOGFILE chunk 1085. Unix OS - SunOS 5.6 Oracle - 7 The problem does multiple actions ranging from updates, insert and of course selects from my

Re: Off Topic PHP-MySQL

2001-09-14 Thread Dave Webb
perhaps news.php.net with newsgroup php.db Todd Moy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Sorry about the OT, but I thought someone may know a good PHP listserv. Basically, I am trying to retrieve images from a MySQL database with PHP scripts. More if

RE: Strange error when doing insert into DB

2001-09-14 Thread Scott T. Hildreth
Can we see some code? The error is, what it states, you are mixing placeholders. i.e. $dbh-prepare(select * from foo where bar = ? and foobar = :p1); ..check the code for :string and :number mixture in a statement. On 14-Sep-01 Riyaad Miller - MWeb wrote: Hi ALL Has anyone come

Fwd: failure notice

2001-09-14 Thread Gary Traffanstedt
I just tried to join the dbi-users list and received the following message... could someone manually add me or tell me how to correctly sign myself up? Thanks! Gary -- Gary Traffanstedt -- GeniusWeb.com Inc. 406 8th Avenue NE Aberdeen, SD 57401 -- http://www.geniusweb.com [EMAIL

Re: Fwd: failure notice

2001-09-14 Thread Ask Bjoern Hansen
On Fri, 14 Sep 2001, Gary Traffanstedt wrote: I just tried to join the dbi-users list and received the following message... could someone manually add me or tell me how to correctly sign myself up? mailto:[EMAIL PROTECTED]: Sorry, no mailbox here by that name. (#5.1.1) try the

RE: is it possible to execute a package.procedure from Oraperl.pm script ?

2001-09-14 Thread timothy . helck
Avi, I had the same question a few months ago, and people in the list were kind enough to give me a lot of information. Based on what I learned, I wrote the following short script which illustrates the basic features of using DBMS_OUTPUT.PUT_LINE. You must use dbh-func() which unfortunately is

[Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
I followed the trails of Programming the Perl DBI, Appendix B to freeodbc to to easysoft.org... I read for hours history requests at dejanews I am now more confused than when I started. I have this working on my sparc Solaris ws: perl+DBI+DBD::Informix to connect to an

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Kokarski, Anton
-Original Message- From: Robert Lopez [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 9:09 AM To: [EMAIL PROTECTED] Subject: [Solaris] dbi + DBD:ODBC + ?for oracle? I followed the trails of Programming the Perl DBI, Appendix B to freeodbc to to easysoft.org... I

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Kokarski, Anton
You are correct Robert, sqlplus is just a command line kind of database client. \ in your perl code it is best to use DBD::Oracle. Regards, Anton Kokarski -Original Message- From: Robert Lopez [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 11:31 AM To: [EMAIL PROTECTED];

RE: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
Well I went ahead and ran cpan to install ODBC::Oracle and it says... The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. (The Driver Manager, in turn, needs one or more database specific ODBC drivers. The DBD::ODBC module does _not_ include any ODBC drivers!) so it is

dbd::db2 beginner question

2001-09-14 Thread Bill Grigg
The readme file says the following: .. Ensure one of the following DB2 products is installed. DB2 Software Developer's Kit v5.2 Included with the DB2 Application Developer's Kit DB2 Application Development Client v6 or later Included with the DB2

Re: [Solaris] dbi + DBD:ODBC + ?for oracle?

2001-09-14 Thread Robert Lopez
From: Ivan Adzhubei [EMAIL PROTECTED] Why you intend to use ODBC in the first place? It makes more sense to install DBD::Oracle, the DBI module then can use it as a lower level interface to DB. This is at least one layer less between your application code and the database itself than

Re: OT Perl Optimizations Was: undef NULL

2001-09-14 Thread James D. White
I modified Peter J. Holzer's code to test both the case where the $i is set to 1 (Holzer's case) and where $i is 0 (which forces more assignments). I also added a straight assignment statement to each set. The program and results are below. This test was run three times on a Sun Ultra 5, with

RE: DBI 1.18 Installation help

2001-09-14 Thread Wilson, Doug
From: Wilson, Allen [mailto:[EMAIL PROTECTED]] I have been attempting to install DBI 1.18 without any success. I was able to run the Makefile.PL with any problems but when I tried to run the make I received the following error... gcc -c -I/opt/gnu/include -O-DVERSION=\1.18\

DBI 1.18 Installation help

2001-09-14 Thread Wilson, Allen
Good Evening I have been attempting to install DBI 1.18 without any success. I was able to run the Makefile.PL with any problems but when I tried to run the make I received the following error... gcc -c -I/opt/gnu/include -O-DVERSION=\1.18\ -DXS_VERSION=\1.18\ -fpic

Re: Help Please

2001-09-14 Thread Srinivasa Rao Katta
Adrian, How are you ?. Thanks for the mail. As per your instructions,I have done the make clean for to clean the files. After that,I have run the following cmds on the server. perl Makefile.PL /usr/ccs/bin/make I have got the following error mesg. -- #