cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject RE: SQL->XSP->SQL
Date Tue, 15 Feb 2000 07:18:00 GMT
On Thu, 10 Feb 2000, Berin Loritsch wrote:

> This is a gotcha with any markup language using the carats ('<', and '>') to
> mark the tags.  You will undoubtedly want to encase the query in a CDATA
> phrase like this:
> 
> <![#CDATA[select name from table where koordinate < newkoordinate]]>
> 
> This problem is a result of not knowing the semantics of XML parsing
> rules.

Oh, my, I totally misunderstood the original poster's problem. Yeah,
you're totally right, your SQL must follow XML encoding rules. This
doesn't change the problems I outline with doing nested SQL queries in a
single XSP page though.

- donald

> 
> -----Original Message-----
> From:	Andree Halfter [SMTP:borun@cryogen.com]
> Sent:	Thursday, February 10, 2000 11:19 AM
> To:	cocoon-users@xml.apache.org
> Subject:	SQL->XSP->SQL
> 
> Hi all,
> 
> I'm working with Cocoon 1.6.1, XSP works fine and SQL works fine. 
> Now my problem: 
> I want to get some data from an database: 
> <query connection ="xy">select koordinate from table where ...</query> 
> No problem. 
> Now I want to modify the value "koordinate" (for instance newkoordinate =
> koordinate + 10) 
> And now (this is the problem) I want to made a 2nd SQL-query with
> "newkoordinate". 
> <query connection...>select name from table where koordinate <
> newkoordinate</query> 
> This is my problem, I can't make an sql-query, modify the gotten value and
> make an sql-query again. 
> How can I do this? 
> I don't find anything in the mailing list, or I'm too stupid???
> 
> Thanks, Andree
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 


Mime
View raw message