rss_unlimited_categories: sorting on Custom Field Numeric Data

progre55 · 2007-01-04 06:04:28

I have a list that is set to sort by a custom field.

The data in the custom field is prices.

I am running into trouble because although the sort is working correctly, it places the entry $3,250,000 on top of the entry $525,000.

This is the code I am using to work the sort:

If someone could guide me on how I can get it to look at the whole number rather than the first digit I would appreciate it.

Thanks in advance.

progre55

(Edit: updated thread subject to something a little more clear. -Mary)

Last edited by Mary (2007-01-04 19:15:52)

wet · 2007-01-04 07:27:14

Though I haven’t looked at the code this particular plugin uses to achieve sorting, you might succed with this:

<txp:rss_unlimited_categories_article_list section="listing" form="archive_posts" sortby="cast (custom_8 as unsigned)" sortdir="asc" />

Last edited by wet (2007-01-04 07:31:25)

progre55 · 2007-01-05 14:27:36

Wet:

I tried that and it jacked up the results. (ie no results showed)

I am going to try to see if Rob has an answer, but if you could take a quick look it would be much appreciated.

Thanks.

progre55

rohner · 2007-04-17 00:04:33

Did Rob have the answer? I am having the same problem. The numbers won’t sort correctly above 100. Thanks!

Last edited by rohner (2007-04-17 00:04:52)

Zanza · 2007-04-17 07:57:16

Maybe the commas in the number are the trouble? Does it work if you cancel the comma ($3250000, $525000)?

Z-

wilshire · 2007-04-17 15:47:18

Try sortby="(custom_8 + 0)"

That should do a numeric sort.

Textpattern CMS