Can Sort be included in a CDML Link?

[ibiubu]

For example:

http://63.226.xxx.xxx/FMPro?-op=equals&-lay=CGI&[email protected]&-error=errors.htm&User=&-find=Submit&-format=Summary.htm&-max=25

This link then lists the records that match the find. I am not sure what criteria it is using for the order they are shown. Is there any way of including a sort by field name in the above CDML to determine the order they are displayed?

LR

[The Bridge]

You can add multiple Sorts to a CDML link like so:

...&-SortField=<Fieldname>&-SortOrder=<SortOrder>&-SortField=<Fieldname2>&-SortOrder=<2ndSortOrder>...

-SortOrder accepts:

Ascend

Descend

Custom=ValueList (where ValueList is the name of the valuelist associated with the -SortField on the layout).

Haven't used the Custom option myself, but have read many reports of problems with it.

The -SortOrder tag is actually optional, but recommended if using multiple -SortField tags. Each -SortOrder must directly follow the -SortField it applies to.

[slstrother]

Yes, a sort can be included in a link.

Use:

-sortfield=field name

-sortorder=ascend or descend

[ibiubu]

Great. I will give it a try. Thanks!!!

[Vaughan]

Have you got a copy of the CDML Reference? It's a FMP database with all the CDML codes with their syntax described and example usage. Download it from the FileMaker Inc web site (in the downlads section I think).

It'll answer all your "can you do XXX in CDML" questions.

[The Bridge]

Quite right, Vaughan.

Y'know, considering the number of times any given question is asked (and answered) on FMForums, perhaps there should be a big banner at the top of each category: Search the Forum First!

Then again, we'd all probably find ourselves wondering why there aren't any new posts...