Hi,

I am very new to XSLT and planning to do a quick solution to run the SQL select query in XSLT.
The below XSLT works all ok:

<xsl:variable name="streaming" select="sql:disableStreamingMode($AB)" />
<xsl:variable
  name="queryResults"
select="sql:query($aurion, ' SELECT  DOMAINOID DOMAIN, DOMAINNAME NAMEOF, DOMAINDESC DESC_T, DOMAINMODE MODE_ FROM TEST')" />

But now I wanted to select a dummy column from the table. If I run this straight on oracle it works:
SELECT 'modify' action, DOMAINOID DOMAIN, DOMAINNAME NAMEOF, DOMAINDESC DESC_T, DOMAINMODE MODE_ FROM TEST'

But If run the same query in XSLT it fails. Is there a way to escape ' characters in SQL so that I can run this query in XSLT and get the results through..

Your quick response will be greatly appreciated..

Thanks
Gagan

 



--- On Fri, 15/4/11, saxon-help-request@lists.sourceforge.net <saxon-help-request@lists.sourceforge.net> wrote:

From: saxon-help-request@lists.sourceforge.net <saxon-help-request@lists.sourceforge.net>
Subject: Welcome to the "saxon-help" mailing list
To: gaganld@yahoo.com
Received: Friday, 15 April, 2011, 5:56 AM

Welcome to the saxon-help@lists.sourceforge.net mailing list! Welcome
to the saxon-help mailing list, a resource for users of the Saxon
XSLT/XQuery processor written by Michael Kay. This is not a formal
technical support service, but we try to be helpful.

An archive of the list is available at http://saxon.markmail.org/

To post to this list, send your email to:

  saxon-help@lists.sourceforge.net

General information about the mailing list is at:

  https://lists.sourceforge.net/lists/listinfo/saxon-help

If you ever want to unsubscribe or change your options (eg, switch to
or from digest mode, change your password, etc.), visit your
subscription page at:

  https://lists.sourceforge.net/lists/options/saxon-help/gaganld%40yahoo.com


You can also make such adjustments via email by sending a message to:

  saxon-help-request@lists.sourceforge.net

with the word `help' in the subject or body (don't include the
quotes), and you will get back a message with instructions.

You must know your password to change your options (including changing
the password, itself) or to unsubscribe.  It is:

  admin123

Normally, Mailman will remind you of your lists.sourceforge.net
mailing list passwords once every month, although you can disable this
if you prefer.  This reminder will also include instructions on how to
unsubscribe or change your account options.  There is also a button on
your options page that will email your current password to you.