Hi Tim, I did exactly as you told me to do. The following is the python script

sql="Select * from LinkArea" results = container.sql_method(the_sql=sql) for i in results: print i return printed

and below is the ZSQL method: <dtml-var the_sql>

when i do this, it gives me the instances, something like this.. <r instance at 01674978> <r instance at 015DAED0> <r instance at 01674978> <r instance at 015DAED0>

I do not understand this.

ZSQL methods return special objects ('pluggable brains' I believe they are called - I'm sure someone will correct me if I'm wrong). Try this to see how to use them from python scripts (dtml docs/methods have some magic that makes it easy transparent)... ------- sql="Select * from LinkArea" results = container.sql_method(the_sql=sql) headings = results.names() # names() gives you the column headings print headings for row in results: for heading in headings: print row[heading] return printed -------- There's also a dictionaries() method on the result object that is very helpful. I know there are more posts on this in the list archives as well. hth tim