[Zope] sql and zope-2.2

[Bak @ kedai]

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?