I make a page that returns the result of a select statement in Perl
and DBI, but a lot of rows are returned, there is a way to page the
result ?
Yes, there are several modules for this.
The best one (easy to use, all the functions you need in one place)
I've used is Data::Paginate (http://search.
Hernan Arredondo wrote:
Hi all,
Hello,
I make a page that returns the result of a select statement in Perl
and DBI, but a lot of rows are returned, there is a way to page the
result ?
Yes, there are several modules for this.
The best one (easy to use, all the functions you need in one place) I've
use warnings;
use strict;
$serial = 0800690COA; #is being converted to an octal number by perl
$serial = abc; # will give you an error with the above pragmas set.
Lincoln
-Original Message-
From: Jim Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 2:27 PM
To: dbi-users@pe
Hi all,
I make a page that returns the result of a select statement in Perl
and DBI, but a lot of rows are returned, there is a way to page the
result ?
Regards
Hernan Dario
--
No matter how fast processors get,
software consistently finds new ways to eat up the extra speed
It's not being set that way. It is a variable that was loaded by a
select from another table. It's a string as far as perl is concerned
but in this case the DBD routines are screwing it up, I believe. My
mistake for not showing compilable code, what I meant to say was if I
set the variable $
I'm trying to select from a table where the serial number apparently
looks like an octal number to Oracle and I haven't been able to figure
out how to convince it otherwise.
My last attempt looks like:
my $rc = $sth->bind_param(1,$serial,{ora_type=>ORA_STRING,
ora_csform=>SQLCS_NCHAR});
I
This sounds terribly familiar!
Check out comments in my Sys::SigAction module. Referred to in DBD::Oracle
docs I think. You may find something useful in there too. There is an
oracle specific POD and test script. I strongly suspect that Oracle OCI
libraries might be didling with signal() or siga
Oh, the joys of Oracle. Add "require DBD::Oracle;" to check if it's
a load-time or connect-time issue. Print $!. Use process tracing
tools (like truss, ktrace etc) to see what's happening. Let us know
what you find. Have the appropriate amount of fun!
Tim.
On Tue, Jan 25, 2005 at 03:51:40PM +0100
The <*> is a tag that Oracle inserts into the error message, just before the
SQL character or word that it thinks is raising the error. For example:-
ORA-00904: invalid column name (DBD: error possibly near <*> indicator at
char 46 in 'select honk, bang from my_barking_db where <*>honk in
('arf',
I have a strange problem when connecting to an Oracle 10 database:
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $rc = system "true";
print "Before: $rc\n";
my $dbh = DBI->connect("dbi:Oracle:", "scott", "tiger");
$rc = system "true";
print "After: $rc\n";
$SIG{CHLD} = 'DEFAULT';
On 01/25/2005 01:29 AM, Waghmare, Satish (IE03x) said:
Please help me to know how to I download the DBI packages from FTP site. I'm
using ActiveState ActivePerl 5.8 on Win-XP system.
Please see below Error log:
C:\Documents and Settings\SatishW>ppm install
http://ftp.esoftmatic.com/outgoing/DBI/5.8
Tim Bunce wrote:
At that time I decided to omit this deprecated #define in sqlext.h:
/* Deprecated defines from prior versions of ODBC */
#define SQL_DATABASE_NAME 16/* Use
SQLGetConnectOption/SQL_CURRENT_QUALIFIER */
Attached is a patch - if Tim likes it?
Is there any rea
On Mon, Jan 24, 2005 at 08:13:37AM -, Mark Edwards wrote:
> I have been experiencing some problems with the following configuration:
>
> Solaris 5.7 on a Sun Ultra-250, running Apache 2.0.48, mod_perl 1.9913
> (built as DSO)
>
> I'm using the following perl modules:
>
> Perl 5.8.0
> DBI 1.46
On Mon, Jan 24, 2005 at 01:49:55PM +0100, Steffen Goeldner wrote:
> Phillip Hellewell wrote:
>
> > Hello,
> > I'm using DBI and DBD:ODBC in my perl script. I'm also using
> > DBI::Const::GetInfoType. I was trying to get the database name using
> > $dbh->get_info( $GetInfoType{SQL_DATABASE_NA
Hi :
Please help me to know how to I download the DBI packages from FTP site. I'm
using ActiveState ActivePerl 5.8 on Win-XP system.
Please see below Error log:
C:\Documents and Settings\SatishW>ppm install
http://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBI.ppd
Error: No valid repositories:
Error
If you are using oracle count(*) is best. According to oracle anyways.
-Original Message-
From: "amonotod"<[EMAIL PROTECTED]>
Date: Mon, 24 Jan 2005 21:47:00
To:"dbi-users@perl.org"
Cc:"Hernan Arredondo"<[EMAIL PROTECTED]>
Subject: Re: Affected Rows
> From: amonotod <[EMAIL PROTECTED]
Thanks a lot
Best Regards,
Vivekananda M
BP Operate - BeyondBP
Phone: 00-91-80-28520408 (Ext #5359)
Wipro Technologies
Email: [EMAIL PROTECTED]
Helpdesk URL: ehelpline.bpweb.bp.com
Helpdesk Phone: 00-91-80-51381734/00-91-80-51381748/00-91-9845796558
-Original Message-
From: David N M
17 matches
Mail list logo