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
Jolene  MeyerSubject: 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


UnknowneStorefront(3).xquery

Postnext
Ivan PedruzziSubject: 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

Postnext
Jolene  MeyerSubject: 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?

Postnext
Ivan PedruzziSubject: 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")

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

Posttop
Jolene  MeyerSubject: 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 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.