hi all, i managed to upgrade my site from 2.1.6 to 2.2b1 with no problems (thanks Brian) but now, something else cropped up. what used to work on my 2.1.6 doesn't anymore. following are the sql snippets and tracebacks --show_subtree_index <dtml-in "qry_msg_thread(_.None,_,par_id=obj_id)"> <font size="-1"><a class="root-msg" href="view_msg_html?obj_id=<dtml-var obj_id>" target="main"> - <dtml-var username></a></font> </dtml-in> --- my sqlmethod select * from msg where par_id=<dtml-sqlvar obj_id type=int> --- and the traceback --- Traceback (innermost last): File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/kdie/Zope-2.2.0b1-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: index_html) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 611, in renderwb (Object: qry_msgs_by_par_id(par_id=0)) File /home/kdie/Zope-2.2.0b1-src/lib/python/OFS/DTMLMethod.py, line 164, in __call__ (Object: show_subtree_index) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: show_subtree_index) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: qry_msg_thread(_.None,_,par_id=obj_id)) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_Util.py, line 339, in eval (Object: qry_msg_thread(_.None,_,par_id=obj_id)) (Info: qry_msg_thread) File <string>, line 0, in ? File /home/kdie/Zope-2.2.0b1-src/lib/python/Shared/DC/ZRDB/DA.py, line 444, in __call__ (Object: qry_msg_thread) File /home/kdie/Zope-2.2.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 500, in __call__ (Object: <string>) File /home/kdie/Zope-2.2.0b1-src/lib/python/Shared/DC/ZRDB/sqlvar.py, line 168, in render (Object: obj_id) Missing Input: (see above) -- i tried encapsulating the dtml method with <dtml-with REQUEST> just in case, but still no go. any help appreciated -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?