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 » Stylus Studio Technical Forum » DB to XML Parameters
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> - DB to XML Parameters (2)
-> ->DB to XML Parameters
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-- Previous [1861-1880] [1881-1900] [1901-1920] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
   
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.