Re: Fwd: DBI sql and pagination for a flat-file

2004-05-26 Thread Jeff Zucker
leegold wrote: If someone could just tell me very schematically what they think...I'm not looking for anyone to write the code for me. ie. what's the best way to paginate a very big flat-file db? You'll get better results for general CGI questions on perlmonks or comp.lang.perl.modules. The part

Fwd: DBI sql and pagination for a flat-file

2004-05-26 Thread leegold
If someone could just tell me very schematically what they think...I'm not looking for anyone to write the code for me. ie. what's the best way to paginate a very big flat-file db? Actually it's looking like: http://www.stonehenge.com/merlyn/WebTechniques/col02.html to get pagination on a web page.

RE: make problem

2004-05-26 Thread Hom, Soo
Thanks for the tip! That fixed my problem. Now I am getting an ld error: pascal# make cp Oracle.pm blib/lib/DBD/Oracle.pm cp oraperl.ph blib/lib/oraperl.ph cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h cp Oraperl.pm blib/lib/Oraperl.pm cp Ora

Re: make problem

2004-05-26 Thread Tim Bunce
On Wed, May 26, 2004 at 02:22:59PM -0700, Hom, Soo wrote: > Tim, > > I gave it a try but it didn't seem to help... > pascal# perl -i.bak -p -e '$_="" if /^#line/' Oracle.c > pascal# make > gcc -c -I/export/home/oracle/rdbms/demo > -I/export/home/oracle/rdbms/public -I/export/home/oracle/plsql/pu

RE: make problem

2004-05-26 Thread Hom, Soo
Tim, I gave it a try but it didn't seem to help... Oracle.c: In function `XS_DBD__Oracle__db_ora_lob_write': Oracle.c:874: error: syntax error before '*' token Oracle.xs:126: error: `data' undeclared (first use in this function) Oracle.xs:126: error: (Each undeclared identifier is reported o

Re: make problem

2004-05-26 Thread Tim Bunce
On Tue, May 25, 2004 at 02:28:36PM -0700, Hom, Soo wrote: >I am attempting to run make on DBD-Oracle-1.15 and I get this fatal error: > >gcc -c -I/export/home/oracle/rdbms/demo -I/export/home/oracle/rdbms/public >-I/export/home/oracle/plsql/public -I/export/home/oracle/network/public

DBI sql and pagination for a flat-file

2004-05-26 Thread leegold
I can access a flatfile with the DBI sql and have the pager "working", But I'm not sure how to blend them. In reality i'll have a flat file with over 1000 recs eventually paginated in CGI. There are some points that confuse me. my newbie 1st try see below. *Question:* What I really want to do: I

Re: DBD::Oracle 1.15 linking path problems with Oracle9i

2004-05-26 Thread Charles Jardine
Marko Asplund wrote: hi i'm compiling DBD::Oracle on Red Hat Linux 8.0 and HP-UX 11.00 against Oracle9iR2 client libraries. the compilation process goes without problems but the resulting DBD::Oracle library gets linked against libraries in the wrong path. Oracle9i libraries are installed und