I create a zsql method in 2.2b4, using the test tab the zsql method works ok. The problem is when I use a dtml method or document (executable objects) to call the zsql method with a IN statment, a not authorized browser box appears. I'm aware of the ownership changes but on my port I'm having this problems only with zsql methods so I wonder if this is only related with this product before diving into the ownership issues.
Julio - I can't reproduce this here (using the Gadfly db connection and DTML that looks like: <dtml-in getdata> <dtml-var item_id>, <dtml-var item_name>, <dtml-var item_desc> <br> </dtml-in> Can you tell me: o What db connection you are using o What the dtml of your <in> statement looks like o the permissions on the DTML method, the DB connection and the SQLMethod you are calling o and the ownership settings of each of the above? Thanks! Brian Lloyd brian@digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com