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(_at_)onebox(_dot_)com - email
-----Original Message-----
From: Dan <dan(_at_)theroadside(_dot_)org>
Sent: Thu, 20 Nov 2003 11:37:40 -0600
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: [xsl] 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