At 11:44 AM 8/29/2001 +, Piyush Avichal wrote:
Could somebody tell me where I can find the MySql Development Libraries
required for the MySQL DBD.
I've never heard of a MySQL port to VMS. Indeed I don't know of any
freeware or open source RDBMS on VMS. Mimer at least has a free
Craig A. Berry wrote:
At 11:44 AM 8/29/2001 +, Piyush Avichal wrote:
Could somebody tell me where I can find the MySql Development Libraries
required for the MySQL DBD.
I've never heard of a MySQL port to VMS. Indeed I don't know of any
freeware or open source RDBMS on VMS. Mimer
Hi,
I'm trying to write a daemon that accesses my database. I thought I could
create the connection in the parent, and use it in the child. But that
doesn't seem to work. Below is the code. Any help would be appreciated
Thanks
Jay
#!/usr/bin/perl -w
use strict;
use DBI;
use POSIX
Greeting every one,
I need to know the best way to count the number of occurances of multiple
fields in a single table matching some conditions.
For example I have a table consisting of fields
id, name, type, status,
Here the type field can have values
W-Worker,
S-supervisior
M
I am building DBD::Oracle 1.09 against Oracle 8.17 client libs, DBI
1.20, perl 5.005_03 on RH linux 6.1 and I get the following error when I
run 'make':
mkdir blib
mkdir blib/lib
mkdir blib/lib/DBD
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBD
mkdir blib/arch/auto/DBD/Oracle
Hi all,
I'm using Perl 5.004_04 built for PA-RISC1.1 on HP-UX B.11.00 and Oracle
8.0.5
I am installing DBI 1.20 and DBD-Oracle-1.08. I could successfully
install the DBI.
While installing the DBD I got foll. error.
syntax error at Makefile.PL line 808, near '' for
syntax
hiho,
i'm stuck on trying to make DBD::Oracle error messages more
verbose...
i've one machine (Linux, DBI 1.13, DBD::Oracle 1.03, Oracle
8.1.5) which produces 'nice' error messages that contain
'error possibly near * indicator at...' information and
another machine (Linux, DBI 1.20,
Tim,
Can you please let me know why DBD:Oracle will not run on an Oracle 8.1.6
client machine?
By default, 8.1.6 does not create a registry key for ORACLE_HOME. The
machines in question have no problem executing Enterprise Manager, SQL*Plus,
or PowerBuilder applications so I have to believe
[ I'm not on the mailing list, so I apologize if this is already a known
reported problem. Also, if this is insufficient information please
let me know and I can supply a full verbose report as directed in
the README. ]
Attempting to build DBD::Oracle-1.10 under Solaris-2.6 and
Unless I'm missing something, you cannot do this all with one query. You can
do it with two queries, but I'm not sure that would be any more efficient
than handling each with a separate query. The reason you can't get it all in
one query is that one of these will require a Group by clause, and
You need the DBD::Oracle 1.12 build, it fixed my problems ;)
It should be on the mirrors by now...
-john
From: Mark Borges [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: DBD::Oracle-1.10 build problem with Oracle-8.1.7
Date: 31 Aug 2001
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
SELECT COUNT(*) as TOTAL,
(SELECT COUNT(*) FROM Table WHERE status = 'P') as PRESENT,
(SELECT COUNT(*) FROM Table WHERE STATUS IN ('L', 'A',
'O')) AS ABSENT
FROM Table
I don't think sub-selects are suppored in MySQL, unless
Can you please start debugging it, fix the problem, and send me a patch?
Thanks for your time.
Tim.
On Fri, Aug 31, 2001 at 01:27:18PM -0400, Tim Callaghan wrote:
Tim,
Can you please let me know why DBD:Oracle will not run on an Oracle 8.1.6
client machine?
By default, 8.1.6 does not
You should use the ppm utility to install modules.
In command prompt:
ppm install DBD::Oracle
or
ppm install DBD::Oracle8
This will install precompiled binaries.
If you want to compile yourself through nmake, you must have Visual C++
compiler installed on your system as well as the Oracle
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Aug 29, 2001 at 03:23:39PM -0500, Jay Strauss wrote:
I'm trying to write a daemon that accesses my database. I thought I could
create the connection in the parent, and use it in the child. But that
doesn't seem to work. Below is the
-- Stephen Clouse [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Aug 29, 2001 at 03:23:39PM -0500, Jay Strauss wrote:
I'm trying to write a daemon that accesses my database. I thought I
could create the connection in the parent, and use it in the child. But
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sat, Sep 01, 2001 at 02:30:57PM -0500, Steven Lembark wrote:
Actually you can. Trick is to turn on the NO-DESTROY option (forgot the
exact keyword) and let the children destroy things when they exit. It's
actually fairly workable to share a
Hi, All:
I have the almost same problems and I tried to initiate the database
connection in the child. But every time I can only make database connection and
do something only once. If I want to do it again it always shows me the
application error and my server is killed(the program exit).
Quote function is not supposed to quote ? character.
You must do as follows:
my $dbh = DBI-connect(DBI:Pg:dbname=test, postgres, );
my $val = q!\'?:!
my $sth = $dbh-prepare(INSERT INTO foo (a) values (?));
$sth-execute($val);
(And no explicit calls to quote
19 matches
Mail list logo