Results 1 to 6 of 6
  1. 01-07-2012, 10:26 AM #1
    abhi7080
    abhi7080 is offline Member
    Join Date
    Dec 2011
    Location
    india
    Posts
    16
    Rep Power
    0

    Default Not getting 1st record from table.

    I have created a form. From which i can get the records of the users(table name) by using query -" select * from users where acno(account number)=?".
    But the problem is that if a table having 5 records about particular account , it displays only 4 record and not displaying the first record.
    How to solve this?
    Reply With Quote Reply With Quote
  2. 01-07-2012, 11:50 AM #2
    JosAH's Avatar
    JosAH
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    11,375
    Blog Entries
    7
    Rep Power
    17

    Default Re: Not getting 1st record from table.

    Quote Originally Posted by abhi7080 View Post
    How to solve this?
    We don't know without seeing any relevant code. Probably you're calling the ResultSet.next() method one times too many.

    kind regards,

    Jos
    When people rob a bank they get a penalty; when banks rob people they get a bonus.
    Reply With Quote Reply With Quote
  3. 01-10-2012, 08:17 AM #3
    abhi7080
    abhi7080 is offline Member
    Join Date
    Dec 2011
    Location
    india
    Posts
    16
    Rep Power
    0

    Default Re: Not getting 1st record from table.

    Yes! i am using resultset.next() method two timesin a same form to get all the recoreds from table,
    is it wrong?
    Reply With Quote Reply With Quote
  4. 01-10-2012, 08:46 AM #4
    abhi7080
    abhi7080 is offline Member
    Join Date
    Dec 2011
    Location
    india
    Posts
    16
    Rep Power
    0

    Default Re: Not getting 1st record from table.

    I am now using simpledateformate as (dd/MM/yy ) but i want out put as dd-month-yy eg.(1-jan-2012).what would i do to get it?
    Reply With Quote Reply With Quote
  5. 01-10-2012, 10:23 AM #5
    Tolls
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    10,438
    Rep Power
    16

    Default Re: Not getting 1st record from table.

    Look up the API for SimpleDateFormat and read up on the syntax?
    It's all there...
    Reply With Quote Reply With Quote
  6. 01-11-2012, 11:14 AM #6
    abhi7080
    abhi7080 is offline Member
    Join Date
    Dec 2011
    Location
    india
    Posts
    16
    Rep Power
    0

    Default Re: Not getting 1st record from table.

    OK!Thanks.
    Reply With Quote Reply With Quote
« Nullpointer accessing public int | Could not find the main class: java. Program will exit »

Similar Threads

  1. How can I read a binary file record by record in java?
    By ZigVe in forum New To Java
    Replies: 9
    Last Post: 07-09-2011, 07:15 PM
  2. MouseClick in table of Search and To see previes record
    By Zuraima in forum Java Software
    Replies: 2
    Last Post: 08-10-2010, 08:03 AM
  3. How to edit/delete a record in a csv table with JavaCsv?
    By fogus in forum New To Java
    Replies: 3
    Last Post: 03-26-2009, 07:35 AM
  4. How to get whole record of a table into a java List
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 04-01-2008, 10:43 AM
  5. How to get whole record of a table into a Java List
    By JavaBean in forum Java Tip
    Replies: 0
    Last Post: 09-28-2007, 01:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules