nested <dtml-in ...> statements breaking
I have nested queries using dtml-in statements. The outer query performs a broad query based on a number of variables and returns a number of variables for several records. The inner query performs a dtml-sqltest on one of the variables returned and returns another set of variables. (Or at least it is supposed to.) The only variable that two queries share is the variable on which the inner query performs the dtml-sqltest. The inner query gives me a key error, asking for a variable supplied by the outer query. Strangely, the inner query works when nested within a query that returns a single record using the same dtml-sqltest as the inner query. Any pointers on how to manage this?
Sure thing. Here is are the nested dtml-in statements: <dtml-in casesquery> <dtml-in oralargumentsquery> <dtml-var dateargued> </dtml-in> </dtml-in> And these are the Z SQL Methods: Z SQL Method at /search/casesquery Arguments: casenamein citationin year1 year1op year2 year2op opinionin orderby SELECT casecitation, year, volume, page, shortcasename, findlaw, ussc, lii FROM cases WHERE year > 0 AND year < 2000 <dtml-if citationin>AND casecitation LIKE <dtml-sqlvar citationin type="string"></dtml-if> <dtml-if year1>AND year <dtml-var year1op> <dtml-sqlvar year1 type="string"></dtml-if> <dtml-if year2>AND year <dtml-var year2op> <dtml-sqlvar year2 type="string"></dtml-if> <dtml-if casenamein>AND CONTAINS (shortcasename, <dtml-sqlvar casenamein type="string">)</dtml-if> <dtml-if opinionin>AND CONTAINS (opinion, <dtml-sqlvar opinionin type="string">)</dtml-if> <dtml-if orderby>ORDER BY <dtml-var orderby> ASC</dtml-if> ; Z SQL Method at /search/oralargumentsquery Arguments casecitation SELECT * FROM oralarguments WHERE <dtml-sqltest casecitation type=string> ORDER BY dateargued That's it! -----Original Message----- From: Kevin Carlson [mailto:khcarlso@bellsouth.net] Sent: Thursday, June 06, 2002 8:12 PM To: donald.braman@yale.edu Subject: RE: [Zope] nested <dtml-in ...> statements breaking Hi Donald, Could you post the code? Thanks, Kevin -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Donald Braman Sent: Thursday, June 06, 2002 10:57 PM To: Zope@Zope. Org Subject: [Zope] nested <dtml-in ...> statements breaking I have nested queries using dtml-in statements. The outer query performs a broad query based on a number of variables and returns a number of variables for several records. The inner query performs a dtml-sqltest on one of the variables returned and returns another set of variables. (Or at least it is supposed to.) The only variable that two queries share is the variable on which the inner query performs the dtml-sqltest. The inner query gives me a key error, asking for a variable supplied by the outer query. Strangely, the inner query works when nested within a query that returns a single record using the same dtml-sqltest as the inner query. Any pointers on how to manage this? _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Donald, You're not sending the variable into the second zsql statement... <dtml-in casesquery> <dtml-in "oralargumentsquery(casecitation=variablefromouter)"> <dtml-var dateargued> </dtml-in> </dtml-in> That should do it I think. Cheers, Paz -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of Donald Braman Sent: Friday, June 07, 2002 6:33 AM To: Zope@Zope. Org Subject: [Zope] RE: nested <dtml-in ...> statements breaking Sure thing. Here is are the nested dtml-in statements: <dtml-in casesquery> <dtml-in oralargumentsquery> <dtml-var dateargued> </dtml-in> </dtml-in> And these are the Z SQL Methods: Z SQL Method at /search/casesquery Arguments: casenamein citationin year1 year1op year2 year2op opinionin orderby SELECT casecitation, year, volume, page, shortcasename, findlaw, ussc, lii FROM cases WHERE year > 0 AND year < 2000 <dtml-if citationin>AND casecitation LIKE <dtml-sqlvar citationin type="string"></dtml-if> <dtml-if year1>AND year <dtml-var year1op> <dtml-sqlvar year1 type="string"></dtml-if> <dtml-if year2>AND year <dtml-var year2op> <dtml-sqlvar year2 type="string"></dtml-if> <dtml-if casenamein>AND CONTAINS (shortcasename, <dtml-sqlvar casenamein type="string">)</dtml-if> <dtml-if opinionin>AND CONTAINS (opinion, <dtml-sqlvar opinionin type="string">)</dtml-if> <dtml-if orderby>ORDER BY <dtml-var orderby> ASC</dtml-if> ; Z SQL Method at /search/oralargumentsquery Arguments casecitation SELECT * FROM oralarguments WHERE <dtml-sqltest casecitation type=string> ORDER BY dateargued That's it! -----Original Message----- From: Kevin Carlson [mailto:khcarlso@bellsouth.net] Sent: Thursday, June 06, 2002 8:12 PM To: donald.braman@yale.edu Subject: RE: [Zope] nested <dtml-in ...> statements breaking Hi Donald, Could you post the code? Thanks, Kevin -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Donald Braman Sent: Thursday, June 06, 2002 10:57 PM To: Zope@Zope. Org Subject: [Zope] nested <dtml-in ...> statements breaking I have nested queries using dtml-in statements. The outer query performs a broad query based on a number of variables and returns a number of variables for several records. The inner query performs a dtml-sqltest on one of the variables returned and returns another set of variables. (Or at least it is supposed to.) The only variable that two queries share is the variable on which the inner query performs the dtml-sqltest. The inner query gives me a key error, asking for a variable supplied by the outer query. Strangely, the inner query works when nested within a query that returns a single record using the same dtml-sqltest as the inner query. Any pointers on how to manage this? _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Try passing the argument explictly, just in case: <dtml-in "oralargumentsquery(casecitation)"> Cheers, Tom P [Donald Braman]
Sure thing. Here is are the nested dtml-in statements:
<dtml-in casesquery> <dtml-in oralargumentsquery> <dtml-var dateargued> </dtml-in> </dtml-in>
And these are the Z SQL Methods:
Z SQL Method at /search/casesquery Arguments: casenamein citationin year1 year1op year2 year2op opinionin orderby
SELECT casecitation, year, volume, page, shortcasename, findlaw, ussc, lii FROM cases WHERE year > 0 AND year < 2000 <dtml-if citationin>AND casecitation LIKE <dtml-sqlvar citationin type="string"></dtml-if> <dtml-if year1>AND year <dtml-var year1op> <dtml-sqlvar year1 type="string"></dtml-if> <dtml-if year2>AND year <dtml-var year2op> <dtml-sqlvar year2 type="string"></dtml-if> <dtml-if casenamein>AND CONTAINS (shortcasename, <dtml-sqlvar casenamein type="string">)</dtml-if> <dtml-if opinionin>AND CONTAINS (opinion, <dtml-sqlvar opinionin type="string">)</dtml-if> <dtml-if orderby>ORDER BY <dtml-var orderby> ASC</dtml-if> ;
Z SQL Method at /search/oralargumentsquery Arguments casecitation
SELECT * FROM oralarguments WHERE <dtml-sqltest casecitation type=string> ORDER BY dateargued
That's it!
-----Original Message----- From: Kevin Carlson [mailto:khcarlso@bellsouth.net] Sent: Thursday, June 06, 2002 8:12 PM To: donald.braman@yale.edu Subject: RE: [Zope] nested <dtml-in ...> statements breaking
Hi Donald,
Could you post the code?
Thanks,
Kevin
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Donald Braman Sent: Thursday, June 06, 2002 10:57 PM To: Zope@Zope. Org Subject: [Zope] nested <dtml-in ...> statements breaking
I have nested queries using dtml-in statements.
The outer query performs a broad query based on a number of variables and returns a number of variables for several records.
The inner query performs a dtml-sqltest on one of the variables returned and returns another set of variables. (Or at least it is supposed to.) The only variable that two queries share is the variable on which the inner query performs the dtml-sqltest.
The inner query gives me a key error, asking for a variable supplied by the outer query.
Strangely, the inner query works when nested within a query that returns a single record using the same dtml-sqltest as the inner query.
Any pointers on how to manage this?
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Donald Braman -
Paz -
Thomas B. Passin