Re: pagination of dbi results on html browser

2003-11-20 Thread A L
I just want to say thank you to everyone with their help and support. Now, I'm returning to my programming. I'll come back when I have results. Angela - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Re: pagination of dbi results on html browser

2003-11-19 Thread
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (R. Joseph Newton) writes: >Jeff 'japhy' Pinyan wrote: > >> >> The way I've done this is: >> >> use DBI; >> use CGI 'param'; >> >> my $dbh = DBI->connect($dsn, $username, $password, { RaiseError => 1 }); >> my $offset = param('offset') || 0

Re: pagination of dbi results on html browser

2003-11-19 Thread James Edward Gray II
On Nov 18, 2003, at 6:12 AM, A L wrote: ###My background... Well, I had my first encounter with Perl in the Fall of 2000. It was not pretty. Ironically, this was pretty much how my first experience with Perl went, years ago now. I swore I would never touch that crazy "rules for the exception

RE: pagination of dbi results on html browser

2003-11-19 Thread Dan Muey
> Thank you for your insights and suggestions. Somethings that > you have mentioned, such as my approach to problem solving, > had been resolved. Hence, my resolution to master Perl is > stronger than before. Obviously, there are plenty of things > that I have to work on, but I'm hoping my p

Re: pagination of dbi results on html browser

2003-11-19 Thread A L
Thank you for your insights and suggestions. Somethings that you have mentioned, such as my approach to problem solving, had been resolved. Hence, my resolution to master Perl is stronger than before. Obviously, there are plenty of things that I have to work on, but I'm hoping my persistence

Re: pagination of dbi results on html browser

2003-11-18 Thread R. Joseph Newton
A L wrote: > Joseph > ###My background... Well, I had my first encounter with > Perl in the Fall of 2000. It was not pretty. At the > time, my only programming experience was Pascal taken as a > high school student. However, I really wanted to learn > programming better, and was told that Perl

Re: pagination of dbi results on html browser

2003-11-18 Thread A L
"R. Joseph Newton" <[EMAIL PROTECTED]> wrote: A L wrote: > Hi Everyone at [EMAIL PROTECTED], > Threre are two main questions: > 1. How can I get to make results from mysql db to be displayed on web browser with > pagination? Meaning, when there are too many results from the db, it only displays

Re: pagination of dbi results on html browser

2003-11-18 Thread R. Joseph Newton
Jeff 'japhy' Pinyan wrote: > > The way I've done this is: > > use DBI; > use CGI 'param'; > > my $dbh = DBI->connect($dsn, $username, $password, { RaiseError => 1 }); > my $offset = param('offset') || 0; > my $limit = 10; > my ($prev, $next) = ($offset - $limit, $offset + $limit); >

Re: pagination of dbi results on html browser

2003-11-18 Thread Hacksaw
> A L wrote: > >> 1. How can I get to make results from mysql db to be displayed on web > Try this: > > Save the whole result set to a local temp file. You'll need a routine for > Read the file twenty or so lines at a time, doing nothing but getting the A simpler answer is to use the LIMIT

Re: pagination of dbi results on html browser

2003-11-18 Thread R. Joseph Newton
A L wrote: > Hi Everyone at [EMAIL PROTECTED], > Threre are two main questions: > 1. How can I get to make results from mysql db to be displayed on web browser with > pagination? Meaning, when there are too many results from the db, it only displays > 20 results at a time-like that of google-an

Re: pagination of dbi results on html browser

2003-11-17 Thread A L
Thanks so much for all your help! I'll look into it and let you how things turn out. Angela - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Re: pagination of dbi results on html browser

2003-11-17 Thread Jeff 'japhy' Pinyan
On Nov 17, A L said: >1. How can I get to make results from mysql db to be displayed on web >browser with pagination? Meaning, when there are too many results from >the db, it only displays 20 results at a time-like that of google-and >show links to rest of the results by giving page numbers. I'

RE: pagination of dbi results on html browser

2003-11-17 Thread Guay Jean-Sébastien
Hello A L, > When I search for this on the web, most of them give javascript results. I would like > to use Perl. Is it possible to do this with Perl? Why would you want to do something like that in Perl? When you click a button on a web form, the only time you want to call a server-side script

Re: pagination of dbi results on html browser

2003-11-17 Thread Casey West
It was Monday, November 17, 2003 when A L took the soap box, saying: : Hi Everyone at [EMAIL PROTECTED], Threre are two main questions: : 1. How can I get to make results from mysql db to be displayed on web :browser with pagination? Meaning, when there are too many results :from the db, it