Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Can the Search function do this?

Can the Search function do this?

Thread began 4/09/2012 10:06 pm by eric284736 | Last modified 4/27/2012 7:00 pm by eric284736 | 3696 views | 14 replies

4/15/2012 5:53 pmeric284736

thanks Jason!

I am going to post issues as I run into them, if that is okay.

On my results page I have my recordset defined and I have 1 WHERE clause set (DisplayOnSite = '1').

Can I add another WHERE clause directly in the recordset and not affect the search behavior? I ask because I have a field named Country in the Properties table and in the Area table there is also a Country field which is giving me the response:

Column 'Country' in where clause is ambiguous

How should I define which table column, in the Search Behavior Where clause or in the recordset?

thx
Eric

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.