#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    : thru java servlets, i want to display nearly 100 records. in the first page it has first 10 records, next page has next 10 records and so on.. page: 1 2 3 4 5 6 7 8 9 10 (page no) when i select 1, it will show 1st page of first 10 records,if i select 2 it will show 2nd page of records 11 to records 20 ... and so on.....

    my back end is: my sql
  2. #2
  3. Wiking
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Sep 2000
    Location
    Sweden
    Posts
    3,608
    Rep Power
    27
    Why not use php instead?
    Check out http://www.phpbuilder.com/columns/rod20000221.php3
    It worked fine for me - thanx Rod!

    / NoXcuz



    [This message has been edited by NoXcuz (edited September 26, 2000).]
  4. #3
  5. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Ashok,

    Take a look at Rod's example in php.implement same logic in sevlets..it is very easy..
    first you have to find out total record for dispaly...

    then pass the parameters to offset and limit in your mysql select statement..


    it may be something like:

    --------------

    Resultset ss;
    offset=0;
    limit=10;

    ss=con.executeQuery("SELECT * FROM tblname WHERE someconditions LIMIT"+offset+","+limit);
    -----------------

    Also post this question in Servlets forum here in Devshed..




    ------------------
    SR -
    webshiju.com
    www.jobxyz.com-IT Career Portal
    ezipindia.com--WebStudio


    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Upgrade from access to mysql
    By karib1 in forum ASP Programming
    Replies: 7
    Last Post: December 16th, 2003, 12:35 PM
  3. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM
  4. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo