|
Posted by ccc31807 on March 27, 2008, 9:04 am
Please log in for more thread options
On Mar 27, 1:55 am, "robertchen...@gmail.com"
> hi, please help me on:
>
> I want to find like 1000+ records from Oracle database using dbi, but
> the view could sort by column and could display by multi pages.
>
> Anyone has this kind of experience?
>
> Robert
This may actually be an SQL issue. If you are using DBI, you can write
your select statement as follows:
select f1, f2, f3, f4 [etc] from tablename where f1 = 'value' order by
columnname
When you get your statement handler, you can create a while loop and a
counter that will insert a break of an appropriate type when the
counter reaches your parameter and will reset the counter.
CC
| 
XML Sitemap