I'm trying to sort on two different fields but am getting a mixture of data. Am I using the right syntax if I want the -SortField to sort on title first and then content_area second?

"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title+content_area&-SortOrder=ascend&-Max=all&-Find"

Thanks for the input.

Kent

[ January 02, 2002: Message edited by: Kent Turansky ]

This should be:

"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title&-SortField=content_area&-SortOrder=ascend&-Max=all&-Find"

That is, use a -sortfield for each field being sorted, and in the order of the sort dominance.

All the best.

Garry

Ok I understand that but now it creates a new problem. I get a warning that No Records Found?

When I take SortField=title& out it list everything by content_area or if I take SortField=content_area& out it lists everything by title so I'm not sure what I am still doing wrong? I have plenty of records but just cannot sort by both.

Thanks for the input

"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title&-SortField=content_area&-SortOrder=ascend&-Max=all&-Find"

Each -SortField tag must be followed by a -SortOrder tag. Two -SortFields, two -SortOrders.

Hope this helps!

I'm still getting an error when I put the extra SortField and Sort Order. Does this look right?

Kent

"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title&-SortField=content_area&-SortOrder=ascend&-SortOrder=ascend&-Max=all&-Find"

quote:

---

Originally posted by Kent Turansky:

[QB]"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title&-SortField=content_area&-SortOrder=ascend&-SortOrder=ascend&-Max=all&-Find"[/QB ]

---

Close, but this is what I meant:

"http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_events.fp5&-Format=scoe/admindelete.html&-SortField=title&-SortOrder=ascend&-SortField=content_area&-SortOrder=ascend&-Max=all&-Find"

[ January 04, 2002: Message edited by: The Bridge ]

Worked like a charm and now I understand this! Thank you

Kent

Glad I could help!