Need help with recordset dispaying

[martha.a]

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

[longcall911]

Try If {variable} = "" instead of IsEmpty. There is a difference. If you initialized the variable, it would not be empty or null.

[putts]

that doesn't even look like ASP (or C#) to me :P

which language is that exactly??

[longcall911]

VBscript:

If Not myvariable = "" Then response.write(myvariable)

I assume there is a .net equivalent. Point is, try testing the condition against a zero length string instead of empty, or null.

/*tom*/

[putts]

Originally posted by longcall911
VBscript:

If Not myvariable = "" Then response.write(myvariable)

I assume there is a .net equivalent. Point is, try testing the condition against a zero length string instead of empty, or null.

/*tom*/

it sorta depends on the data itself.

If you're dealing with a column in a table that allows nulls then comparing a null value versus "" could result in an error.

here's what I use in VBScript when I want to only do something when the value is not empty and it could be a null value....

'isNotEmpty - verifies that the input string is not either empty or null
Function isNotEmpty(string_IN)
if not(isNull(string_IN)) and not(isEmpty(string_IN)) then
if trim(cstr(string_IN)) <> "" then
isNotEmpty = true
else
isNotEmpty = false
end if
else
isNotEmpty = false
end if
End Function