2. PHPRunner General questions
  3. [SOLVED] WHERE expression in lookup wizard
This topic is locked
[SOLVED]

WHERE expression in lookup wizard

 		9/4/2024 4:30:53 PM
PHPRunner General questions
francesco author

In lookup wizard I want to give two where conditions:
attivo = 1 AND mansione <> 'ufficio'
but only the first one works. Is it a syntax error?

img alt

Davor GeciDevClub member 9/5/2024

I have tried with

Type1=1 AND Type2=3

and it works.
Did you test it directly on the database?

img alt

francesco author 9/5/2024

thanks for help, testing on database I found it was a wrong SQL statement