cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Conover <scono...@groundswell.net>
Subject RE: mixing xsql and cocoon xml
Date Thu, 03 Aug 2000 20:12:31 GMT
it removes the hassle of me having to assemble a hierarchical xml structure
out of several different sql queries.  I don't care about being
database-specific, we'll be using Oracle forever.

> -----Original Message-----
> From: Donald Ball [mailto:balld@webslingerZ.com]
> Sent: Thursday, August 03, 2000 1:02 PM
> To: 'cocoon-users@xml.apache.org'
> Subject: RE: mixing xsql and cocoon xml
> 
> 
> On Thu, 3 Aug 2000, Steve Conover wrote:
> 
> > here's an example of a hierarchical query from the XSQL 
> demos.  I'm sure it
> > could be extended to do what I want below (note that XSQL 
> has rowset/row
> > syntax, still hierarchical, and it would require a trivial xsl
> > transformation to achieve the example in the previous email)
> > 
> > SELECT dname,
> >          CURSOR( SELECT ename,sal
> >                    FROM emp
> >                   WHERE emp.deptno = dept.deptno) as 
> employees /* Column
> > Alias */
> >     FROM dept
> 
> oh, well, dude, that's not standard SQL. afraid you're going 
> to have to go
> the dbprism route if you want that to be supported. i'm not 
> even sure how
> that query is supposed to work.
> 
> - donald
> 
> 
> ---------------------------------------------------------------------
> 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