[ic] database transactions problem in log_transaction
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?
More information about the interchange-users