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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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

   
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.