We want to use DSP pages to display statistics for transactions flowing through our system. We don’t seem to get any results back from the dsp page when we use an Oracle query with a COUNT(*).
Example:
SELECT COUNT(*) TOTCNT
FROM WA_FLAGS
WHERE DATE = ‘vardate’
When I execute the service that contains the flow execSQL from within wM Developer, the Results page displays a record list called “results” that contains one record “results[0]” with one entry named “TOTCNT” that has a value of “3”.
When I run this in a dsp page, I get back a result of “Total Trans = 0”
dsp code looks like this:
%loop results%
Total Trans = %value TOTCNT%
%endloop%
I’ve tried coding it every which way, but can’t get dsp page to display the actual COUNT(*) value
returned.
Any suggestions?
Thanks!