Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Results to Detail Page Not Working Consistently

Results to Detail Page Not Working Consistently

Thread began 10/02/2010 1:10 pm by debbie295402 | Last modified 10/04/2010 11:19 am by debbie295402 | 1509 views | 3 replies

10/04/2010 11:19 amJason ByrnesWebAssist

this is most likely an issue with the INNER JOIN.
For the inner join to return a result, the join criteria must have a match.

If the join does not find a match, no results will be returned regardless of a match with the where clause.

You may want to try experimenting with using a left join, or an outer join instead of inner join.

for details on the types of joins see the following :
Join_%28SQL%29

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.