-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wednesday 19 June 2002 7:07 am, Axel Straschil wrote:
> Hello!
>
> I'm working AxKit 1.6 and ESQL 1.4 with PostgreSQL as database on an
> RedHat system, apache is: Apache/1.3.24 (Unix) AxKit/1.6 mod_perl/1.27
>
> Everything is working fine, but when testing a stored procedure, I tryed
>
> <esql:execute-query>
> <esql:query>
> SELECT '<test></test>' AS xml
> </esql:query>
> <esql:results>
> <esql:get-xml column="xml"/>
> </esql:results>
> </esql:execute-query>
Remember that XSP is XML, and so any tags you don't escape get treated as
literal XML, and so XSP tries to include them in the output, but it can't at
this position in the file. So what you need to do is either use a CDATA
section:
<esql:query><![CDATA[
SELECT '<test></test>' AS xml
</esql:query>
Or use the built in entities to escape it:
<esql:query>
SELECT '<test></test>' AS xml
</esql:query>
- --
<:->get a SMart net</:->
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9ECFiVBc71ct6OywRAo1fAKCTDoinTUC230h0D0ag2T+ARp+z1QCgtzU7
RP/pptEcNAZVGuY1lAlXCso=
=6pa9
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
