Re: [mv] sort problem

[Ed LaFrance <edlafrance@printexusa.com>]

******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******

Apparently the code field is considered a character field, so you are
getting character based sorting: 19 comes before 2, just like AZ comes
before B.  There is probably a way to force a numeric sort, but I don't
have any pointers for you, time to starting digging through the docs again.

- Ed L.

>******    message to minivend-users from "Marcus Weseloh"
><marcus@connexions.co.uk>     ******
>
>Hi,
>
>I am trying to display and sort my whole products database with
>this code:
>-----
><TABLE>
>[tag each products]
>[sort products:0:]
>    <TR>
>        <TD>[loop-code]</TD>
>        <TD>[loop-field category]</TD>
>        <TD>[loop-description]</TD>
>        <TD>[loop-price]</TD>
>    <TR>
>[/tag]
></TABLE>
>-----
>
>My test database contains 20 products with sku's 1 to 20 so I
>expected the products to show in the proper order. The result I get
>though is as following:
>1, 10, 11 ... 19, 2, 20, 3, 4 ...9
>
>I tried [sort products:0:n] and/or doing the whole thing with [page
>scan ra=yes] and then sorting the [search-list], but that returned
>the same list.
>I looked through the archives but couldn't find anything useful. The
>docs didn't help either, or I'm just blind. Can you help me out?
>Where's my mistake?
>
>For test purposes I'm running Minivend V3.14-4 on a WinNT4 SP4
>machine. Later, the catalogue will be moved to a FreeBSD system.
>
>Cheers,
>
>	Marcus
>
>
>---
>Marcus Weseloh
>Webmaster & Developer
>Connexions http://design.connexions.co.uk
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list


-
PRINTEX Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
(858) 513-2418
(800) 982-1928
(858) 513-2419 fax
edlafrance@printexusa.com
http://www.printexusa.com


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list