[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Sorting Numbers
****** message to minivend-users from cfm@maine.com ******
On Thu, Jun 29, 2000 at 07:21:42AM -0700, Ed LaFrance wrote:
> ****** message to minivend-users from Ed LaFrance <edl@newmediaems.com> ******
> >
> >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
This amounts to overloading the codes and ultimately becomes confusing.
We typically now include a "seq" column specifically for sequencing sorts.
Since we do everything in SQL we just use an int, but it does not have
to be.
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
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
