[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Xalan ODBC extension - implementation
You should join and post your questions on the Xalan-C++ or Xalan-J user list, as appropriate. See: http://xml.apache.org/mail.html Xalan-J already has a set of SQL extensions. Xalan-C++ does not, but it is possible to construct nodes to represent such fragments and return them as the result of an extension function. Dave Curtis Burisch <burisch@xxxxxxxxxxx> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Sent by: cc: owner-xsl-list@xxxxxxxxxxx Subject: Xalan ODBC extension - implementation rrytech.com 01/22/2002 03:57 AM Please respond to xsl-list Hi, At my company are implementing an extension function to Xalan which queries an ODBC database. An SQL string is passed in, and the result set is returned. We are still in the process of defining how the result set will be returned. When one row, one column (i.e. a single value) is returned, there is no problem. However, when multiple rows & columns are returned, I am unsure how to structure the data returned, or if indeed this is the right way to be going about the problem. Our plan at the moment is to return an xml fragment, something like: <Record> <Field name="fred">test1</Field> <Field name="joe">test2</Field> </Record> <Record> <Field name="fred">test3</Field> <Field name="joe">test4</Field> </Record> Now, obviously this would be returned as a string and won't be parsed into a tree fragment, and thus can't be interpreted by Xalan -- is there any way to do it? It's also highly possible that we're re-inventing the wheel. Has anybody heard of or used an extension which would meet our requirements? Many thanks for your time! Best regards, Curtis Burisch. -- XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|