XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
mackan mackanSubject: Strange output
Author: mackan mackan
Date: 03 Dec 2007 09:02 AM
Hi,

I have values in my database (MS SQL Server) that look like this
76000000000
77000000000
78000000000 and so on.
When i use Stylus Studio to build a xml-file it converts the values into
this
7.6E10
7.7E10
7.8E10
How can I make Stylus Studio stop converting my values and just use them as they are.

Regards
Markus

Postnext
Ivan PedruzziSubject: Strange output
Author: Ivan Pedruzzi
Date: 03 Dec 2007 03:39 PM

Markus,

Could you show us how your XQuery looks like?

Thanks
Ivan Pedruzzi
Stylus Studio Team

Postnext
mackan mackanSubject: Strange output
Author: mackan mackan
Date: 04 Dec 2007 02:10 AM
Looks like this

<frequencyInformation>
<frequencyTable name="Sweden">
{
for $radioInterface1 in collection("KundDB.dbo.radioInterface1")/radioInterface1
return <radioInterface Allocation_Term="{ $radioInterface1/Allocation_Term }" Application_Term="{ $radioInterface1/Application_Term }" Art33Requirements="{ $radioInterface1/Art33Requirements }" Art33Requirements_notes="{ $radioInterface1/Art33Requirements_notes }" ChannelOccupationRules="{ $radioInterface1/ChannelOccupationRules }" ChannelOccupationRules_notes="{ $radioInterface1/ChannelOccupationRules_notes }" Channeling="{ $radioInterface1/Channeling }" Channeling_notes="{ $radioInterface1/Channeling_notes }" DuplexDirection="{ $radioInterface1/DuplexDirection }" DuplexDirection_notes="{ $radioInterface1/DuplexDirection_notes }" FrequencyPlanning="{ $radioInterface1/FrequencyPlanning }" FrequencyPlanning_notes="{ $radioInterface1/FrequencyPlanning_notes }" LicensingRegime="{ $radioInterface1/LicensingRegime }" LicensingRegime_notes="{ $radioInterface1/LicensingRegime_notes }" NotificationNo="{ $radioInterface1/NotificationNo }" NotificationNo_notes="{ $radioInterface1/NotificationNo_notes }" Reference="{ $radioInterface1/Reference }" Reference_notes="{ $radioInterface1/Reference_notes }" Remarks="{ $radioInterface1/Remarks }" Remarks_notes="{ $radioInterface1/Remarks_notes }" TransmitPowerLimit="{ $radioInterface1/TransmitPowerLimit }" TransmitPowerLimit_notes="{ $radioInterface1/TransmitPowerLimit_notes }" higher_frequency="{ $radioInterface1/higher_frequency }" lower_frequency="{ $radioInterface1/lower_frequency }"/>
}
</frequencyTable>
</frequencyInformation>

Postnext
Ivan PedruzziSubject: Strange output
Author: Ivan Pedruzzi
Date: 04 Dec 2007 03:56 PM
Hi Markus,

Could you tell us what kind of type is the table column holding the numeric value?

Thanks!
Ivan

Postnext
Ivan PedruzziSubject: Strange output
Author: Ivan Pedruzzi
Date: 04 Dec 2007 04:18 PM


if the numbers you are extracting do not have decimals you could cast them to long or integer, for example

{ xs:long( $radioInterface1/MyBigNumber) }

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
mackan mackanSubject: Strange output
Author: mackan mackan
Date: 05 Dec 2007 09:23 AM
It helped! Thanks for the help.

/Markus

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.