I think I've read everything on the mailing lists on this issue, but have
found no joy.

I have a ZClass derived dataskin called AllotmentArea matching a table with
the same name in my SQL RDBMS.

I have a Specialist called AllotmentAreas with storage set to the
AllotmentArea ZClass and load attribute set to "AllotmentArea_ID" and this
property does not exist on the ZClass propertysheet.

When I call getItem(<existing_id>) on the specialist, it returns None.

SkinScript for retrieval:
        WITH QUERY sqlGetAllotmentArea(AllotmentArea_ID = self.id) COMPUTE
AllotmentArea_ID, AreaName, AreaCode

        Note: The Proxy Role for the SkinScript is set to Manager.

sqlGetAllotmentArea:
        Select * from AllotmentArea
        where AllotmentArea_ID = <dtml-sqlvar AllotmentArea_ID type=string>


Roché


_______________________________________________
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 )

Reply via email to