-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> I can't find anywhere in the documentation, how to fetch the OID returned
> by the PostgeSQL, after an INSERT.
>
> I found, that in sub DBD::PgPP::CompletedResponse::compute()
> [PgPP.pm:1505, VERSION=3D0.04] the OID value is stored, but I am not
Andy Hassall wrote:
The general approach is to always use placeholders, and never directly
interpolate values into SQL statements. This should insulate you from
whatever encoding's needed. Constants in SQL are OK, but if you're putting
encoding as in quote()ing or encoding as in prepare/execute
On Mon, May 10, 2004 at 10:11:29AM -0500, Gram M. Ludlow wrote:
> Good morning!
> I have been in charge of installing Oraperl on a bunch of our HPUX systems.
Oh joy :)
> I resolved the issue. I thought you might want to add it to your
> README.HPUX at some point.
Thanks.
Tim.
The general approach is to always use placeholders, and never directly
interpolate values into SQL statements. This should insulate you from
whatever encoding's needed. Constants in SQL are OK, but if you're putting
Perl variables in a statement, in most cases this is not the best choice.
e.g.
Scott T. Hildreth wrote:
I guess it would depend on which database you are using. I would try
Good point :)
I'm thinking MySQL, since this specific app will use MySQL excusively...
it with a bind column and let the DBD driver handle the quoting if need
be,
I'm really hoping MySQL will work
James D. White wrote:
You could try using two connect calls with two different DB handles.
Prepare the select using one
DB handle and insert with the other. A commit on the second DB handle
should not close the
fetchrow_array cursor on the first.
James D. White ([EMAIL PROTECTED])
Department
Anyone ever do this before?
JupiterHost.Net wrote:
Hello DBI folks!
If I have a column that is binary and data that is binary do I simply
$dbh->quote() it on an insert?
IE
my $binary_content = get_binary_stuff();
my $binary_content_Q = $dbh->quote($binary_content);
$dbh->do("UPDATE MyStuff
ORA-03113 is a kond of "catch all" error. The real problem will be defined in your
alert.log file.
-
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-Original Message-
From: Zhang, George [mailto:[EMAIL PROTECTED]
Sent: Monday, May 10, 2004 10:01 AM
To: [EMAIL PROTECTED]
Sub
Dear friends,
I have the following issue and wondering if you can help me:
I am using Perl / DBI / DBD-Oracle on a Fedora box to connect to our 817
database (on win2k server). DBI/DBD::Oracle has been built against Oracle
9.2.0.1 on linux. It connects and is able to select from local tables, but
Good morning!
I have been in charge of installing Oraperl on a bunch of our HPUX systems.
I've gone from 10.20 all the way to 11i. I found your cpan.org site, which
has almost all of the information that I already gleaned from sources
abroad. Thanks for maintaining all this, it's a great tool to us
>
>
> Hello,
>
> think you're missing a "~" in your Makefile.PL.
>
> ...
> my $arext = $Config{lib_ext};
>
> # fix to avoid foo..ext on many systems.
> $arext = s/^\.//;
> !
>
> better works
> $arext =~ s/^\.//;
>
> best regards
>
> ... awaiting version
>
>
> Check out http://www.cedet.dk/perl/index.html. A copy of the
> files from ftp://esoftmatic.com/outgoing/DBI is there. You
> need to download and access them locally from ppm.
Yes, and the pattern, rather than using the AS build # is to use the perl
Version # 5.8.x, which should keep com
Hello,
think you're missing a "~" in your Makefile.PL.
...
my $arext = $Config{lib_ext};
# fix to avoid foo..ext on many systems.
$arext = s/^\.//;
!
better works
$arext =~ s/^\.//;
best regards
... awaiting version 1.10 ;-))
rudi
--
NEU : GMX Internet.F
13 matches
Mail list logo
