cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gou...@osmosis.gr
Subject Re: Read XML from DB
Date Thu, 12 Aug 2004 10:31:53 GMT


i use esql for that

look at esql:get-xml


-- stavros


a code snip:

		<esql:connection>
			<esql:pool>hotpoints</esql:pool>
			<esql:execute-query>
				<esql:query>SELECT * FROM tblTextBlocks WHERE id_TextBlocks=<xsp-request:get-parameter
name="id"/>
				</esql:query>
				<esql:results>
					<esql:row-results>
						<block>							
<id_TextBlocks><esql:get-string column="id_TextBlocks" root="id_TextBlocks"/></id_TextBlocks>

<textBlock_Title><esql:get-string column="textBlock_Title" root="textBlock_Title"/></textBlock_Title>
						
<esql:get-xml column="textBlock_Description" root="textBlock_Description"/>
						</block>
					</esql:row-results>
				</esql:results>
				<esql:no-results>
                no record was found
                </esql:no-results>
			</esql:execute-query>
		</esql:connection>

On Thu, 12 Aug 2004, Stephan Coboos wrote:

> Hello,
> 
> is there a generator (or other component) available, which reads a 
> textfield (contains wellformed xml) form a db (relational, oracle) and 
> includes the text as xml into the pipeline?
> 
> Thank you.
> 
> Regards
> Stephan
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message