adding Field names to sort

[bigmalaka]

I took over maintaning the database but have been stuck with one problem. When trying to do a sort using FM online, I dont know how to add field names to the list to choose from. I know how to add items to the "sort order" but not "fields".

[Unable]

A working example of the -sort and -sortfield tags can be found in the Sample Files Forum in the example of "CDML -Op values and Symbols demo". The demo is presented in Pro5, which db files are convertable to Pro6. The format files were handwritten in SimpleText and may have experienced a conversion of some sort through compression. You can drag and drop to NotePad and they will probably open there. Otherwise drag and drop to your browser and View Source to see/copy the code. Lot's of other stuff in the demo as well. Good luck.

It's been a while, but I think there are instructions for use in the thread.

[Steve T.]

Howdy! Here's a clipping from the CDML reference database that may help if you are using Custom Web Publishing...

--ST

Specify sort field using a form action

<form action="FMPro" method="post">

<input type="hidden" name="-DB" value="contacts.fp5">

<input type="hidden" name="-Format" value="format.html">

<input type="hidden" name="-SortField" value="Last Name">

<input type="hidden" name="-SortField" value="First Name">

<input type="submit" name="-FindAll" value="Sort by First Name">

</form>