Sum of a CASE Expression

2001-03-08 Thread Phil Daintree
ns WHERE DebtorTrans.DebtorNo = 'CARLYL' MySQL said: You have an error in your SQL syntax near 'WHEN (TO_DAYS(Now()) - TO_DAYS(DebtorTrans.TranDate)) >= 10 THEN DebtorTrans.Ov' at line 2 TIA Phil Daintree ---

Innobase

2001-02-27 Thread Phil Daintree
server side cursors? Reducing network overhead. Regards Phil Daintree - Dux Industries Ph:+64 (04) 567 8900 Fax: +64 (04) 567 8904 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Transaction Issues

2001-02-13 Thread Phil Daintree
ience with them. Phil Daintree - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC