I am displaying a query with fields address1 and address2. I only want address2 to display if there is data in the database. The problem is my <cfif #trim(address2)# NEQ ""><br></cfif> isn't catching everything. When I look in the database their is nothing in the field. Less than 1% of the...
search screen query logic CFIF
I am building a search screen and the search items are
COUNTY, CITY, ZIP, NAME. I would like to be able to
search on each item independent of the other and I
would like to be able to search on the COUNTY and CITY
using AND.
I have two select boxes populated by the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.