12 May
2005
12 May
'05
8:44 a.m.
On Thu, 12 May 2005, Gordon Heydon wrote:
db_query('UPDATE {ec_ad_team} at LEFT JOIN {ec_transaction} t ON at.txnid = t.txnid SET at.did = %d WHERE t.workflow = %d and at.did = 0', $did, 6);
The problem is that for some reason the on my clients mysql server doesn't seem to do the update, can anyone give me a reason why this would be happening, and a possible method of resolving this.
UPDATE does not support JOINs according to the mysql manual. Cheers, Gerhard