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 )