Hi,
Saturday, April 3, 2004, 6:48:52 PM, you wrote:
ALEC> zdaje się, że to moje przeoczenie, zmień to zapytanie na:
ALEC> SELECT users.id AS id, lastname, name, email, phone1, SUM((type * -2 + 7) * ALEC> cash.value) AS balance FROM users LEFT JOIN cash ON users.id = cash.userid ALEC> GROUP BY users.id, lastname, name, email, phone1 HAVING SUM((type * -2 + 7) ALEC> * cash.value) < 0
Super, pomogło, ale:
# /usr/sbin/lms-notify lms-notify, version 1.2-cvs (C) 2001-2004 LMS Developers Using file /etc/lms/lms.ini as config. 10 (-70.00) <Nazwisko Imie> Sending e-mail to adresat@serwer.pl DBD::Pg::st execute failed: ERROR: LIMIT #,# syntax is not supported at /usr/sbin/lms-notify line 257. DBD::Pg::st execute failed: ERROR: LIMIT #,# syntax is not supported at /usr/sbin/lms-notify line 257. Database handle destroyed without explicit disconnect.
a z tym co zrobić?
-- g.