DBI pager possible?

2004-05-19 Thread leegold
I see a module called Data::Pageset. I honestly do not understand the doumentation. If anyone could give me a very simple working code example or recommend a way to paginate ie. split up a big DBI table display into several CGI browser pages I would be grateful. Thanks, Lee G. -- http://www.fast

RE: need to pull multi-byte out of a varchar2 field

2004-05-19 Thread Lincoln A. Baxter
VARCHAR2 _will_ support multibyte characters, in the DATABASE CHARSET is multibyte (utf8) or al16utf16. DBD-Oracle 1.15 has almost no support for them how ever. DBD-Oracle-1.16 will have pretty good support for them and a much of tests ilustrating that support. On Wed, 2004-05-19 at 19:00,

RE: need to pull multi-byte out of a varchar2 field

2004-05-19 Thread Ian Harisay
Another thing to mention is that all my characters are being translated to \277 >>>Reidy, Ron <[EMAIL PROTECTED]> 05/19 10:00 am >>> I am not sure if VARCHAR2 supports multi-byte data. Are you sure it is VARCHAR2 and not NVARCHAR2? - Ron Reidy Senior DBA Ar

RE: need to pull multi-byte out of a varchar2 field

2004-05-19 Thread Ian Harisay
the data type just shows as VARCHAR2(100) when I do a describe on the table >>>Reidy, Ron <[EMAIL PROTECTED]> 05/19 10:00 am >>> I am not sure if VARCHAR2 supports multi-byte data. Are you sure it is VARCHAR2 and not NVARCHAR2? - Ron Reidy Senior DBA Array BioPharm

RE: need to pull multi-byte out of a varchar2 field

2004-05-19 Thread Reidy, Ron
I am not sure if VARCHAR2 supports multi-byte data. Are you sure it is VARCHAR2 and not NVARCHAR2? - Ron Reidy Senior DBA Array BioPharma, Inc. -Original Message- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 4:27 PM To: [EMAIL PROTECTED] Sub

need to pull multi-byte out of a varchar2 field

2004-05-19 Thread Ian Harisay
Hi, Can anyone tell me how to pull multi-byte characters out of a varchar2 field. The database is Oracle. I need to transfer these chars from one db to another. Thanks, Ian

RE: Problem Installing DBD Oracle

2004-05-19 Thread Jeff Urlwin
> > > Hi there, > > I got a problem installing DBD-Oracle-1.15. > > I try to include all Information as described in README: > > 1) > nmake realclean > > 2) > perl Makefile.PL -v (see attached log.perl.Makefile.PL) > > 3) > nmake (see attached nmake.log) > > > Well, and there I ge

Problem Installing DBD Oracle

2004-05-19 Thread Imre Saling
Hi there, I got a problem installing DBD-Oracle-1.15. I try to include all Information as described in README: 1) nmake realclean 2) perl Makefile.PL -v (see attached log.perl.Makefile.PL) 3) nmake (see attached nmake.log) Well, and there I get fatal error LNK1120: 1 unresolved exte

Makefile Problem

2004-05-19 Thread subramanyam malepati
 Hi,there I am trying to install bugzilla on my redhat 7.3. I failed to install bundle::bugzilla. so I decide to upgrade my perl to 5.8.0. Then I run perl -MCPAN -e 'install "Bundle::Bugzilla"' It complained something wrong with DBD::mysql, I download this module and tried to install it manual

Re: Returning blob in sql

2004-05-19 Thread Wieland Pusch
Hello, I think you have to insert, select for update, ora_lob_write. This is how I understand the oracle docs. I use Ora8i and Windows at the moment, but it should be the same. My test script does it like this: -- my $sth = $db->prepare( <<" SQL" ) or die "insert $DBI::errstr"; INSERT IN

proxying DBI connection

2004-05-19 Thread mbahari
Tim, I have a few questions regarding proxy server. I'm trying to create a connection form 'machineA' to 'machineB' using 'machineC' as the proxy (Because ella have all the necessary driver to connect to the Oracle database in 'machineB'). I believed the three machines have everything they ne

perl.dbi.users DBI.pm issue on windows uninitialized values

2004-05-19 Thread kevin . chen . ctr
Tim, It seems I met same kind of problem. Do we have any solution on that? The strange thing is that I can successfully connect to some database. But also failed to connect on others. Thanks a lot. -- Kevin http://coding.derkeiler.com/Archive/Perl/perl.dbi.users/2003-12/0078.html 0078.ht