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 » XQuery Help and Discussion » Xquery for timer based events.
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Chandra MSubject: Xquery for timer based events.
Author: Chandra M
Date: 29 Jan 2009 04:24 PM
Hello,

I have a question related to xquery and I am new to use these xqueries syntax :)

I have the following trigger for my XML database named SEDNA and I am trying implement the feature that will execute these triggers at a scheduled time.

CREATE TRIGGER "Trig_Insert_Pending_Order"
BEFORE INSERT
ON document("test_bookstore")//Pending_Order
FOR EACH NODE
DO

{
/*QUERY STATEMENT*/
if (hours-from-dateTime(xs:dateTime('2006-08-15T4:30:23')) == 4)

then

if ($NEW/order_ID > 4)
then
<Pending_Order>{attribute id {$NEW/order_ID}}
{$NEW/*}
<result>{func:increment_quantity(30,10)}</result>
</Pending_Order>
else
<Pending_Order>{attribute id {$NEW/order_ID}}
{$NEW/*}
<result>{func:decrement_quantity(30,1)}</result>
</Pending_Order>
else $OLD;
}

The syntax for the above trigger is accepted for my XML database (SEDNA) but I want the user to provide the scheduled time for this trigger. Can any body explain me the functionalities that I can use with xquery to allow the USER to provide a specific time from java application and read that into my above QUERY STATEMENT.


Thanks,
Chandra
Posttop
Minollo I.Subject: Xquery for timer based events.
Author: Minollo I.
Date: 29 Jan 2009 06:02 PM
What you are describing seems to be an XQuery question very specific to an XQuery implementation available for an XML database, that has no relationship with what Stylus Studio or DataDirect XQuery support.

I would suggest asking the same question to your XML database vendor/distributor.
   
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.