[ic] SQL Request problem

[Xavier GILLET]

Please forget this request.

I just found the problem.
code_postal IN (03000,03033,03100,03120,03150)
must be :
code_postal IN ('03000','03033','03100','03120','03150')

Sorry.

Xavier


----- Original Message ----- 
From: "Xavier GILLET" <xavier.gillet.perso@wanadoo.fr>
To: <interchange-users@icdevgroup.org>
Sent: Monday, May 12, 2003 9:28 PM
Subject: [ic] SQL Request problem


> 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)
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>