[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Sorting Numbers
****** message to minivend-users from Ed LaFrance <edl@newmediaems.com> ******
At 10:55 PM 6/27/00 -0700, you wrote:
>****** message to minivend-users from Sydney Urshan
><urshan@nethollywood.net> ******
>
>I can't believe that I asked this list 2 complex questions and received
>the answers the same day! So here goes the third:
>
>When sorting results by code numbers in Minivend, the first number is
>considered. For example, 005678 comes before 321 (0 before 3). To have
>it the other way, I have to add zeros - 000321. However, in MySQL, it
>sorts the way I prefer, 321 before 005678, (the 00 are stripped off in the
>calculation.) I had to renumber an entire mv database (not using MySQL)
>to sort the way I wanted, but now there are to many zeros: 00000321,
>00000322, to sore before 01234555, etc. My question is how to tell a mv
>search (without MySQL) to strip the zeros and calculate the literal number
>like MySQL?
Did you try mv_sort_option="n" ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| New Media E.M.S. Software Solutions for Business |
| 12831 Blanco Ct. Consulting |
| Poway, CA 92064 U.S.A. Custom Programming |
| 858-486-6508 Internet and eCommerce |
| 630-604-4265 eFax |
| edl@newmediaems.com |
| http://www.newmediaems.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
