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 advanceTry If {variable} = "" instead of IsEmpty. There is a difference. If you initialized the variable, it would not be empty or null.that doesn't even look like ASP (or C#) to me
which language is that exactly??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*/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
{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 advanceTry If {variable} = "" instead of IsEmpty. There is a difference. If you initialized the variable, it would not be empty or null.that doesn't even look like ASP (or C#) to me
which language is that exactly??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*/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