RE: DBI Perl and rows...

2001-08-08 Thread Bob Showalter
> -Original Message- > From: Daniel Falkenberg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 07, 2001 7:58 PM > To: Beginners (E-mail) > Subject: DBI Perl and rows... > > > List, > > I have the following code here > > my $sth

RE: DBI Perl and rows... - another possibility

2001-08-07 Thread Steve Howard
sage- From: Michael Fowler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:08 PM To: Daniel Falkenberg Cc: Beginners (E-mail) Subject: Re: DBI Perl and rows... On Wed, Aug 08, 2001 at 09:27:34AM +0930, Daniel Falkenberg wrote: > Now what I really want to be able to do is only displ

Re: DBI Perl and rows...

2001-08-07 Thread Michael Fowler
On Wed, Aug 08, 2001 at 09:27:34AM +0930, Daniel Falkenberg wrote: > Now what I really want to be able to do is only display 10 of the rows in > the database then create a hyperlink to to the next 10 and so on. Pass along an offset with each request, and structure your SQL query to use this offse

RE: DBI Perl and rows...

2001-08-07 Thread Steve Howard
nberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 6:58 PM To: Beginners (E-mail) Subject: DBI Perl and rows... List, I have the following code here my $sth = $dbh ->prepare( qq{ SELECT * FROM table_name WHERE sta

DBI Perl and rows...

2001-08-07 Thread Daniel Falkenberg
List, I have the following code here my $sth = $dbh ->prepare( qq{ SELECT * FROM table_name WHERE status <> 'DELETED' AND status <> 'COMPLETE' ORDER BY status } ) ||