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,
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
I am using arrays in Postgres. I need to be able to compare a string value in a specific position of a text array field (text[] is a field type in Postgres) against a variable(argument) I am passing to my query. I am only using parts of the query to illustrate the problem as the rest is