Re: [lms] Odlaczanie klientow bez taryf a zapytanie sql

18 Paź 2007


      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