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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.