I have two feature requests:
1. We have always been able to dynamically specify a sort field using
an argument or variable. However, we have never been able to dynamically
specify the sort direction (ie. ascending or descending). I request that
the sort direction can be set up in a similar way as the operator in the
criteria of a search action. This has been a frustrating limitation for
a long time. I've had to either resort to using a directDBMS or create
multiple versions of the search actions for each sorting variation.
2. Sub-looping within a resultset.
One really nice feature in ColdFusion is the ability to have sub-loops
within a result set grouped by a specified field. You can also go many
levels deep this way. It would look something like this:
<@rows groupby="<@COLUMN My_Table.My_Field'>">
.
.
.
<@rows>
.
.
.
.
</@rows>
.
.
</@rows>
The idea here is that the looping construct would keep track of
when the field value changes for you. The inner loop would keep
going as long as the value stayed the same. This would make writing
reports so much easier and is something that I have to do a lot in
my applications. This would be a big programming time saver. Remember
that you can also have sub-sub-loops grouping by different fields
each time.
Thanks,
Stefan
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
