[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)