Hello fellow DBI users/developers. We are currently trying to update
the DBI FAQ and I'll be in charge of collecting the material and
updating the current FAQ.
Please send me any material and/or ideas you feel is needed to be
included in the FAQ. Our current FAQ is very slim and needs major
Hi there,
On Wed, 13 Mar 2002 [EMAIL PROTECTED] wrote:
However, when I do a random query I get some blank pages. I traced this to
the DBI Log using the DBH-Trace(2, /tmp/DBI.log). I found that sometimes
the execute() returns 0E0. Does anybody knows why??
It probably means zero multiplied
Hi,
How do I succesfully preserve the column order (''$fields'=
$joined_col') in my array-of-hashes generated using DBIx::Recordset?
When I run the code below, the column order doesn't differ at all from
when I don't 'tie' the %main::set hash.
I don't expect Tie::IxHash to work in the
if(undef %fdat) {
This will undef the content of %fdat so it will always be empty!!!
To test if a variable is defined used defined($foo), but you can't ask for
a hash or a array if it's defined, you only could ask if it contains any
keys, so you need to write:
if (keys %fdat == 0) {
However, when I do a random query I get some blank pages. I traced this to
the DBI Log using the DBH-Trace(2, /tmp/DBI.log). I found that sometimes
the execute() returns 0E0. Does anybody knows why??
It probably means zero multiplied by ten to the power zero, or to put
it another way,
I am trying to install DBD on one of my systems. All of them have gone
fine except one. I have Installed DBI with no problems but when I try to
perl Makefile.PL for DBD I get:
Can't locate loadable object for module DBI in INC (INC contains:
/usr/local/perl/lib/5.00503/sun4-solaris
Hi,
I want to compile the module DBD Perl on solaris 7.
I use gcc-2.95.2 or later, Perl 5.6.
When I run the make test for the Msql-Mysql-modules-1.2219, It's not OK.
The error message is :
t/00baseinstall_driver(mysql) failed: Can't load
'../blib/arch/auto/DBD/mysql/mysql.so' for
- Original Message -
From: Steve Coates [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 06:56
Subject: problems building DBD
I am trying to install DBD on one of my systems. All of them have gone
fine except one. I have Installed DBI with no problems but when
However, when I do a random query I get some blank
pages. I traced this to
the DBI Log using the DBH-Trace(2, /tmp/DBI.log).
I found that sometimes
the execute() returns 0E0. Does anybody knows
why??
If I remember rightly 0E0, in DBI, means Success ie
:
your query worked, but no rows
On Wed, Mar 13, 2002 at 06:07:01AM +, [EMAIL PROTECTED] wrote:
In the past someone posted a problem with mod_perl and DbI giving blank
pages from a SQL query. I did some digging around and found some info but I
need someone to fill in the holes for me a little.
I created a DB Table
Hello there,
To make the introduction short, I have a database and I'm fetching infos for
events for a particular month.
So when I fetch I get, per line, the date (only the day of the month), the
eventID (unique) and the name of the event.
my $rs_ref = $dbh-selectall_arrayref (SELECT evtDate,
I am don't know what database you using but perhaps converting evtDate to
Unix time stamp might help your sorting problem.
Anton
-Original Message-
From: Etienne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Need help with map and sort
-- Etienne [EMAIL PROTECTED] on 03/13/02 11:39:07 -0500
Hello there,
To make the introduction short, I have a database and I'm fetching infos for
events for a particular month.
So when I fetch I get, per line, the date (only the day of the month), the
eventID (unique) and the name of
On 2002-03-13 11:39:07 -0500, Etienne wrote:
my $rs_ref = $dbh-selectall_arrayref (SELECT evtDate, evtID, evtName FROM
events);
# now if I want to make the sum of the dates (juste an example) I would do
my $sum = 0;
map { $sum += $_-[0] } @{$rs_ref};
# ok this was a basic map..
But how
Hi
( 02.03.13 11:39 -0500 ) Etienne:
my $rs_ref = $dbh-selectall_arrayref (SELECT evtDate, evtID, evtName FROM
events);
map { $sum += $_-[0] } {$rs_ref};
While TMTOWTDI, since you're not doing anything with the return value
from map, you're better off using foreach. Unless you get paid more
Hi
( 02.03.13 11:03 -0600 ) [EMAIL PROTECTED]:
see Schwartzian Transform in the cookbook or camel.
Even better- Uri Guttman's paper on sorting [munge data BEFORE sorting
since default sort is much faster].
--
\js aggregate proactive e-services
Help?
A quick question
I've currently got a PL/SQL procedure which returns several OUT params which are
basically the fields of the result set, which is always 1 row in this case.
Instead of returning several params, it would be simpler if I could just define a
record type and return
Help?
A quick question
I've currently got a PL/SQL procedure which returns several OUT params which
are basically the fields of the result set, which is always 1 row in this
case.
Instead of returning several params, it would be simpler if I could just
define a record type and return an
Has anyone seen this before? Is there a DBI limit or is this a passthru
from the underlying database (driver) in this case oracle... in which case I
know what has to happen to cure it.
Lincoln
There is a 'max number of processes exceeded' error in Oracle. My guess is that this
is coming thru from the database.
The init.ora parameter is max_processes or something like that.
[EMAIL PROTECTED] wrote:
Has anyone seen this before? Is there a DBI limit or is this a passthru
from the
- Original Message -
From: Roy Ledochowski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 10:22
Subject: PL/SQL records and DBD::Oracle help?
Instead of returning several params, it would be simpler if I could just
define a record type and return an instance
Hi!
I'm working with oracle, and wanting to manipulate the NLS_DATE_FORMAT. I
know I can change it in the init.ora file for my database, but I don't want
to affect all objects in the db, just my schema. So I wrote a trigger to
help me out:
CREATE OR REPLACE TRIGGER init_date
AFTER LOGON ON
Wow this one was pretty easy with the order by :)
Now I get my events..
my $res = $dbh-selectall_arrayref (SELECT evtDate, evtName FROM events
ORDER BY evtDate);
I can print the first set using
print Date: @{$res}[0]-[0] Event name: @{$res}[0]-[1];
now let's say I want to get to the second
There is a 'max number of processes exceeded' error in Oracle.
My guess is that this is coming thru from the database.
The init.ora parameter is max_processes or something like that.
[EMAIL PROTECTED] wrote:
Has anyone seen this before? Is there a DBI limit or is this a passthru
from
On Wed, 13 Mar 2002 15:42:18 -0500
Etienne [EMAIL PROTECTED] wrote:
Wow this one was pretty easy with the order by :)
Now I get my events..
my $res = $dbh-selectall_arrayref (SELECT evtDate, evtName FROM events
ORDER BY evtDate);
I can print the first set using
print Date:
First, thank you Jeff for the PPD distribution of DBD-ODBC 0.39.
ActiveState hasn't been able to get past 0.28.
Second, I still have problems with stored procedures that return
multiple result sets. The code below should return two results
sets: one result set has 1 row of five columns,
Attached are output from Makefile.PL and two passes of
make -k. Make fails with:
gcc -c -I/opt/oracle/product/8.0.5//rdbms/demo
-I/opt/oracle/product/8.0.5//rdbms/public
-I/opt/oracle/product/8.0.5//plsql/public -I/opt/oracle/product/8.0
..5//network/public
See archives.
Comment out (or #ifdef) the lines.
Tim.
On Wed, Mar 13, 2002 at 03:53:42PM -0600, [EMAIL PROTECTED] wrote:
Attached are output from Makefile.PL and two passes of
make -k. Make fails with:
gcc -c -I/opt/oracle/product/8.0.5//rdbms/demo
Comment out (or #ifdef) the lines.
Comment got them to compile; figured it was worth
checking if it would hurt me.
Where are the archives?
thanx.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
Hi,
I'm trying to install DBD::ODBC so i can use it but the make command exit
for a reason, I hope, you will tell me. Thank you.
i have run perl Makefile.PL
output:
dieselfournier# make
cc -c -I. -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI
-DVERSION=\0.39\
thanks for the reply. Like I said, I haven't seen it explicitly stated
anywhere that PL/SQL records don't work. I tried the perl docs first.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 12:01 PM
To: Roy Ledochowski; [EMAIL
It would be helpful if I knew which ODBC driver manager you are linking to.
If you are NOT linking to a driver manager and linking directly to a
database, please link to a driver manager. If you can't, then let me know
which driver you are linking with and I'm sure we can find a work-around.
32 matches
Mail list logo