SSDN - concatenate with xquery

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Jolene Meyer

Subject: concatenate with xquery
Author: Jolene Meyer
Date: 28 Aug 2009 04:40 PM
Originally Posted: 28 Aug 2009 04:38 PM

I am outputing my xml file to a directory where an end user logs in to pick up the file. my xquery outputs the files as 1.xml, 2.xml, 3.xml, etc. I am having overwrite issues. If i run the process before the end user picks it up it will overwrite the existing file.

Any suggestions on how I can change my output? Is there a time stamp feature I can add to the file name?

Thanks
Jolene

eStorefront(3).xquery

Ivan Pedruzzi

Subject: concatenate with xquery
Author: Ivan Pedruzzi
Date: 28 Aug 2009 05:25 PM

You could try current date time

concat("file:///U:/In/",fn:replace(string(current-dateTime()), ":", "-"), ".xml")

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Jolene Meyer

Subject: concatenate with xquery
Author: Jolene Meyer
Date: 28 Aug 2009 05:32 PM

That works somewhat, but i need it to create multiple xml files at the order loop. When i put your suggestion into my program i only got a one file as the output where as before I could of got 1, 2, 3, or more depening on how many i had in the file.

Is that possible?

Ivan Pedruzzi

Subject: concatenate with xquery
Author: Ivan Pedruzzi
Date: 31 Aug 2009 01:30 AM

Use both the index and the time stamp

concat("file:///U:/In/",fn:replace(string(current-dateTime()), ":", "-"),"_", $orderPos, ".xml")

Jolene Meyer

Subject: concatenate with xquery
Author: Jolene Meyer
Date: 31 Aug 2009 02:01 PM

Jolene Meyer

Subject: concatenate with xquery
Author: Jolene Meyer
Date: 31 Aug 2009 02:01 PM

That worked perfect. Thanks

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.