[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:

join\
    create_method
    join_sql_methods\
util\
    util_sql_methods\

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

and

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

Any ideas on why this happens??

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  
==================================================================