[Zope] ZSql Strange Error

[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 '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)?

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):

Z SQL Method (named sql_query):

	select codigo, nome, tipo
	from cad_exportacao;

DTML Method:

	<select>
	<dtml-in sql_query>
		<option value="&dtml-codigo;"
                    <dtml-if "tipo=='E'">Selected</dtml-if>>
		<dtml-var nome></option>
	</dtml-in>
	</select>

hth,
Casey D.