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
_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
