On Thu, 26 Sec 2002, Leideck, Wolfgang wrote:
Bret Webb <[EMAIL PROTECTED]> writes:
>
> Yep. Have those. The perl log file sent with the original message references
> this. I notice that the cccdlflags='+Z' you referenced is uses a cap Z. Does
> this make a difference, as mine is lowercase.
The
Hardy Merrill wrote:
>
> Be careful about using the "rows" method - here's a section
> from 'perldoc DBI':
>
>"rows"
> $rv = $sthâ??>rows;
>
>Returns the number of rows affected by the last row affecting comâ??
>mand, or â^?1 if the number of rows is
On Thu, 26 Sep 2002 21:46:16 +0100, Tim Bunce wrote:
>If that may happen then it's safer to try the insert first and if that
>fails due to a duplicate key then do the update.
At least MS Access has the problem that an autoincrement field (or
whatever it is called in Access) IS incremented even i
On Thu, Sep 26, 2002 at 02:10:00PM -0600, Tkil wrote:
> > "Chad" == chad kellerman <[EMAIL PROTECTED]> writes:
>
> Chad> I want to check to see if the hosts exists. IF it does update
> Chad> if not insert.
>
> Note that some databases have this functionality built-in; MySQL has a
> REPLACE
Be careful about using the "rows" method - here's a section
from 'perldoc DBI':
"rows"
$rv = $sth‐>rows;
Returns the number of rows affected by the last row affecting com‐
mand, or −1 if the number of rows is not known or not available.
Gener
> "Chad" == chad kellerman <[EMAIL PROTECTED]> writes:
Chad> I want to check to see if the hosts exists. IF it does update
Chad> if not insert.
Note that some databases have this functionality built-in; MySQL has a
REPLACE primitive that does exactly this.
In other databases, I typically t
chad kellerman wrote:
>
> Hello everyone,
>
>I was wondering, what would be the easiest way to check for the
> results of a select statement?
>
>For example, if I connect and say select host from host where
> host="domain.com";
>
>I want to check to see if the hosts exists.
>
>
Hello everyone,
I was wondering, what would be the easiest way to check for the
results of a select statement?
For example, if I connect and say select host from host where
host="domain.com";
I want to check to see if the hosts exists.
IF it does update if not insert.
I have:
my $
On Thu, Sep 26, 2002 at 09:47:49AM -0700, Michael A Chase wrote:
> On Thu, 26 Sep 2002 12:32:28 -0400 Pooya Woodcock <[EMAIL PROTECTED]> wrote:
> > I'm getting a segfault w/ oracle 9i-64bit, DBD-Oracle-1.12,
> > DBI-1.30, perl 5.80. compiled with sun forte C 6 update 2, flags:
> > "-mt -fast -xchi
On Thu, 26 Sep 2002 12:32:28 -0400 Pooya Woodcock <[EMAIL PROTECTED]> wrote:
> I'm getting a segfault w/ oracle 9i-64bit, DBD-Oracle-1.12,
> DBI-1.30, perl 5.80. compiled with sun forte C 6 update 2, flags:
> "-mt -fast -xchip=ultra2 -xarch=v9a -xlic_lib=sunperf".
> The segfaults come at the end
Hello,
I'm getting a segfault w/ oracle 9i-64bit, DBD-Oracle-1.12,
DBI-1.30, perl 5.80. compiled with sun forte C 6 update 2, flags:
"-mt -fast -xchip=ultra2 -xarch=v9a -xlic_lib=sunperf".
The segfaults come at the end of any series of queries -- that is,
at the END of the scripts. I'm thinking t
On Thu, 26 Sep 2002 16:32:24 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote:
> - Forwarded message from "Clisham, Chris D [PCS]"
> <[EMAIL PROTECTED]> -
>
> Delivered-To: [EMAIL PROTECTED]
> From: "Clisham, Chris D [PCS]" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> S
Matthew,
You are stomping on shaky ground. The last I tried UnixODBC and FreeTDS was
..53 and I had issues. I haven't tried .60, but I'd suggest doing the
following:
1) Login as your www user (if possible) and try isql.
2) adding a logging function in FreeTDS's odbc.c in the Log
I've changed the ownership of odbc.ini and odbcinst.ini to my www user, but
to no avail. I also have freetds logging all error messages, but nothing is
logged to the freetds file when this cgi file is run. When I run isql,
freetds logs that transaction with no problem.
BTW, here are the versi
On Wed, Sep 25, 2002 at 11:31:11AM -0700, Thomas Hilbig wrote:
> I've sifted through the years of archives on how to
> tell if a prior database handle established using
> DBI->connect_cached exists or not.Any examples
> that I have found do not work for my needs. While the
> $dbh->{CachedKids
- Forwarded message from "Clisham, Chris D [PCS]" <[EMAIL PROTECTED]>
-
Delivered-To: [EMAIL PROTECTED]
From: "Clisham, Chris D [PCS]" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: I don't want to bug you but.
Date: Thu, 26 Sep 2002 09:27:06 -0500
I need to
- Forwarded message from "LINDEMANN,JOERG (HP-Germany,ex1)"
<[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: "LINDEMANN,JOERG (HP-Germany,ex1)" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: Installa
- Forwarded message from Rob Long <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Wed, 25 Sep 2002 17:08:52 -0400
From: "Rob Long" <[EMAIL PROTECTED]>
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: DBD-Oracle-1.12 install with Oracle 9i Release 2?
Tim,
DBI 1.25 success
Make sure the permissions of the web server user allow access to the drives,
ini files, etc. I don't know much more abot freeTDS, though, so I'd
probably start there to find out what caused the error.
Also, since you don't say which version of DBD::ODBC you are using, I know
there were some conn
Dear group,
Have you ever had a need to move a table into a partitioned or subpartitioned table,
while your table can not be off line any minutes? Or any other need to redesign your
table on a 24/7 database?
Oracle 9i has a package DBMS_REDEFINITION, but it can not work on 8i, and it is far
Dear Sir/Madam
When I am installing dbd for MySQL connection it asks for the location of
MySQL. We have installed MySQL on another networked machine. Should the DBD be
installed on the machine where mySQL is installed or does it not matter? And
what location to we need to give for MySQL?
Than
I'm sure I'm overlooking something really simple, but I can't find any
documentation to help troubleshoot my problem.
When running a cgi script that uses DBI and the DBD::ODBC pm, this is error
message is deposited into my www error logs.
DBI->connect(SQL) failed: [unixODBC]tds_connect failed
It has to do with your compiler most likely. Your DBI **has** to be
compiled with the same compiler used to compile the Perl install for which
you are installing the DBI.
Ilya
-Original Message-
From: Anand Sengodan
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 9/26/02 3:25 AM
Subje
Hello,
the output of your logfiles seems ok. I'm not sure if the
compile option +Z must be capitalized but it works for me.
Wolfgang
-Ursprüngliche Nachricht-
Von: Bret Webb [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 25. September 2002 19:55
An: Leideck, Wolfgang; [EMAIL PROTECTED]
B
> Guess it just caught me off guard. I have been able to place reference to
> objects and such wihtout trouble. What part of DBH makes it special?
You can store objects whose behavior is intended to handle
threads; otherwise the behavior becomes self-destructive.
Making something an "object"
I think by default it should work with AMERICAN. That is my default. In order to use
extended character set, I set mine to FRENCH_FRANCE. I would suggest that this is a
feature of your database.
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-
From: Bacovcin, Micha
Dear Sir/Madam
I am installing DBI version 1.30 on a Solaris 2.9 (5.9 Generic sun4u sparc
SUNW, Ultra-5_10) machine that has gcc version 2.95.3 20010315 (release) that
has perl version v5.6.1. When I run perl Makefile.PL it sucessfully completes.
But then why I run 'make' the following error r
Guess it just caught me off guard. I have been able to place reference to
objects and such wihtout trouble. What part of DBH makes it special?
-Original Message-
From: Steve Sapovits [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 3:32 PM
To: [EMAIL PROTECTED]; DBI Mailin
You need to read up on shared memory. You can't share
pointers between processes and expect them to have any
meaning -- they're addresses from the memory space of
the creating process. You can put them in the shared
memory segment. But they'll just refer to meaningless
memory addresses in an
29 matches
Mail list logo