Re: total row count with SQL 'LIMIT' batching

2002-08-17 Thread Jeff Zucker
A M Thomas wrote: It makes a lot of sense from a user interface point of view to show the web user the _total_ number of records that match the search criteria, and possibly, calculated from that, the number of batches (think Google). I don't know of any way in SQL other than a second

Re: Threading and DBI in perl 5.8.0

2002-08-17 Thread Scott Alexander
I got this working finally. I originally grabbed the wrong patch for DBD::Oracle. The one that I ended up using was at: http:[EMAIL PROTECTED]/msg01291.html Thanks for the pointers on where to find what I needed Tim, and thanks to Gerald Richter for putting the patch together. Scott On

Re: DBD::AnyData Issue - Perl 5.004_4

2002-08-17 Thread Jeff Zucker
[EMAIL PROTECTED] wrote: Hello. I've got a bit of a problem with my app when running on Perl 5.004_04. Basically, I'm using DBD::AnyData to retrieve rows from csv files. Yes, sorry, DBD::AnyData requires perl 5.005 or better. DBD::CSV is still, for the time being, usable with 5.004 so

DBI makes apache fail in perl58.dll

2002-08-17 Thread pascal barbedor
Hi with perl 5.8/ apache 2.0.40 / mod_perl 1.99_05 / DBI 1.30 use DBI in the startup.pl (before child cloning process) script makes apache segfault in perl 58.dll this is on win32 here is the stack trace SharedUserData!SystemCallStub+0x4 ntdll!ZwTerminateProcess+0xc

Re: total row count with SQL 'LIMIT' batching

2002-08-17 Thread Michael Peppler
On Sat, 2002-08-17 at 10:40, Jeff Zucker wrote: A M Thomas wrote: It makes a lot of sense from a user interface point of view to show the web user the _total_ number of records that match the search criteria, and possibly, calculated from that, the number of batches (think Google).