Re: [users] Very strange sorting error/brian

2010-03-02 Thread Brewster Gillett
> >Brian Barker wrote: > >>Mind you, ZIP data should probably all be text, in fact. bg: > >That's an intriguing notion. Since ZIPs only ever consist of > >numbers, why would it be preferable to store them as text? So as to > >avoid confusion with "real" numbers? Brian: > Oh, because they are

Re: [users] Very strange sorting error/brian

2010-03-02 Thread Brian Barker
At 08:08 01/03/2010 -0800, Brewster Gillett wrote: Brian Barker wrote: Mind you, ZIP data should probably all be text, in fact. That's an intriguing notion. Since ZIPs only ever consist of numbers, why would it be preferable to store them as text? So as to avoid confusion with "real" numbers

Re: [users] Very strange sorting error/brian

2010-03-01 Thread jomali
On Mon, Mar 1, 2010 at 11:08 AM, Brewster Gillett wrote: > > > bg: > > That's an intriguing notion. Since ZIPs only ever consist of numbers, > why would it be preferable to store them as text? So as to avoid > confusion with "real" numbers? > > jomali: That's not entirely true. Extended zip code

Re: [users] Very strange sorting error/brian

2010-03-01 Thread Brewster Gillett
> >Brian Barker wrote: > >>Either that or the care taken by the user? Let's be fair: you need > >>to test and reproduce such a problem before you can rightly assume > >>that it is a bug. bg: > > > >Right you are, Brian - of course it's more a matter of ignorance > >than of lack of care br

Re: [users] Very strange sorting error/brian

2010-02-28 Thread Brian Barker
At 15:36 28/02/2010 -0800, Brewster Gillett wrote: Brian Barker wrote: Either that or the care taken by the user? Let's be fair: you need to test and reproduce such a problem before you can rightly assume that it is a bug. Right you are, Brian - of course it's more a matter of ignorance tha

Re: [users] Very strange sorting error/brian

2010-02-28 Thread Brewster Gillett
> At 09:44 28/02/2010 -0800, Brewster Gillett wrote: > >This is an incomprehensible error, and calls into question the > >integrity of the code, big-time ... Brian Barker wrote: > Either that or the care taken by the user? Let's be fair: you need > to test and reproduce such a problem before

Re: [users] Very strange sorting error

2010-02-28 Thread Brian Barker
At 09:44 28/02/2010 -0800, Brewster Gillett wrote: I have a list of names and addresses I maintain using OpenOfficeCalc. It does just fine - I don't need any database features. But I was handed a decidedly odd "SORT" screwup this morning. I intended to sort by ZIP. The lowest numerical ZIP is

[users] Very strange sorting error

2010-02-28 Thread Brewster Gillett
I have a list of names and addresses I maintain using OpenOfficeCalc. It does just fine - I don't need any database features. But I was handed a decidedly odd "SORT" screwup this morning. I intended to sort by ZIP. The lowest numerical ZIP is 97005, and the highest one that would appear in the lis