Hi!

I'm trying to emulate an outter join in a Z SQL, but Zope crashes every
time I try the query.

The query is defined as:

-*-*-

parameters: username
query definition:

select codigo, nome, 'T' as select
from cad_exportacao
where codigo in ( 
        select codigo
        from user_codigo
        where username = <dtml-sqlvar username type=string>
                and tipo = 'E' )
union all
select codigo, nome, 'F' as select
from cad_exportacao
where codigo not in ( 
        select codigo
        from user_codigo
        where username = <dtml-sqlvar username type=string>
                and tipo = 'E' )

-*-*-

The log messages says there's not a 'cad_exportacao' relation (that is
not true, the relation exists).

Zope 2.2, Linux 2.2, PostgreSQL 7.0, ZyGreSQLDA 0.03 (from the README).

What is wrong? What I can do to get the job done (I need to fill an
multiselect with 'codigo', 'nome' from 'cad_exportacao', and if exists
any 'codigo' for 'username' in 'user_codigo', the option must be
selected - I tryed the "Filling MULTIPLE SELECT ... HOWTO', but it
doesn't works for me, and I don't know why)?

TIA
-- 
CÚsar A. K. Grossmann
http://members.xoom.com/ckant/

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to