Re[2]: [xsl] Problem with money

[Ivan Churkin <_qq_@xxxxxx>]

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_@xxxxxx



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list