Hello
Another way is to use "ORDER BY" clause when you queries the DB (if situation
allows it).
And I suppose that this way is the most efficient in most cases because 10000
nodes
are too huge for XSLT (too slow).
Charles> We could probably fix this in two seconds if you had included the
<xsl:sort> element from your stylesheet. Since we don't have an example of your
XML nor do we have an example of your XSLT, I'll
Charles> guess that you don't have a "data-type" attribute in your <xsl:sort>
element. If you add one, and set its value to "number", chances are that your
problem will go away. If that fails, then come
Charles> back with the pieces I listed above and we'll have another go at it.
Dan>I know, I know, who doesn't have problms with money? I am hoping mine is
easy to fix though.
Dan>I am bulding an ASP page that contains a large table (10,000 rows or so).
To speed things along, I have created a script
Dan>that querries the DB and builds me an XML file containign all the data. I
then have an ASP page that accepts some
Dan>paramaters and then loads the XML and XSL documents and does the tranform
so as to send plain HTML to the client. The
Dan>problem is I have to be able to sort by any column in the table. This
works fine for the most part, except for one column
Dan>which is supposed to display a monetary value. In the database, the column
is of type money (MS SQL 2000) but in the
Dan>created XML file, they lok like regular numbers (100, 200, 900). When this
column displays, the display is a normal nuber
Dan>and when I try to sort by this column, I get no logical order at all? I
figured out how to use the format function to add
Dan>commas and decimal point. And I have added the dollar sign, but how can I
make this collumn sortable?
--
Best regards,
Ivan Churkin mailto:_qq_(_at_)nsk(_dot_)ru
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list