Doing a numeric sort before processing would solve it on the LC side. ~ Chris Innanen ~ Nonsanity
On Sun, Dec 26, 2010 at 1:54 PM, william humphrey < b...@bluewatermaritime.com> wrote: > I fixed it by checking to make sure every number was formatted as three > characters first. It's funny what you don't see... > > On Sun, Dec 26, 2010 at 2:34 PM, william humphrey < > b...@bluewatermaritime.com> wrote: > > > I just found out that the number set: > > > > (001,002,003,005,006,007,008,009,5,6) > > > > wrecks most of the solutions. It was because SQL was sorting a way that > > included the zeros in the sort so the sort would come out looking like > the > > above. I didn't notice what was causing the problem until I scrolled way > > down the list and saw the numbers without the zeros in front of them. > > > > On Wed, Dec 22, 2010 at 11:17 AM, william humphrey < > > b...@bluewatermaritime.com> wrote: > > > >> Ken that is too easy and simple. Even I can understand it at a glance. > >> Can't possibly work. Thanks everyone for lots of excellent answers! > > > > > > > > > > -- > > http://www.bluewatermaritime.com > > > > > > -- > http://www.bluewatermaritime.com > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
