Re: XSLT in SQL Server 2005

Hi André!

One solution could be that you implement a managed stored procedure or
managed function which does the XSLT transformation for you.

HTH

Klaus Aschenbrenner
MVP Visual C#
www.csharp.at
http://weblogs.asp.net/klaus.aschenbrenner

"André Gil" <AndrGil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:365E624E-6608-4871-8F69-C27CB2938291@xxxxxxxxxxxxxxxx
> Hello all.
>
> I need to apply an XSLT to some data on an xml datatype field of a table.
>
> My problem is this. The XSLT I'm using is to transform the data stored in
> the field to HTML. Is there any way I can do a query on the table and
> automatically (with some trigger or whatever) convert the data to html
> with
> the xslt I have?
>
> By the way, I'm hopping to store the xlst inside the database on the
> collection.
>
> ps: I'm using php to retrieve the data from sql server (hope nobody get's
> mad at me) :D
>
> Thanks
>
> André


.

Relevant Pages

  • Re: Can XSLT render the content: &lt;p&gt as html

    rather than text?
    ... I there a way that the XSLT transformation can render the content as ... Well the proper way to solve that is at the source, instead of escaping the HTML markup you should insert well-formed XHTML markup, then your XSLT stylesheet can easily copy it to the output or transform it to HTML if needed. ... However disable-output-escaping is an optional feature that is not supported by all XSLT processors respectively is not supported with all XSLT uses. ...
    (comp.text.xml)

  • PHP 5, XSL transformations of big files
    ... I have used 3rd tools to process XSLT and it takes few seconds to ... process my big XML file. ... But now I'm moving to PHP so I'm trying to use XSL PHP extension to ... echo 'Failed to save XSLT transformation result to the file ...
    (comp.lang.php)
  • Re: XSLT in SQL Server 2005
    ... When you are doing the XSLT transformation directly in SQL Server 2005, ... can directly return HTML to the client. ...
    (microsoft.public.sqlserver.xml)
  • Re: how do you create an xml element attribute with a namespace
    ... Explicitly issuing namespace declaration ... considered attributes by the XPath Data Model which XSLT is based on. ... exact syntax in the xml document following an xslt transformation. ...
    (comp.text.xml)
  • Re: Newbie, HTML calling XSLT
    ... It is the HTML to XSLT connection I don't understand. ... In some user agents, lets call them desktop browsers, you can have script embedded in a HTML document executed in the browser and even fewer of those browsers also allow script to access an XSLT processor and run an XSLT transformation and then also allow to pass parameters to the XSLT processor before a transformation is performed. ... Server-side XSLT is another approach but that of course requires that the HTML document contains a form or at least a link to a server-side script where the XSLT transformation is performed. ...
    (comp.text.xml)