Hi Curt,
Curt Russell Crandall wrote:
I ran into a similar problem with Sybase. I had a statement prepared
using placeholders (a select statement) and I had to loop several times as
I processed transactions and each time through the loop I had to execute
the prepared statement. Perl
On Wed, Mar 28, 2001 at 10:32:44AM +0200, Steffen Goeldner wrote:
Tim Bunce wrote:
If you tell me which you'd like to see and why, and I like what you say,
then your word will be my command (eventually:) !
Better still (and faster still), send me a patch!
O.k. The patch is tested
[Mailed to individual and to list]
Paul
I have a set of Perl+MySQL tutorials at http://savage.net.au/Perl-tutorials.html
In particular, look at # 24 and # 25.
Cheers
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
hi everybody !!
i need to install the DBI module on my Sparc-Solaris 8 system. I've read
the README file, and i've followed the steps.
perl Makefile.PL ...OK
but when i do make, tries to compile with cc.
What do i have to change in the Makefile generated to compile with gcc
instead of
Do you have installed GCC before installing Perl ?
-Mensaje original-
De: Neil Jonkers [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, March 28, 2001 10:13 AM
Para: Domingo Nicolas Ferrer (Dep. Fisica); [EMAIL PROTECTED]
Asunto: Re: problem compiling DBI in Solaris 8
In the Makefile
Tim Bunce wrote:
- av_store(av, i, newSViv(ora2sql_type(imp_sth-fbh[i].dbtype)));
+ av_store(av, i, newSViv(ora2sql_type(imp_sth-fbh+i).dbtype));
Umm, why change from subscript to pointer arithmetic?
ora2sql_type needs more then dbtype, so it's called with imp_fbh_t*
as
No that wasn't the case here. Each select only produces 1 result row.
So, I just did a
$sth-execute() or die(...);
$href = $sth-fetchrow_hashref();
In the method... the method is executed in a loop within the caller.
With Sybase, it was necessary to insert a finish after the call to
Curt Russell Crandall wrote:
No that wasn't the case here. Each select only produces 1 result row.
Are you really sure it was 1 row?
So, I just did a
$sth-execute() or die(...);
$href = $sth-fetchrow_hashref();
I would try
while ($href = $sth - fetchrow_hashref)
instead.
In
Hello All...
I am having problems connecting to my PostgreSQL database using DBI/DBD
Background:
PostgreSQL version 7.0.3
DBI version 1.14
DBD.Pg version .95
Perl version 5.6.0
All of the above running on Redhat 7.0 (i386)
When executing a CGI script with the following connect statement:
$dbh
On Wed, Mar 28, 2001 at 10:59:05AM -0500, Peter Seabrook wrote:
When executing a CGI script with the following connect statement:
$dbh =
DBI-connect('DBI:Pg:dbname=shop;host=192.168.100.8;port=5432','postgres',''
,{ RaiseError = 1, AutoCommit = 1});
I receive the following error:
perl:
On Wed, 28 Mar 2001, Alexander Farber (EED) wrote:
Curt Russell Crandall wrote:
No that wasn't the case here. Each select only produces 1 result row.
Are you really sure it was 1 row?
That has been verified. It is a small table containing only 7
rows... for now.
So, I just did a
First of all, I'm not an expert on PHP. But, I believe you
cpan has modules like Mason that could give you what you want
w/o messing with PHP. Actually, I'm not real
big on mixing presentation layers with code and you might consider using
mod_perl or FastCGI instead. That being said, why do
The reason for using Perl I thought was because I thougt PHP was like ASP
which was a technology with some tags to put another language code like
perl into but I learned it is a language in itself.
Dexter
On Wed, 28 Mar 2001, Curt Russell Crandall wrote:
First of all, I'm not an expert on
Ok, I'm down to going through the Makefile.PL to see if I can figure out why
this is failing.
Can anyone tell me if it would help to purchase Pro*C?
Tracy
-Original Message-
From: Roper, Tracy D.
Sent: Tuesday, March 27, 2001 5:18 PM
To: Roper, Tracy D.; '[EMAIL PROTECTED]'
Cc:
Just started using DBI.
I installed DBI DBD-Oracle8 at home, last Sunday, using PPM on Active
Perl.
It connected to my Ora8i test server at home with my first test code.
Great.
Dumped out 23,000 ascii flat records in 11 second from a clunker
Celeron366 server... hmmm, this stuff is
I've recently upgraded from Oracle 7.3.4.4.1 to 8.0.6.2.0 (and DBD
as well). After doing so, I noticed that the following connect
string (which used to work fine) no longer works for remote databases:
$dbh = DBI-connect('dbi:Oracle:@DB','username','password');
but the following still does:
On Wed, 28 Mar 2001, Dexter Coehlo wrote:
The reason for using Perl I thought was because I thougt PHP was like ASP
which was a technology with some tags to put another language code like
perl into but I learned it is a language in itself.
I thinking trying to embed PHP and and Perl (via
On Wed, 28 Mar 2001, Dexter Coehlo wrote:
One other question to educate myself, mod_perl and Fast CGI. Is there
much change in regualr Perl syntax or is it the same , just a different
technology? I remeber considering mod_Perl to sustain db connection.
I can't speak for Fast CGI, but with
Thanks so much for your reply Steve!
The first link (faqplsql.htm) you sent along seems to be the most promising
when I looked at the example
(http://www.orafaqcom/scripts/c_src/extproc.txt). A couple of the other
links seem outdated (288.htm, 267.htm) and much more clunky to implement.
Another
I'll be using a Linux server running the Web Server and the Access DB will
reside on another machine running a win2k server. The Linux box will be the
main web server that currently uses DBD::Oracle to connect to the main
oracle database on a different machine. The access database is a smaller
I have played with another technique...
The PL/SQL trigger writes something into an Oracle Pipe (using the DBMS_PIPE
package). I then created a PL/SQL procedure that knows how to read the same
pipe. From a perl script I can call this procedure and check the contents
of the pipe. If there is
21 matches
Mail list logo
