problems sorting by price

["Jeroen de Koning" <jdkoning@mediata.nl>]

I have some problems with sorting search results by price. First of all I've set my locale to some dutch settings:

Locale du_NL mon_decimal_point ,
Locale du_NL mon_thousands_sep . 
Locale du_NL frac_digits 2 
Locale du_NL currency_symbol ƒ 
Locale du_NL p_cs_precedes 1 
Locale du_NL p_sep_by_space 1

This all works fine as far as i know. The next thing is that I've placed my prices in the database (products.asc) in the following format:

15.95
24.95
169.95

etc.

Given that I set the locale to du_NL on my pages Minivend displays these prices as:

15,95
24,95
169,95

Really good, but as soon is I want to sort search results by the poductprice I get in trouble. I use the following syntax to do so (first sort by category then by price):

[search-list]
	[sort products:category products:price]
...

The category sort is going fine, but the price sort is doing something weird. For this example the sort would look like this:

15,95
169,95
24,95

My guess is that Minivend sorts these prices as a string, in that case 16(9,95) comes before 24(,95). But these are prices and 169,95 comes after 24,95. Anyone any suggestions!!

Thanks

Jeroen

-- M P H A S I S  M E D I A  /  M E D I A T A ----------------------------
Jeroen de Koning                              Phone:  +31 (0)71 5238575
Weversbaan 9                                  Fax:    +31 (0)71 5238576
2352 BZ  Leiderdorp, the Netherlands          
www.mphasis.com / www.mediata.nl              E-Mail: jdkoning@mediata.nl