If you have Oracle 8 (I missed the start of this thread, so I don't know
what you're using, sorry), you can use a RETURNING clause with an UPDATE.
Something like this (untested):
#!/usr/local/bin/perl
use strict;
my $sql = q{ INSERT INTO REPORT
VALUES (
Tim,
Thank you for your reply.
Okay, I *read* the README and README.hpux and search through the archives.
Followed as much as I could in the article written by LBaxter
http:[EMAIL PROTECTED]/msg08776.html
but still can't get DBD to go as I don't know the equivalent compile flags
(+z) for
On Tue, 12 Feb 2002, Tim Bunce wrote:
: Does anyone here know if DBD::Pg starts a new transaction after a
: COMMIT? That is, it appears that...
the driver is free to not start a new transaction until the application
does any DDL or DML statements.
DDL? DML? Please enlighten me.
rob
When we need to send result through email, we use sub-function like
this:
sub trap_die
{
my @param = @_;
$message = $param[0];
$CommandString = /bin/mailx -s \$message\ cshao\@traffic.com
/dev/null;
system ( $CommandString );
}
trap_die
Has absolutely nothing to do with DBI. Please do not send off topic emails
to this list. Refer them to another list where this subject would be on
topic.
Ilya
-Original Message-
From: Shao, Chunning
To: [EMAIL PROTECTED]
Sent: 2/13/02 9:00 AM
Subject: Help: Email problem with perl
This is slightly off-track for the list but try something like this:
open (MAIL,|/usr/bin/mailx -s 'Error Notification' cshao\@traffic.com);
print MAIL $message;
close (MAIL);
-Original Message-
From: Shao, Chunning [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002
Hi,
The DBI docs state the following:
Binding an `undef' (NULL) to the placeholder will not
select rows which have a NULL `product_code'! Refer to the
SQL manual for your database engine or any SQL book for
the reasons for this. To explicitly select NULLs you have
Jeff,
Thanks...I will give it a try...One more question though.
From what I am reading, will have to configure odbc.ini for each
datasource I want to connect to? Can a DSNless connection be created
with this setup?
Thanks again...
Bill
Jeff Urlwin wrote:
Bill,
Yes, I've successfully
Some history first : My comments will be indented. I was having
trouble compiling the DBI/DBD modules into perl so at Sun
support's request I downloaded the latest version from sunfreeware.com, the 5.6.1
version. I also downloaded the gcc
compiler out there too version 2.95.3
I downloaded the file DBI-1.201.tar.gz from the CPAN site. The
Makefile.PL works just fine but I am having problems with my cc
compiler. Does anyone know if I can compile with gcc instead of cc? The cc
compiler on Irix 6.5 is unlicensed and applying for an evaluation license
through SGI gives the
Rebuild perl from sources, using the gcc off the freeware cd. I did this a
month ago and it went in a smooth as a baby's behind.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 4:30 PM
To: [EMAIL PROTECTED]
Subject: DBI install
I have some object oriented modules that use DBI's connect_cached
method. I'm porting these modules to mod_perl and I see that there is a
Apache::DBI module that seems like it is doing the same thing that would
happen under mod_perl using connect_cached, the only difference being
that
This might be a bit off topic, but...
[snip]
... WHERE (product_code = ? OR (? IS NULL AND
product_code IS NULL))
and bind the same value to both placeholders.
I understand the reasoning for this, and why it's the only way for
database servers that don't understand = null.
Bill,
You can probably create a DSN less one, but I'd get a working DSN version
first. Then, put the same parameters in the DSN-less connection, i.e
DriverName=;Servername=;etc.
Jeff
-Original Message-
From: Bill McClintock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13,
A bug in DBD::Pg can cause it to loop infinitely or crash when ping() is
called on a disconnected database handle. In the disconnect() method,
DBD::Pg calls PQfinish() which closes the connection and *frees the
memory for the handle*. Later, if I call ping() on the disconnected
dbh, DBD::Pg
My config script points to
the same server for mysql. How do I get the add.pl
script to point to the server where mysql is.
Config file:
sub
configure {
# CGI CONFIGURATION VARIABLES
$mailprogram
=
Jeff Urlwin writes:
This might be a bit off topic, but...
[snip]
... WHERE (product_code = ? OR (? IS NULL AND
product_code IS NULL))
and bind the same value to both placeholders.
I understand the reasoning for this, and why it's the only way for
Hello everyone,
I just began messing with perl and mysql a couple of weeks ago. I am
having a lot of trouble updating fields to null in a record. It must be
a syntax error. I have tried ip=null, ip='null'. I can insert new
records , delete and select records.
Any ideas are appreciated.
cc ERROR: cannot exec /usr/lib32/cmplrs/fec
You probably need the C Front-end, versions should show both c_dev and c_fe
Its part of the os release, you've just got to find the right cd
I c_dev08/17/98 C Headers and Libraries, 7.2.1
I c_fe 10/01/98 C
Dear all,
We have a number of scripts running that can work for both MySQl and Oracle
databases.
The scripts does a lot of DB-access (select, update, insert). The number of
accesses depends on the size of the folder we are processing. The larger the
folder, the more accesses we get.
While
20 matches
Mail list logo