Error in search

D

D.Deveaux

Guest
Hi,

It seems that there's a problem in constructing search strings :

Testing search on table publis

case 1 fields : id,rpublia,rpublib -->pb

Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1

case 2 fields : id,rpublia --> ok

Your SQL query (for debugging purpose): select * from publis where rpublia = '0' limit 0 , 60
Aucun enregistrement trouvé.

case 3 fields : id, rpublia -> ok
Your SQL query (for debugging purpose): select * from publis where rpublia = '1' limit 0 , 60
157 Enregistrements trouvés

case 4 fields : id,rpublia-->pb

Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1

Please, how correct is the problem ?

Thank's

Danièle Deveaux
 
E

Eugenio

Guest
D.Deveaux wrote:
>
> Hi,
>
> It seems that there's a problem in constructing search
> strings :
[......]

> Please, how correct is the problem ?

Please give more details, wath's the difference between case 2-3-4?

(Latest version of DaDaBIK when this message was posted: 1.8)
 
Top