Need help with Query

Results 1 to 2 of 2

Thread: Need help with Query

  1. #1
    Bill Young Productions Guest

    Default Need help with Query

    Hello!<BR><BR>We are currently working on the George Strait Country Music Festival website and we need a question answered if possible. On our tour dates section, we have an "on sale" section. Whenever that "on_sale" date rolls around, I want the text to display "On Sale" instead of TBA. <BR><BR>How would I go about doing this?<BR><BR>Thanks!<BR><BR>Jeremy Botter<BR>Bill Young Productions

  2. #2
    Join Date
    Dec 1969

    Default RE: Need help with Query

    Let&#039s assume the recordset is named "rs".<BR><BR>&#060;%if rs("on_sale") &#062;= Date() then<BR> response.write("On Sale")<BR>else<BR> response.write("TBA")<BR>end if%&#062;<BR><BR>That assumes, of course, that "on_sale" is a date field. Otherwise, you might need to use the cDate() function.

Posting Permissions

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