Help me with my inability to see a simple solution

[Nonsanity]

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 <
bill at 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 <
> bill at 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 <
> > bill at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>