[Zope] stuck on accessing ZSQL methods across folder hierary

[Brad Allen]

I'm stuck trying to do something fairly basic with DTML: access an 
SQL method called previewsStagingList that is somewhere else in the 
folder hierarchy. I've tried numerous variant possibilities, such as

<dtml-in kc/bizlogic/product/diamond/previewsStagingList>

  or

<dtml-in kc.bizlogic.product.diamond.previewsStagingList>

or

<dtml-in "../bizlogic/product/diamond/previewsStagingList">

or

<dtml-in expr = "kc.bizlogic.product.diamond.previewsStagingList">
    (I think expr is just for Python scripts, according to the 
documentation I've seen, but I thought this worth a try.)


You get the idea. I've searched around for documentation on how to do 
this, and the closest thing I came up with was to use dtml-with, but 
had no luck with that either since dtml-with doesn't seem to accept 
any kind of folder paths. I tried nesting several dtml-with 
documents, which parsed ok but still didn't allow me to access the 
previewsStagingList ZSQL method.

I'm stuck. Please help!

Thanks!