I like that idea
On 8/14/2021 9:46 AM, Adrian Klaver wrote:
On 8/14/21 9:37 AM, Bret Stern wrote:
Strings;
I haven't explored doing this with numeric types, but some columns
needed alpha chars eg 13mm.
Two columns:
data_val(numeric) data_unit(varchar)
13 mm
Although I could have front ended this UI with mm nomenclature I did
not.
I'll put a table together with appropriate numeric types and see if
the sort will behave.
It will.
On 8/14/2021 9:21 AM, Adrian Klaver wrote:
On 8/14/21 9:14 AM, Bret Stern wrote:
I have a table with metric, imperial, fraction columns.
Is there a way to sort correctly using imperial (eg; .125, .375,
.437 -> 1., 1.125)
Alright how is this different from metric or fraction?
I can sort of see fraction if you mean as 1/3, 1/20, etc.
What is the data type of the field you are storing this in?
Couldn't handle it with ORDER BY ASC, DESC args so I added a
sort_column and sorted based
on those values eg; 1,2,3,4,5,6 indicating the value I need to show
in which sequence.
Just curious what the pro's do
Bret
