Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Geek Help
PostPosted: Wed Apr 14, 2010 10:59 
User avatar
Excellently Membered

Joined: 30th Mar, 2008
Posts: 1268
Location: Behind you!
Hi Guys,

New topic for all things Geek and in requirement of help.

I'm using XSL to convert XML into a HTML form. All going well until I run into a problem with XSL not being able to support the scientific notation coming from SQL servers directly into the XML.

XML has "0.12121212E-2" or something like that I want to display it as 0.0012121212... perhaps rounded to some degree. Either way I don't want to display "NaN", which currently gets displayed while trying to format the numbers.

Only solution I can find is to change how the SQL server output values from a double to a decimal but I'm not allowed to do that. Ideally every thing needs to be done via the XSL.

Has anyone had to solve this problem before? Any solutions?


Top
 Profile  
 
 Post subject: Re: Geek Help
PostPosted: Wed Apr 14, 2010 11:03 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
First page of Google results for "xsl convert scientific notation" seems to contain a ton of stuff.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Geek Help
PostPosted: Wed Apr 14, 2010 11:58 
User avatar
Excellently Membered

Joined: 30th Mar, 2008
Posts: 1268
Location: Behind you!
All need XSLT 2.0 or additional files. I give up.


Top
 Profile  
 
 Post subject: Re: Geek Help
PostPosted: Wed Apr 14, 2010 12:14 
User avatar
Excellently Membered

Joined: 30th Mar, 2008
Posts: 1268
Location: Behind you!
I didn't.... have got it working after looking through some of the posts on some sites some more.

Did this:

http://stackoverflow.com/questions/2342 ... ith-xsltfo

and clicked the link to the XSL Template here:

http://www.siafoo.net/snippet/51?nolinenos

All works in one file.


Top
 Profile  
 
 Post subject: Re: Geek Help
PostPosted: Fri Mar 18, 2011 12:21 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69509
Location: Your Mum
Hello!
A nice top command on my server shows that it's running a tonne of apache processes (load of 16.22, cringe fans). Is there any way I can get a more specific idea of what they are - ie. what web address they are looking for?

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 5 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: Majestic-12 [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search within this thread:
cron
You are using the 'Ted' forum. Bill doesn't really exist any more. Bogus!
Want to help out with the hosting / advertising costs? That's very nice of you.
Are you on a mobile phone? Try http://beex.co.uk/m/
RIP, Owen. RIP, MrC.

Powered by a very Grim... version of phpBB © 2000, 2002, 2005, 2007 phpBB Group.