[ic] Group By
Barry Treahy, Jr.
interchange-users@icdevgroup.org
Tue Sep 24 12:02:01 2002
Barbara Picci wrote:
> Hi,
> I have put mv_sort_field in the results form but the result is the same.
> I red that, if specifying a sort for the product database,
> mv_field_names must be specified.
> So now my form is:
>
> <FORM ACTION="[area search]" method="post">
> <INPUT TYPE=hidden NAME=mv_search_page VALUE=results1>
> <INPUT TYPE=hidden NAME=mv_matchlimit VALUE="10">
> <INPUT TYPE=hidden NAME=mv_search_map VALUE="
> mv_searchspec=search1
> mv_searchspec=search2
> ">
> <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="color">
> <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="owner">
> <INPUT TYPE="hidden" NAME="mv_field_names" VALUE="14">
> <INPUT TYPE="hidden" NAME="mv_field_names" VALUE="15">
> <INPUT TYPE="hidden" NAME="mv_sort_field" VALUE="color">
> <INPUT TYPE="hidden" NAME="mv_sort_field" VALUE="owner">
The sort field isn't part of the coordinated list, you only have one
mv_sort_field which lists the fields that the columns are to sort on...
I can't say for sure, but my guess is that IC took the last value,
owner, which messed up the sort order again...
Barry
--
Barry Treahy, Jr * Midwest Microwave * Vice President & CIO
E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028