[ODBC Microsoft Access Driver] Syntax error (missing operator) 2

[CombatKing]

Hello everyone,

I am having problems with a query - I have successfully connected a PHP front end to an Access database, but the following query keeps causing an issue:

SELECT * FROM fault WHERE Started != 'no' && Deferred = 'no' && Complete = 'no'

The error message is:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Started != 'no' && Deferred = 'no' && Complete = 'no''.

The table "fault" exists, and the columns "Started", "Deferred" and "Complete" all exist within the "fault" table.

The query works fine when I send it to an equivalent MySQL database, so I'm also wondering if there is a key difference between MySQL and the version of SQL used by ODBC/Access?

 

[maxhugen]

Try:

SELECT * FROM fault WHERE Started != 'no' [red]AND[/red] Deferred = 'no' [red]AND[/red] Complete = 'no'

Max Hugen
Australia

 

[Remou]

In Access, the SQL would be something like:

[tt]SELECT * FROM fault WHERE Started = 'no' AND Deferred = 'no' AND Complete = 'no'[/tt]

 

[maxhugen]

Oh, missed something... the php operator != is <> in Access.

SELECT * FROM fault WHERE Started <> 'no' AND Deferred = 'no' AND Complete = 'no'

Max Hugen
Australia

 

[CombatKing]

Thank you maxhugen and Remou - I should have realised any MS version of any technology uses a syntax similar to VB instead of C.

I'll bear this in mind in future.

Thank you again for your help.

 

[JoeAtWork]

Actually, the syntax is similar to SQL, since it's, well, SQL.

It is your original SQL statement that is not ANSI compliant. The || operator in ANSI SQL is for concatenation.

 

[CombatKing]

Ah,

I'd best get the books out again

 

[maxhugen]

Tip: if you're not quite up to speed on SQL syntax, try using the MS Access graphical Query builder, then switch to SQL view to see the syntax.

Max Hugen
Australia