Re: How to Display text in empty fields
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12301
interpreted = N
texte = >I have a question I was hoping one of you might be able to answer... We>have a database that is comprised of information from different companies,>the fields are: name, url, email, phone, fax, and description. Now, not>all records make use of all the fields, for example a record for a company>might have phone, fax and email, but no URL, while another one might have>a URL and email but no phone or fax. Now the fields that don't contain any>info, are simply blank. Now here's my question, I need to format my>results page to deal with this problem. I need to either insert N/A>automatically for the empty fields, or have them simply be>ignored(i.e.leave no empty space). Does anybody have any suggestions?Blank fields are ignored automatically if they are empty.Use [field][showif [field]=]N/A[/showif] instead of just [field] whereveryou want to display N/A in place of an empty field value ... :)Sincerely, Ken GromeWebDNA Solutions
Associated Messages, from the most recent to the oldest:
>I have a question I was hoping one of you might be able to answer... We>have a database that is comprised of information from different companies,>the fields are: name, url, email, phone, fax, and description. Now, not>all records make use of all the fields, for example a record for a company>might have phone, fax and email, but no URL, while another one might have>a URL and email but no phone or fax. Now the fields that don't contain any>info, are simply blank. Now here's my question, I need to format my>results page to deal with this problem. I need to either insert N/A>automatically for the empty fields, or have them simply be>ignored(i.e.leave no empty space). Does anybody have any suggestions?Blank fields are ignored automatically if they are empty.Use [field][showif [field]=]N/A[/showif] instead of just [field] whereveryou want to display N/A in place of an empty field value ... :)Sincerely, Ken GromeWebDNA Solutions
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebDNA-Talk Digest mode broken (1997)
Undeliverable Mail (1997)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
Appending space (1998)
shipcost - fed up with the old way (1998)
WebCatalog for Dummies part 2 (2000)
WebCatalog for guestbook ? (1997)
Bit off subject -- Faxing orders (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
WebCatalog f2 Installation (1997)
WebCat2b13MacPlugIn - [include] (1997)
shipcost (1997)
Email (1998)
[WebDNA] XML Syntax (2012)
MATH (1998)
[ConvertChars] problem (1997)
Popup Calendar Code (2003)
Site Search Suggestions (2004)
How can I record purchases to a database? (1998)
version 2 for NT (1997)