Matys Łukasz pisze:

Zrobilem tak: {result = SELECT customers.id FROM `customers` LEFT JOIN assignments ON customers.id = customerid WHERE deleted =0 AND STATUS =3 AND (customerid IS NULL)}\ {for (r=0; r<number(result); r++)}\ {result[r].customerid} {/for}\

Popraw na: {result = SELECT customers.id AS costam FROM customers LEFT JOIN assignments ON customers.id = customerid WHERE deleted =0 AND STATUS =3 AND (customerid IS NULL)}\ {for (r=0; r<number(result); r++)}\ {result[r].costam} {/for}\

i bedzie ok:P pozdrawiam;

-- Andrzej Banach

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms