[Zope] strange sql problem

Aseem Mohanty aseem@neurobehavioralsystems.com
Wed, 26 Jun 2002 00:38:54 -0700

Hi all,
I have the following directory structure:


Now I have a simple sql method A that reads in a value in a db table TB.

In create_method I call a sql method B in join_sql_methods which creates 
a record in the table TB. In the same method after the call to create 
(B) I call the above mentioned sql method (A) to read off the value from 
the newly created record.

The problem is if I place A in join_sql_methods it works perfectly and 
returns me the relevant data item. However if I place A in 
util_sql_methods it returns an empty result set.

My DTML method looks like

<dtml-call "B">
<dtml-call "join_sql_methods.A"> in the former case


<dtml-call "B">
<dtml-call "util.util_sql_methods.A"> in the latter case.

Any ideas on why this happens??


 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