Did you try to use EntityWhereString ? Jacques
----- Message d'origine ----- De : "Tim McGuire" <[EMAIL PROTECTED]> À : <[email protected]> Envoyé : jeudi 12 juillet 2007 06:50 Objet : crosstab queries > Hi, > > I'm wondering how to approach crosstab queries with the entity engine. > That is, I want to turn data from a row into a column heading. > > if the entity is something like: > > salesperson(char 20), month(number), total(number) > > and I want a query like > > SELECT salesperson, > (SELECT SUM(total) from sales where month = 1) as 'JAN', > (SELECT SUM(total) from sales where month = 2) as 'FEB', > . > . > . > . > . > . > (SELECT SUM(total) from sales where month = 12) as 'DEC', > (SELECT SUM(total) as 'GRAND Total' > > reading the entity engine cookbook, I see a way to to SUMs and other > functions, but not sub-selects. > > and also I have a case where I would have to get the column names > themselves using a query. For this, I would be limited to JDBC, I take > it? > > > > > Tim McGuire > Integral Business Solutions > phone: (651) 259-1008
