Re: [Zope] DTML bug with database arrays in sqltest

2005-07-11 Thread 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,

Re: [Zope] DTML bug with database arrays in sqltest

2005-07-10 Thread Dieter Maurer
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

[Zope] DTML bug with database arrays in sqltest

2005-07-08 Thread David Pratt
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

Re: [Zope] DTML bug with database arrays in sqltest

2005-07-08 Thread Jonathan
you run this will be a factor). hth Jonathan - Original Message - From: David Pratt To: zope@zope.org Sent: Friday, July 08, 2005 1:08 PM Subject: [Zope] DTML bug with database arrays in sqltest I am using arrays in Postgres. I need to be able to compare

Re: [Zope] DTML bug with database arrays in sqltest

2005-07-08 Thread David Pratt
Do you mean external methods with db api for 1)? I find I can use a plain statement like this in DTML ... but I cannot make it conditional. To bad you couldn't use ZPT instead to make ZSQL methods since it is XML or even some kind of XML schema just for making queries. It wouldn't have to be