Results 1 to 2 of 2

Thread: how to change text on web automatically from reading a SQL server?

  1. #1
    Join Date
    Jun 2004
    Posts
    2

    how to change text on web automatically from reading a SQL server?

    A section of this company's intranet site where I just started interning at has little company anniversary and birthday sections that look like (for the anniversary section.. in the birthday section, it looks the same, except it doesn't say how old the comployee is):

    -Steve Cunningham 6/1 - 6 yrs
    -Andrew Brown 6/3 - 11yrs
    -Lisa Stone 6/4 - 3 yrs

    How can I get it so instead of manually changing that text every month, it will look at a SQL database and automatically change that text every month? I'm guessing the pseudocode would be if the b-day or anniv. month matches the current month, display the first and last name, the date, and number of years (which would have to be calculated maybe?) Any help would be GREAT! Thanks!!

    ~Michael

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. If you want the whole website as database driven website then you can create ASP page or asp.net

    www.asp101.com
    www.asp.net

    2. If you just want only that anniversary page to be updated every month or day then look in to BOL for
    sp_makewebtask

Posting Permissions

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