|
You cannot embed one dtml tag within another dtml
tag.
A couple of possible work-arounds:
1) use a python script to return the values you
need
2) create a python script which 'builds' a new dtml
script and then execute the new script (ugly, but it works - not very efficient,
so how often you run this will be a factor).
hth
Jonathan
----- Original Message -----
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 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
irrelevant. I replaced the table, field names and arguments with names that
might make this more understandable.
First. I am finding arrays work
fine with select statements in DTML when you use sqlvar to request a specific
value from the array.
ie.
SELECT
a_table.an_array_field[<dtml-sqlvar
some_value type="int">][2]
FROM ....(rest of
query)
But when you put them inside a sqltest tag for
evaluating values it throws an error because DTML cannot parse
it.
ie.
SELECT ...
blah blah.....
<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? My raw sql query works fine giving me the desired
results but I cannot construct the statement in DTML.
The part of the
query that throws the error is the dtml-sqltest tag (it gives a parsing
error).
ie.
<dtml-and>
<dtml-sqltest
column=a_db.an_array_field[<dtml-sqlvar an_array_key type="int">][2]
name=a_title op="eq" type="string" optional>
should translate
to:
AND
a_table.an_array_field[1][2] = 'This is a title' (This is a
valid _expression_ for Postgres)
where an_array_key is a variable with
value of 1 and a_title is variable with a value of 'This is a title'
The above would give an invalid attribute name error for the
an_array_key (variable/argument).
Is this a bug or is
there something else I ought to be doing? If this is a limitation of DTML, is
there a work around?
Regards,
David
_______________________________________________
Zope maillist
-
Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**
No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev
)
|
_______________________________________________
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
