Michael Wang-Helmke writes:

have to look at all of the SQL methods. What I would like is some way to have a folder just for SQL methods that is below the root and some way to refer to this folder from anywhere below the root.

What I've done is have a top-level folder named 'sql', and put all the queries in it. So if retrieve_use is one query, you can call it with <!--#with sql--> <!--#in retrieve_user--> ... whatever ... <!--#/in--> <!--#/with--> I think <!--#in expr="sql.retrieve_user()"--> would work, too, though I haven't verified that. In an ExternalMethod that accepts a self argument, you can then refer to self.sql.retrieve_user(REQUEST=REQUEST, arg1=X, arg2=Y, ...). -- A.M. Kuchling http://starship.python.net/crew/amk/ I won't eat any cereal that doesn't turn the milk purple. -- Bill Watterson, _The Authoritative Calvin and Hobbes_