Have another column, "SortOrder". Then do SELECT * FROM MyTable ORDER BY SortOrder.
Posts made by kierenj
-
RE: I don't wanna create a WTF.. database question
-
RE: Only An Int32 ?
Well theres no need for this to be a WTF. Perhaps the TpsSheet.Layer is a bitfield, indicating which layers the TpsSheet has/is associated with.
-
RE: How do you pronounce faq
Don't be absurd. FAQ is an acronym only, so it's "F A Qs". SQL is only pronounced 'sequel' because it used to be 'SEQUEL' until the inventor renamed the next iteration.
-
XMLSpy Spellcheck
Ack, the XMLSpy Spellcheck function doesn't have "xml" in the dictionary. Just a mini WTF.
-
RE: More XML woes!
HTML isnt escaped in quotations? Dodgy :|
So if someone were to quote me...
<script>alert(document.cookie);</script>
.... ?
<SCRIPT>alert(document.cookie);</SCRIPT> -
RE: Best error message ever
In my latest project, I wrote a dependancy-aware job scheduler, inspired by these great examples there's a try/catch around the main function, with a MessageBox.Show("Useless error message.");. At least it's not lying...
-
RE: X++
XML programming languages are a new thing?
What about XSLT? It's a functional language, sure, but still a programming language.
Also IMO: XML is good. Doubley so with .NET. I spend all day writing .NET solutions, and the ability to persist a DataSet / DataTable to disk for permanant storage with "WriteXml" or similar is great.
Great because (1) you can directly transform that XML into reports etc using XSLT, (2) its just as easy to make a DataSet appear from nowhere just using "ReadXml" and (3) if it all goes wrong, just open up the XML file - you can read the data in there yourself.
That's what they mean by human-readable. The important thing is that when it comes down to it and there's some issue, you can just open the XML file or access the XML straight from the debugger.
Is there anyone here who can provide an example as to where XML hasn't been useful? i.e. it's hindered them? Plenty of people saying how they don't like it, but have you actually been stumped by a problem that XML has caused? Now, how many people like me have had to run through KB/MB of raw data, CSVs or similar, which cause far more "stumps"..