Dieter, Thanks for your reply. Direct Traversal is very limited - it works only for ZSQL method that returns one record. It is just a hack It returns a Record object, not even a Results: query/1 and query?ID=1 return diffent things. I could probably attach a Brain to a ZSQL method to merge data but I think that would be solving th problem from the wrong angle. The solution I am looking for would make data in the Zope Folder and data in the database (or other source) appear in the same way to ZMI and to scripts. Igor -----Original Message----- From: Dieter Maurer Sent: Tue 7/23/2002 5:46 PM To: Elbert, Igor Cc: zope@zope.org Subject: Re: [Zope] Data-Aware Folder Igor Elbert writes: > ... > Problem: > ... > Now let's say that some data is stored in DBMS or other place outside the > ZODB. We know how to get it (e.g. ZSQL) but Zope mechanics would not work > anymore. I would have to say http://localhost/Org/Address/get?org_id=ENRON > or http://localhost/Org/Contact/Address/get?org_id=ENRON&contact_id=Smith > since "ENRON" and "Smith" are now just the values in the database. Which is > not bad except I loose many of Zope's nice features: acquisition for once. Look at "Direct Traversal" (of ZSQL methods). I think, you find something in the Zope Book. If not, look at the "Advanced" tab of ZSQL methods. Dieter