[ic] SQL Request problem
Xavier GILLET
interchange-users@icdevgroup.org
Mon May 12 15:36:00 2003
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
>