topic Re: What is wrong with my where statement syntax in Python Questions

What is wrong with my where statement syntax

TravisPreston2 — Wed, 05 Oct 2016 15:31:11 GMT

I keep getting an error at line 22 of my code. It is telling me there is something wrong with my syntax. I have tried it a few different ways but have not been able to figure it out. Can anyone help?

Re: What is wrong with my where statement syntax

RebeccaStrauch__GISP — Wed, 05 Oct 2016 15:54:41 GMT

Look at your line 20.

arcpy.Select_analysis("Locations_lyr"),\

Maybe you wanted to comment that out? The syntax in that line is incorrect.

BTW - to post python code, you can use the syntax highlighter and select python. when commenting, this is found in the ...More pulldown.

Re: What is wrong with my where statement syntax

RandyBurton — Sat, 11 Dec 2021 14:33:03 GMT

I see a couple of things. First, do not use closed parenthesis on line 20. Use indentation for the command. Since the command variables are in parenthesis, there is no need for a backslash. And line 22 syntax is incorrect.

arcpy.Select_analysis("Locations_lyr",
     r"M:\NRD_Maps\etc",
     '"Marker" = "' + sitename + '"')
‍‍‍‍‍‍‍

Lines 23-25 and 28-29 should also use indentation.

Edit -

Perhaps line 22 should be like this:

'\'"Marker" = \\\'' + sitename + '\\\'\''‍

There is some discussion on this command here regarding the where clause.

Re: What is wrong with my where statement syntax

DanPatterson_Retired — Wed, 05 Oct 2016 17:29:46 GMT

On a peripheral note, you would be advised to locate your work in a shorter path structure since there are acceptable limits for certain data types and the error message returned has nothing to do with the length of the path, severely restricting one's ability to track down errors.