RE: Problem with money

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 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 back with the pieces I listed above and we'll have another go at it.
-- 
Charles Knell
cknell@xxxxxxxxxx - email



-----Original Message-----
From:     Dan <dan@xxxxxxxxxxxxxxx>
Sent:     Thu, 20 Nov 2003 11:37:40 -0600
To:       <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Subject:   Problem with money

I know, I know, who doesn't have problms with money?  I am hoping mine is easy to fix though.  

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 that querries the DB and builds me an XML file containign all the data.  I then have an ASP page that accepts some paramaters and then loads the XML and XSL documents and does the tranform so as to send plain HTML to the client.  The 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 which is supposed to display a monetary value.  In the database, the column is of type money (MS SQL 2000) but in the created XML file, they lok like regular numbers (100, 200, 900).  When this column displays, the display is a normal nuber 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 commas and decimal point.  And I have added the dollar sign, but how can I make this collumn sortable?

Thanx.

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




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