Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    13
    Rep Power
    0

    Default how to display the alerts in table

    This is my table

    Sno Close1 avg

    1 150 110
    2 210 175
    3 110 150

    its my table structure
    i am comparing the close1 values with avg values
    that is if close1>avg i want to display the message like "Good"
    if close1<avg i want diplay the the message like"bad"

    my final structure is

    Sno Close1 avg result

    1 150 110 bad
    2 210 175 bad
    3 110 150 good


    how to write the qery for above table

    if any body have idea please tell how to display the messages in table

  2. #2
    sanjeevtarar's Avatar
    sanjeevtarar is offline Senior Member
    Join Date
    Apr 2008
    Location
    Jaipur(India)
    Posts
    318
    Rep Power
    7

    Default need SQL query or something else

    Hello Geeta

    do u need a SQL query to update the data in db or something else.?

  3. #3
    Join Date
    Mar 2008
    Posts
    13
    Rep Power
    0

    Default

    i want message(good/bad) when the codition is satisfied/not satisfied in the table or i want alert it(good/bad) depends on te codition

  4. #4
    DonCash's Avatar
    DonCash is offline Moderator
    Join Date
    Aug 2007
    Location
    London, UK
    Posts
    240
    Rep Power
    9

    Default

    Hello Geeta,

    I understand the bit about the good/bad message but are you looking for a SQL query to do this or are you looking to do this in Java?

    Do you currently have any code extracting this data from the database?
    Did this post help you? Please me! :cool:

  5. #5
    Join Date
    Mar 2008
    Posts
    13
    Rep Power
    0

    Default

    I want the sql query to display the good/bad when the condtion is satisfied/not satified
    any idea

Similar Threads

  1. Replies: 4
    Last Post: 01-05-2008, 07:39 PM
  2. AWT Table Scrolling
    By albert_kam in forum AWT / Swing
    Replies: 0
    Last Post: 01-03-2008, 11:37 AM
  3. Data formatting for the <display:table>
    By yuchuang in forum Web Frameworks
    Replies: 3
    Last Post: 12-14-2007, 10:52 AM
  4. regarding to creating table.....
    By daredavil82 in forum New To Java
    Replies: 0
    Last Post: 11-18-2007, 04:55 AM
  5. Table Help
    By CoOlbOyCoOl in forum NetBeans
    Replies: 1
    Last Post: 05-06-2007, 04:19 PM

Posting Permissions

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