Hi Thomas: However, wouldn't that defeat the purpose of sqltest? I mean, precisely I want to be able to only set one (ticker, company_name, etc.), or none, and have sqltest evaluate them, and ignore the ones not set, or that do not exist, and then, have it dynamically create my query based on the one that do exists and is set. BTW, I used David's suggestion, and that seems to have improved things, as the logic now at least works in the 'test' mode, but I am still not getting it to work with the rest of the code, but there might be some other thing I may have missed there. Thanks for the tips, Jorge M. Thomas B. Passin wrote:
industry_group is supposed to be a variable known to the Zope namespace. If this variable doe snot exist, you would get the error you quote. Make sure you have created the variable and assigned it a value.
Cheers,
Tom P
[Jorge O. Martinez]
Not sure if this is a DB question, or DTML question, so I'm sending it to
the
general Zope list.
I've been banging my head over this relatively simple query, which (if my understanding of the dtml-sqltest tag is correct), should be fine. The
idea is
simple, get 3 columns from company_index, and display the results, if
there's
further constrains set (like ticker, company_name, etc.), taylor the query accordingly:
select company_name,ticker,primary_exchange from company_index <dtml-sqlgroup where> <dtml-sqltest ticker op=eq type=nb> <dtml-sqltest company_name op=like type=nb> <dtml-sqltest industry_group op=eq type=nb> <dtml-sqltest industry_subgroup op=eq type=nb> <dtml-sqltest market_cap op=eq type=nb> <dtml-sqltest market_sector op=eq type=nb> <dtml-sqltest primary_exchange op=eq type=nb> </dtml-sqlgroup>
but it's not happy. It keeps displaying errors like this:
*************
Zope has encountered an error while publishing this resource.
Error Type: KeyError Error Value: industry_group
_______________________________________________ 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 )
-- Jorge O. Martinez MIS Senior Associate eMediaMillWorks 1100 Mercantile Lane, Suite 119 Largo, MD 20774 E-mail => jmartinez@eMediaMillWorks.com Phone => (301)883-2482 ext. 105 Fax => (301)883-9754