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(a)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.
