[Zope-dev] ZSQL method - Can it 'resolve' a property value?

Schmidt, Allen J. aschmidt@nv.cc.va.us
Wed, 24 Jan 2001 10:00:09 -0500


I have an index_html which runs queries that count the number of items in a
category and displays the number next to each category which is a link to
the SearchResults page that will pass the name of the property to the next
query. This is how I do the count part:

(<dtml-in countAnnouncements><dtml-var announcements null=""></dtml-in>)

I have a sql method for each count query and each uses a property (like
announcements above) that contains a list of numbers (i.e. Announcements
has: '001','002','003','004' )
So the query does a WHERE category IN ('001','002','003','004') statement by
resolving the property and getting the list of numbers. This part works
well.

Now,...
When I try to do the same thing on the SearchResults page, using a new sql
method, I cannot get the property to resolve. I try using an attribute of
the category for testing so it prompts for the category name when I test it.
I use the MULTIPLE attribute with a DTML-SQLTEST to produce the "WHERE IN"
type of query. I type in the name of the property that contains the list of
numbers and all I get for the query is: .... WHERE category =
('nameOfProperty')....

This makes less sense as I am describing it, but it may be clear to someone.


Thanks

Allen