Alias a field in SELECT

[Nathan Friesen]

> the Aggregate Function COUNT in SELECT , when used with GROUP BY,
> produces output field name ... COUNT ... in a list.
>
> Director Lists also have function named COUNT.
>
> So when I go ResultList[1].Count ... expecting the aggregate COUNT,
> I get the count of items ... not the value returned ..

If I follow you right, you're getting a property list, and one of the 
items in the list is #Count. If that's the case, I think you can get the 
value from the database with ResultList[1][#Count]


Nathan Friesen
Dyton, Inc.
2302 West 1st Street
Cedar Falls, IA 50613
P: 319.277.8418
F: 319.277.8417

www.dyton.com


------
    Where there is no vision, the people perish.
      - Proverbs
------