Was wondering if someone can help me with my SQL statements. I am trying to replicate the search interface that appears on this site http://www.nzbizbuysell.co.nz/
using dreamweavermx and coldfusion mx.
Ive created a form containing three seperate menus and use the followeing sql statement
WHERE Region LIKE '#FORM.regionMenu#' OR Business_Type
OR Asking LIKE '#FORM.askingMenu#'
This works fine until I want to generate a search that combines two of the menus. For example, a wildcard search using one menu (giving 20 results) and another menu (giving 4 results) would give me 20 results rather than 4 results from the 20.
Any suggestions would be appreciated.