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
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Jon GallegosSubject: two xml statements when mapping xml
Author: Jon Gallegos
Date: 29 Jan 2011 01:03 PM
I am running an xquery which I map into an QBXML format. However i can not seem to create the qbxml statement required by quickbooks.

Here is an example of the xml i am creating

<?xml version="1.0" encoding="utf-8"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">

And here is what quickbooks requires


<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="8.0"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">

How do I produce that second XML statement?

Postnext
Ivan PedruzziSubject: two xml statements when mapping xml
Author: Ivan Pedruzzi
Date: 29 Jan 2011 09:26 PM

The following xquery statement creates a processing instruction

Hope this helps
Ivan

processing-instruction {"qbxml"} {"version='8.0'"}



Postnext
Jon GallegosSubject: two xml statements when mapping xml
Author: Jon Gallegos
Date: 01 Feb 2011 06:20 AM
I am doing something wrong because it does not seem to work for me. This is what I have at the beginning of my xquery

declare namespace tns = "http://webservice.rainiersofware.com/";
declare option ddtek:serialize "omit-xml-declaration=no";
processing-instruction {"qbxml"}{"version='8.0'"} ;

<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<CustomerAddRq>

and the error message I get is
[DataDirect][XQuery][err:XPST0003]Error at line 3, column 51. Unexpected token ";" beyond end of query.

when I take out the ";" then I get
[DataDirect][XQuery][err:XPST0003]Error at line 5, column 7. Unexpected token ">" beyond end of query.

Postnext
Ivan PedruzziSubject: two xml statements when mapping xml
Author: Ivan Pedruzzi
Date: 04 Feb 2011 11:18 PM

Here is a full working example

declare namespace tns = "http://webservice.rainiersofware.com/";
declare option ddtek:serialize "omit-xml-declaration=no,indent=yes";

"&#10;",
processing-instruction {"qbxml"}{"version='8.0'"},"&#10;",
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<CustomerAddRq>
</CustomerAddRq>
</QBXMLMsgsRq>
</QBXML>

Hope this helps
Ivan

Posttop
Jon GallegosSubject: two xml statements when mapping xml
Author: Jon Gallegos
Date: 05 Feb 2011 10:34 AM
That did the trick!

thanks

If I wanted to do that in a regular map (xslt), how would I do that?

 
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.