missing operator error

[Jollyfrog]

Hi i have some code

Please Login or Register  to view this content.

the idea being that if hd = false then it runs the 3d code and if the 3d = false it runs some other code...

i get an error when 3d = false, but not when hd = false
i assumed it was an issue with channel brand being incorrect, but this doesn't appear to be the case

whats wrong?

thanks

[romperstomper]

What error and on which line?

[Jollyfrog]

the error is:

Syntax error (missing operator) in query expression '3D'.

on the line

Please Login or Register  to view this content.

which is odd as the HD query performs fine

[romperstomper]

Enclose the 3D in square brackets.

[Jollyfrog]

ah i see! this works now! thankyou!

is this because of the use of a number?


thanks


Jonathan

[romperstomper]

Yes. In strict SQL, database object names should begin with a letter and only include letters, numbers or underscoress, but many db systems allow you to violate that. If you do, you should enclose the table in [] - in fact it's usually easier to just do that all the time.

[Jollyfrog]

ok thanks! i'll bear this in mind for future applications

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save