[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