[ic] SQL Request problem

Xavier GILLET interchange-users@icdevgroup.org
Mon May 12 15:29:00 2003


Hello,

What is wrong in this SQL request ?
Copy of the error log :

> Query was: select code_postal, count(pieces) as count from a01b02c01
>  where
>  initial_status = 'confirmee'
>  and
>  actual_status = 'En ligne'
>  and
>  sens = 'Vente'
>  and
>  departement = '03'
>  and
>  prix < '9999999999999'
>  and
>  prix > '0'
>  and
>  type_vendeur IN ('particulier','agence')
>  and
>  code_postal IN (03000,03033,03100,03120,03150) at
/home/edolia/ic/lib/Vend/Table/DBI.pm line 1888
>
> Query was: select code_postal, count(pieces) as count from a01b02c01
>  where
>  initial_status = 'confirmee'
>  and
>  actual_status = 'En ligne'
>  and
>  sens = 'Vente'
>  and
>  departement = '03'
>  and
>  prix < '9999999999999'
>  and
>  prix > '0'
>  and
>  type_vendeur IN ('particulier','agence')
>  and
>  code_postal IN (03000,03033,03100,03120,03150)