[ic] database transactions problem in log_transaction

david yee iamyee at gmail.com
Wed Jun 29 18:58:07 EDT 2005


> david yee wrote:
>>
>> UPDATE transactions SET value='0' WHERE username LIKE '$username'  
>> AND  hold = 1;

ok, sort of solved. there were two problems here. first, there was a  
stupid error in my SQL statement, which i was too tired to see. i  
apologize for wasting everyone's time.

but second, i used the [query] tag, rather than the perl $Db object.  
this now becomes an academic question of sorts: why was i unable to  
use perl's $Db object to accomplish this query (or any query--SELECT  
or UPDATE) in log_transaction--which is distinguished only in its  
role as part of an order route--on a table that has been marked as a  
TRANSACTION_TABLE?  make sense?

david


More information about the interchange-users mailing list