You need to provide us more information for us to really help. There are
many ways to solve your particular issue, but how to solve it depends a
great deal on what your pipeline looks like (i.e., what tools are available
to us along the way - Java, XSLT, SQLTransformer, etc.). The fragment you
show has you creating a query apparently in XSLT, which doesn't provide
very easy ways to do string manipulation (although it can be done).
Perhaps if we knew what part of cocoon you are using for the actual
database work we'd be able to offer you a better solution. If you are in
an XSP page, you can write a java function. If you are using
SQLTransformer, you may be able to structure your query in XML so that the
escaping will be done for you. Etc.
-Christopher
|---------+---------------------------->
| | Mustafa Yalniz |
| | <[EMAIL PROTECTED]|
| | .tr> |
| | |
| | 07/23/2003 02:51 |
| | PM |
| | Please respond to|
| | users |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: escaping characters
|
>--------------------------------------------------------------------------------------------------------------|
I get the info lets say lastname (Irish name could cause problem) from
<lastname><sunshine:getxml context="request"
path="/parameter/lastname"/></lastname>
and apply sunshine transformer.
later I insert it into the database as below.
insert into user_tb
set name = '<xsl:value-of select="name"/>',
...
lastname = '<xsl:value-of select="lastname"/>'
And the lastname has syntax error in case last name is e.g. O'Reilly.
My question is is there a way in cocoon to process and replace the
characters with escape ones.
Mustafa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
