[Zope] ZSQL Method question

[Aseem Mohanty]

Is it possible to run a SELECT query (just one - as per doc) in a ZSQL 
Method and then use the results of that to run a INSERT query in the 
"same" ZSQL method... If yes how do I access the result of the select??

I am just trying to get around the lack of sub-queries in MySQL. and 
dont really want to set up a ZSQL method for each query/insert and then 
use another method to bring them all together.

However if there is another way to do the whole thing.......I would be 
immensely grateful for any pointers in that direction.

TIA
AM

-- 
==================================================================
 Aseem Mohanty							   
 Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 
 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231		  	
==================================================================								  	
 "I saw `cout' being shifted "Hello world" times to the left and  
  stopped right there!!"                        -- Steve Gonedes  
==================================================================