Results 1 to 3 of 3
  1. #1
    sireesha264 is offline Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0

    Default Problem with applying Sql order by to html table

    Hi to all,

    I am having a web page,I want to apply sql order by command to html table.

    TestCase_asc=select * from mytable order by testcase asc;
    TestCase_desc=select * from my tableorder by testcase desc;
    user_asc=select * from mytable order by user asc;
    user_desc=select * from my tableorder by user desc;


    My html table:

    TestCase User
    test1 ANTONY
    Count ZXc
    Compare ABC

    When user clicks on fields,Records should sort by calling above sql commands.
    Any one please give me the code for this.

    Thanks in advance

  2. #2
    jelly's Avatar
    jelly is offline Member
    Join Date
    Jan 2008
    Location
    Somerset, UK
    Posts
    46
    Rep Power
    0

    Default

    Do you already have code to create the table, if so post it and then people can start to explain how you would change what you have
    -- Hope that helps

  3. #3
    sireesha264 is offline Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0

    Default

    My table is as follows,Pease any body give me the idea.
    <table>
    <tbody>
    <tr>
    <th>TestCase</td>
    <th>User</td>

    </tr>
    <tr>
    <td>test1</td>
    <td>ANTONY</td>
    </tr>
    <tr>
    <td>Count</td>
    <td>ZXc</td>
    </tr>
    <tr>
    <td>Compare</td>
    <td>ABC</td>
    </tr>
    </tbody>
    </table>

    Thanks in advance.

Similar Threads

  1. Replies: 0
    Last Post: 03-29-2008, 03:36 PM
  2. Generate Excel Report from a HTML table
    By Sudha in forum New To Java
    Replies: 0
    Last Post: 02-13-2008, 08:24 PM
  3. Problem with sorting Table
    By sireesha264 in forum Advanced Java
    Replies: 0
    Last Post: 02-08-2008, 02:21 PM
  4. Showing ResultSet in HTML table
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-27-2008, 08:09 PM
  5. Problem with '/' character in HTML and JSP
    By Marcus in forum JavaServer Pages (JSP) and JSTL
    Replies: 2
    Last Post: 07-04-2007, 05:32 AM

Posting Permissions

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