Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Oct 2004
    Location
    Athens, Greece
    Posts
    40
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Arrow Need help with recordset dispaying

    I have the following dynamic text:
    {rs_air_description.day_one}
    {rs_air_description.day_one_desc}

    {rs_air_description.day_two}
    {rs_air_description.day_two_desc}

    {rs_air_description.day_three}
    {rs_air_description.day_three_desc}

    {rs_air_description.day_four}
    {rs_air_description.day_four_desc}


    How am I going to remove the blank gap that is created when the recordset for one or more of the above is empty? I tried Show If recordset is not Empty but it didn't help. You see, the days reach up to 15 and when it comes for a 4 days description, my gap is going huge!
    Thanks in advance

  • #2
    Senior Coder
    Join Date
    Apr 2003
    Location
    England
    Posts
    1,192
    Thanks
    5
    Thanked 13 Times in 13 Posts
    i dont really know what you are asking.. you have a different recordset for every day or something? if so i dont think its needed but i dont REALLY know what you are on about

    if you can be a bit more specfic someone may give an answer sooner

  • #3
    New Coder
    Join Date
    Oct 2004
    Location
    Athens, Greece
    Posts
    40
    Thanks
    1
    Thanked 0 Times in 0 Posts
    No, I am building a travel site and that page shows each tour's programme from day one to day whatsoever.
    First day that, second day that, etc.
    However, when I have a 15day long day it is ok. But when it comes for a shorter tour (less days) all that empty fields dispay a blank gap. Please take a look at this page http://www.signature.gr/ek_tours.asp?id=90
    At the bottom of the yellow text, it is day 6. This tour has only six days, it displays six days and it stays right there, and there is no gap between itself and the text that comes after.

  • #4
    Senior Coder
    Join Date
    Apr 2003
    Location
    England
    Posts
    1,192
    Thanks
    5
    Thanked 13 Times in 13 Posts
    ermmm i spose you could just have each day include the <br>s so althoguh its displaying the last ones, they just appear as "" instead of "<br> <br> <br>"

    if they were all in one table (eg 1 table with a unique id, and details of 15 days in their own separate fields) then you could just get that tour id and write each of the days untill rsTour("day" & i) = ""

  • #5
    Regular Coder
    Join Date
    Aug 2002
    Location
    USA
    Posts
    478
    Thanks
    0
    Thanked 2 Times in 2 Posts
    And/or perhaps something like this.

    If IsNull(rs_air_description.day_one) Or (rs_air_description.day_one = "") Then
    {rs_air_description.day_one}
    {rs_air_description.day_one_desc}
    End If
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips


  •  

    Posting Permissions

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