Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 43164 invoked from network); 4 Sep 2000 21:47:46 -0000
Received: from balld-0.dsl.speakeasy.net (HELO localhost.localdomain)
 (@216.254.77.75)
  by locus.apache.org with SMTP; 4 Sep 2000 21:47:46 -0000
Received: by localhost.localdomain (Postfix, from userid 501)
	id 36E31480F; Mon,  4 Sep 2000 17:50:33 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by localhost.localdomain (Postfix) with ESMTP id 342786087
	for <cocoon-users@xml.apache.org>; Mon,  4 Sep 2000 17:50:33 -0400 (EDT)
Date: Mon, 4 Sep 2000 17:50:33 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: cocoon-users@xml.apache.org
Subject: Re: SQL Processor returning <tag>
In-Reply-To: <20000903231746.A29773@crom.netage.de>
Message-ID: <Pine.LNX.4.21.0009041749280.4074-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

On Sun, 3 Sep 2000, Konstantin Agouros wrote:

> Hi,
> 
> I am currently in the process of trying to implement a system for make written
> offers from a postgres-db which I look at in HTML and print using the fo-
> renderer and the whole thing with cocoon.
> In my setup I have a postgres-db with some tables for products and offers.
> I also have an openldap-server with my contacts. In the postgres-db I just
> save the dn of the person that gets the offer, and then I wrote an extension
> function for postgres that returns something like:
>  <ANSCHRIFT>
> <FIRMA>TestFirma </FIRMA>
> <ANREDE>HERRN</ANREDE>
> <ANSPRECHPARTNER>Testuser</ANSPRECHPARTNER>
> <ANSCHRIFT> Musterstr. 5 </ANSCHRIFT>
> <PLZ>8000</PLZ><ORT>Muenchen</ORT>
> </ANSCHRIFT>
> for a given dn from the table.
> The problem is, that if I query this from my xml-document < and > are changed
> for &lt and &gt. Is there a way I can get the sql-processor to keep the origi-
> nal brackets?

you can't without patching the sqlprocessor to parse the column's results.
however, try using the new esql logicsheet and the get-xml method.

- donald