Mike, this is not a task for zpt but for a python script. I would suggest you write a script that gets all courses with a given db-state and check them to be in the corresponding workflow state. If not change the workflow state. this script you call regularly (daily, hourly, when ever the db has changed ..) Robert Takahashi, Michael wrote:
Hi guys,
I am running on Zope 2.7.6 with Plone 2.0.5. I am currently building a dynamic application using MySQL as the backend database. I'd like to be able to change a ZPT's state based on a parameter passed by the db.
For example, I have a ZPT that displays information for a particular course. However, if this courses "active" field is set to NO, then I would like to be able to have the ZPT's state be visible. If the courses "active" field is set to "yes" then I would like to modify the state so that the ZPT is published.
I'm thinking I'd probably have to use the wf_tool in conjunction with portal_workflow? A call similar to something like so:
tal:condition="python:records.active=='yes'" ...then implement the necessary call to modify the workflow and make the ZPT published and vice versa.
Any help is greatly appreciated.
Thanks,
Mike
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )