May 9, 2003 at 5:06 am
Hi everyone!
I'm building ASP pages where there will be displayed information brought -- in a looping process -- from SQL Server databases - for each "turn" of the loop, there will be "titles" before each kind of info: for instance:
Response.write "Your fax number: " & <objRS("faxnr")>
... but sometimes, some fields of a record may NOT contain any data, or a NULL (if those information are not "required").
So, the problem is specifically this: in this case, the "title" will appear ...followed by nothing!!!?!?...
Then I ask You gurus:
- HOW can I force that piece of text (what a called "title") NOT to appear, not to be displayed-IF-its correspondent field is empty, or NULL?
I'd like to thank You in advance, for your attention.
Dalton Gilson, Rio
May 9, 2003 at 6:10 am
use an if statement to determine whether the field is not null or not empty:
if !isNull(objRS("faxnr")) or objRS("faxnr") > "" then
Response.write "Your fax number: " & <objRS("faxnr")>
end if
NB Have not checked the sytax but I trust you get the idea.
Jeremy
May 9, 2003 at 9:17 am
Jeremy
1. unfortunately, it did not accept the "!" before "isNull"!
2. On the other hand, trying -without- the "!", it rejected the "<" and the ">" around the "objRS("faxnr")" expression at the "then" option (but this wouldn't be -The- problem).
I really did not "get the idea" of WHY the system rejected it...
Sincerely yours
Dalton
May 12, 2003 at 1:42 am
Dalton,
Try this:
if not isNull(objRS("faxnr")) and objRS("faxnr") <> "" then
Response.write "Your fax number: " & objRS("faxnr")
end if
Jeremy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy