Am Thursday, 28. August 2003 14:28, schrieb Tom Schindl:
> Well I need some informations from a database(small part) and some from
> XML-Files. If all data comes from a database I'd agree with you. Still
> when having data from different sources like I have I think I've the
> following possibilities:
>
> 1) Using axkit:-URIs => XSP->DBI->XML
> 2) Using xincludes
> 3) Embedd my SQL-Queries into XSL with a construct something like this:
>
> --------------------------8<--------------------------
> <xsl:value-of select="document( 'dbisql:/SELECT_*_FROM_foo' )/test"/>
Using SQL queries inside URL's is generally considered bad practice - you can
easily get bitten by SQL injection and whatnot. I have a prototype SQL
provider (and a more advanced design which I will release when done) which
lets you access either selected rows of any table you want, or lets you
define fixed queries which you can later retrieve via
document('sql:myquery/2.xml') (selecting row nr. 2 of your query). I can send
it to you if you want to play with that, but you also need to patch AxKit in
order to have the 'sql' pseudoprotocol recognized. The provider is quite
limited, but it seems to fit your requirements very well. Tell me if you want
it.
A more generic version of it will be released later.
--
CU
Joerg
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
