Searching - Blanks Searching - Finding Blank Fields FieldNameblnk=T
Searches for blank fields.

If visitors leave a field blank in a search form, WebDNA normally assumes they do not "care" to search that field -- it acts as though the field was not specified in the search criteria at all. If you want to search for blanks (no text in the field whatsoever, not even a space), you can override this behavior.

If your database has a field called "Title", and you want to look for records that have nothing in the Title field, then you would enter a URL something like this:

http://Results.tpl?command=search&eqTitledata=[blank]&db=SomeDatabase.db

Alternately, you can use the form FieldNameBLNK=T, which makes it possible to use radio buttons or checkboxes to let the visitor decide how they want to search for blank fields. If you want to apply this to all the fields in your search at once, then set allBLNK=T.

The template "Results.tpl" display after the search, and any [FoundItems] contexts in it filled with found records. "eq" stands for "equals," meaning that the Title field must equal blank exactly, otherwise it will not be considered a match. "eq" is one of many different ways to compare data in your database -- see Comparisons for a complete list of all the different ways to compare fields.

User Contributed Notes
SearchBlanks  

Copyright © 2008 WebDNA Software Corporation, Inc.