[Zope] ZSql Strange Error

2000-11-02 Thread Cesar A. K. Grossmann
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

RE: [Zope] ZSql Strange Error

2000-11-02 Thread Casey Duncan
Cesar A. K. Grossmann wrote: Hi! I'm trying to emulate an outter join in a Z SQL, but Zope crashes every time I try the query. ... 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

Re: [Zope] ZSql Strange Error

2000-11-02 Thread Cesar A. K. Grossmann
I'm not sure why this should *crash* zope, but you can do it with a much simpler query and a little DTML coding. The following should work (UNTESTED): It cannot help me. I have two tables. One called cad_exportacao, and the other is called user_codigo. The table user_codigo maps every

RE: [Zope] ZSql Strange Error

2000-11-02 Thread Casey Duncan
, November 02, 2000 12:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [Zope] ZSql Strange Error I'm not sure why this should *crash* zope, but you can do it with a much simpler query and a little DTML coding. The following should work (UNTESTED): It cannot help me. I have

Re: [Zope] ZSql Strange Error

2000-11-02 Thread Cesar A. K. Grossmann
Casey Duncan wrote: Duh, maybe I should learn to read. :-) Let me know if this is any better, It worked! Thanks. []s -- César A. K. Grossmann http://members.xoom.com/ckant/ ___ Zope maillist - [EMAIL PROTECTED]