(This answer from a newby - so beware)
I found that any of the columns used in the group by clause worked just
the same as a regular search action, but any of the sum columns couldn't
be called from my resultset - likely the result of a change to the
column name. I couldn't figure out how the column was named, so I just
converted my search action to a direct dbms action where I could specify
the name of my column myself, like this:
sum(tablename.columnname) as columnname
Then I was able to use the column from the resultset in my results
html
I hope this helps.
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 05/14/02 07:36AM >>>
I have gone through the documentation and cannot find how to return
the
results after performing a search action with a select type of
"Summaries of
Groups" or "Summary of All Rows". Will someone please point me in the
right
direction.
Thanks.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body