Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search Results getting messed up with INNER JOIN

Search Results getting messed up with INNER JOIN

Thread began 7/01/2009 9:12 pm by terencepjf260961 | Last modified 10/14/2009 7:28 am by terencepjf260961 | 2997 views | 6 replies

7/02/2009 7:17 amRay BorduinWebAssist

1) Probably because those column names you are filtering with aren't unique in the query. Try updating the code by hand to use contactinStores.centerid and contactinStores.contactid and it will probably fix that problem.

2) it isn't a checkbox now... You may have adjusted the page so I'm not sure if you are still having issues with this portion.

3) this should be the default functionality. I think you aren't getting all the results because of your last select field not having the correct option value for the first option:

<select name="S_defaultstore" id="S_defaultstore">
            <option selected="selected">All</option>

should be:

<select name="S_defaultstore" id="S_defaultstore">
            <option value="" selected="selected">All</option>

Did this help? Tips are appreciated...

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.