There is a basic flaw to the SQL that may be giving you fits: You are doing an "AND"
search, not an "OR".
In and "AND" search, all three conditions (in your case) have to return "true" (with a
match) for results.
In an "OR" search, only one of the three conditions (again, your example) have to
return true to give results.
Posters on this thread are on the right track, showing you how to narrow the search
based on field(s) that are non-null.
One warning: TRIM all field in the query (i.e. "where orgname LIKE
UPPER('%#TRIM(Form.orgname)#%'). That way, blank space will not be considered a search
parameter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
