[Zope-dev] ZPatterns: getItem returns None

Roch'e Compaan roche@ybm.co.za
Sat, 17 Mar 2001 15:04:02 +0200


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 wi=
th
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 thi=
s
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 =3D 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 =3D <dtml-sqlvar AllotmentArea_ID type=3Dstring>


Roch=E9