April 30, 200223 yr 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
April 30, 200223 yr 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.
April 30, 200223 yr Yes, a sort can be included in a link. Use: -sortfield=field name -sortorder=ascend or descend
April 30, 200223 yr 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.
April 30, 200223 yr 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...
Create an account or sign in to comment