Re: [xsl] Xalan ODBC extension - implementation

["David N Bertoni/CAM/Lotus" <david_n_bertoni@xxxxxxxxxx>]

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: [xsl] 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