XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Strange output
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> + Automation using Visual Studio (7)
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ 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.