Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › COUNT(*) Function

COUNT(*) Function

Thread began 9/03/2015 2:19 am by salaroche | Last modified 10/05/2015 11:31 am by salaroche | 2658 views | 21 replies

9/03/2015 6:18 pmsalaroche

Hi:

I appreciate the solutions presented by Nathon, however, I would still have the problem of how to display the results from two different recordsets in one single results page.

The operation I’m trying to implement involves the following: 1) SELECT records that have a set of characteristics “A” and perform an operation with them and 2) SELECT records that have a set of characteristics “B” and perform a DIFFERENT operation with them. NOTE: the latter operation ("B") involves the results of a COUNT() function. Finally, display BOTH sets of records in ONE single display table using a REPEATED REGION.

Maybe the way out would be to use an IF statement, which in sql/php language seems to be the equivalent of CASE. But even in this case I would still need to use the COUNT() function with a WHERE clause.

Any suggestions on this?

Thank you for your attention.

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.