I all,
I white the script:
#!c:/Perl/bin/perl.exe
use DBI;
use DBD::ODBC;
$dbh = DBI->connect('dbi:ODBC:DSN', 'user', 'pwd');
#$str_sql1 = '
#declare @rownum int
#SELECT @rownum = (select count(*)
#from master..sysprocesses (nolock)
#where l
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
Hi all,
I have a question:
I use DBI and DBD::Oracle with no prob. but I need to retur the number
of rows affected by a select statement, use the "$var = $st->rows" but
it no works in select statements, the other way is making a while
statement to get the result in an array, but I think is a easy
your database's SID is 'TEST' (e.g.: you connect to the
> database with "sqlplus system/[EMAIL PROTECTED]"), then
> your code should read 'dbi:Oracle:TEST'.
>
> HTH,
> Mike
>
>
> -Original Message-
> From: Hernan Arredondo [
Hi all, I'm new in DBI and I'm really stuck, some can explain me this code:
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:db',
'$username',
'$passwd',
) or die "$DBI::errstr";
EOF
its supposed I get a connection with that ?
'dbi: