[Zope] DTML bug with database arrays in sqltest

[David Pratt]

This workaround is an excellent solution!  I am doing:

<dtml-if an_arg>
    and a_table.an_array_fieldt[<dtml-sqlvar an_array_key type=int>][2] 
= <dtml-sqlvar a_title type=string>
</dtml-if>

and just insert above any optional statements. Many thanks Dieter !!!!

Regards,
David


On Sunday, July 10, 2005, at 06:59 PM, Dieter Maurer wrote:

> David Pratt wrote at 2005-7-8 14:08 -0300:
>> ...
>> <dtml-and>
>>     <dtml-sqltest column=a_table.an_array_field[<dtml-sqlvar
>> an_array_key type="int">][2] name=a_title_var op="eq" type="string"
>> optional>
>> ..... (rest of query)
>>
>> The issue is how to test against these values when DTML cannot parse
>> them?
>
> You can emulate the "dtml-sqltest" with "dtml-if" and "dtml-sqlvar"
> (or "dtml-var").
>
> -- 
> Dieter
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 860 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20050711/418f2aa8/attachment.bin