SELECT * FROM BASE ORDER BY CONTENT ...?
Next message: Alex M: "EXCEPTION [TOPLINK-43] problems in Toplink 3.6, Oracle 8.1.7, Weblogic 8.1 SP1"
Date: Mon, 22 Dec 2003 19:26:12 +0100
I have a column in a table which has the next content and
I must sort them like this:
//CONTENT//
0.1
0.2
0.3
0.3.1
0.4
0.5
0.6
0.6.1
0.6.1.1.
0.6.1.2.
0.7
0.8
0.9
0.10 <----
You know, like a content of the book.
And if I:
SELECT * FROM BASE ORDER BY CONTENT
I got 0.10 behind the 0.1
0.1
0.10 <----
0.2
0.3
0.3.1
0.4
0.5
0.6
0.6.1
0.6.1.1.
0.6.1.2.
0.7
0.8
0.9
and I need sort the column like first one.
The type of column must be a string because of mark "."
So how can I sort the string to get numbers ordered by value?
Next message: Alex M: "EXCEPTION [TOPLINK-43] problems in Toplink 3.6, Oracle 8.1.7, Weblogic 8.1 SP1"
Relevant Pages
- Re: VB6 LISTBOX problem
... Have a look at the code below, can you do a sort that is faster ... There are of course all sorts of ways of sorting stuff, especially stuf that is "linked together" as in your UDTs, but to prove the following code sorts it in exactly the same way that your own original code does so, by concatenating all three items of each element into a composite string exactly as you are already doing, but instead of dumping those composite strings into a ListBox it dumps them into a VB string array. ... Private Type SAFEARRAY1D ... Dim StPtr As Long, VAs String, pVAs Long ...
(microsoft.public.vb.general.discussion) - C Sharp sorting considered superior to C by an order of magnitude
... following sort algorithms and the following points. ... its own comparision for the types bool, byte, short, int, long, ... single, double and string. ... private CheckBox CHKdeterminism; ...
(comp.programming) - Re: Cant Figure Out How To Sort On Bind
... The sort order is not being passed as an argument, ... with the string "searchCache" to create a key for it, ... 'Assign ColumnOrder to ViewState ... Sub GetDataReader(ByVal ColumnOrder As String) ...
(microsoft.public.dotnet.framework.aspnet) - Re: Chris Rockliffes Hofner.
... It looks disgusting - the original finish was a sort of pewkey ... pickups with one of those steel wire wool pan scrubbers - there was no ... strings in you have to push the trem fixture forward, ... Peter Green-ish tone. ...
(rec.music.makers.guitar.acoustic) - Re: Cant Figure Out How To Sort On Bind
... public MySearchResults(string aa, string bb, string cc) ... MySearchResultsx1 = x as MySearchResults; ... The sort order is not being passed as an argument, ... 'Assign ColumnOrder to ViewState ...
(microsoft.public.dotnet.framework.aspnet) |
|
