topic arcpy.select invalid sql statement in Python Questions

arcpy.select invalid sql statement

BobMCkay — Tue, 26 Feb 2013 19:00:01 GMT

Hi

The following script is giving a syntax errror on the arcpy.Select line.
I've tried various combinations of Quotes but I still get the invalid sql statement.
Any ideas?

# Import arcpy module
import arcpy
# Local variables:
PropertyNew = "M:\\GIS\\KMZ Irrigation East\\PropertyNew.shp"
OwnerPropertyShp = "M:\\GIS\\KMZ Irrigation East\\OwnerProperty.shp"
# Process: Select
arcpy.Select_analysis(PropertyNew, OwnerPropertyShp, "[PARCEL_SPI] = '2003\\PP2679'")

Traceback (most recent call last):
File "M:\GIS\KMZ Irrigation East\owner.py", line 19, in <module>
    arcpy.Select_analysis(PropertyNew, OwnerPropertyShp, "[PARCEL_SPI] = '2003\\PP2679'")
File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\analysis.py", line 88, in Select
    raise e
ExecuteError: ERROR 999999: Error executing function.
An invalid SQL statement was used.
An invalid SQL statement was used.
Failed to execute (Select).

Re: arcpy.select invalid sql statement

MathewCoyle — Tue, 26 Feb 2013 20:16:24 GMT

You are using personal geodatabase syntax on a shapefile. Try this.

""""PARCEL_SPI" = '2003\PP2679'"""

If you are still having issues try making your selection manually in ArcMap using select by attributes and copy the syntax that works there.

Re: arcpy.select invalid sql statement

BobMCkay — Tue, 26 Feb 2013 22:54:57 GMT

That worked fine. I thank you sincerely, but what does the deep imbedding in double quotes do? Can I also pass the string in as a Python argument i.e. how would I deal with all the quotes in a variable. Could I do something like
,""""&var1&''''''"). Once again many thanks

Re: arcpy.select invalid sql statement

MathewCoyle — Wed, 27 Feb 2013 12:18:08 GMT

The triple quotes ensure everything inside is a string so you don't have to use escape characters when you want to use multiple quotations inside your string. You can pass variables to it using standard string substitution just like any other string, though it wouldn't be necessary.

"""{0}""".format(some_variable)