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
Cassidy HuntSubject: DB to XML Parameters
Author: Cassidy Hunt
Date: 06 Nov 2006 10:34 AM
I am trying to figure out how to pass parameters to the select statement performed in the DB to XML file.

For example:

select id, description from part where id = :part_id

:part_id is my paramter that I would like to specify each time. The reason for this is if I just do the blanket request of select id, description from part then I get over 6 million records returned which isn't the best use.

I might be using the wrong method to do this so I am open to anything.

Thanks

Cassidy

Posttop
Ivan PedruzziSubject: DB to XML Parameters
Author: Ivan Pedruzzi
Date: 06 Nov 2006 12:13 PM

Cassidy,

DB to XML doesn't support parametrized query.
Please have a look to how to query relational data using DataDirect XQuery


http://www.stylusstudio.com/xquery/datadirect_xquery.html

http://www.stylusstudio.com/docs/v2007/d_xquery36.html#wp601937


Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
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.