A single search box for all DB columns
Is there a way with data assist to create a single search box that searches all columns within a database table, rather than one form element per column (as data assist currently produces for me)?
Thanks.
Mat
Is there a way with data assist to create a single search box that searches all columns within a database table, rather than one form element per column (as data assist currently produces for me)?
Thanks.
Mat
Yes but it is really only useful for text based searches.
Create a text box called for the sake of argument zoom_query and in the wizard your first selection will use the "AND" operator as standard but every subsequent selection should use the "OR" operator see attached screenshots
I have used this technique successfully on a number of sites even combining it with a normal DA type search in admin panels with a little hand coding
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.