« Previous Next »

Thread: how to maintain a status...asp ...

Last post 01-05-2009 8:43 AM by tomkmvp. 1 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (2 items)

Sort Posts:

  • 01-03-2009, 6:19 AM

    • mathews7
    • Not Ranked
    • Joined on 01-03-2009, 11:18 AM
    • Posts 4

    how to maintain a status...asp ...

    I have two table in db,namely 1.nametable name_id name id 2.statustable aut_id status name_id i loaded a page with name records for single user(which is id from nametable), now i want to maintain a status for the particular name , for that i created a table which is statustable to attain status i created a two buttons ..namely hide,show button... Clear clarity..... on clicking hide... status should be stored as zero in staustable along with that name_id(of nametable) to be stored.. on clicking show...status should be stored as zero in staustable along with that name_id(of nametable) to be stored Do i need two function to attain dis..?plz suggest how can i proceed....! . .
    Name : "&ors(1)&"
      
    ") oRs.MoveNext() Wend end if %>
  • 01-05-2009, 8:43 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 10:27 AM
    • Central NJ
    • Posts 6,189
    • IIS MVPs

    Re: how to maintain a status...asp ...

    I would use one button that defaults to "Hide". 

    <input type="submit" value="Hide" name="btnStatus" /> 

    When it's clicked, the form submits and your ASP code checks the value - if the value equals Hide then have the ASP run some SQL to update the table to status 0 (and then write out the button with a "Show" value), else update the table status to 1 (and then write out the button with a "Hide" value again).

Page 1 of 1 (2 items)
Microsoft Communities