SQL Query

Question

Hi!

I ve problems with a sql expression. I want to select one row of a 1st lyr file attribute table in order to only select those features from a2nd lyr file intersecting with the 1lyr selected feature.
I tried all kind of expressions: "" ,"/", etc. but it keeps telling me either the expression is wrong or it doesn't make any selection. Any ideas?
Thi is the part of code keeping troubleing me
rows = arcpy.SearchCursor(MU)
for row in rows:
    x=row.OBJECTID
    whereClause="[OBJECTID] = "+str(x)
    arcpy.SelectLayerByAttribute_management (lyrFile, "NEW_SELECTION", whereClause)
    arcpy.SelectLayerByLocation_management(lyrFile2, "intersect", selectFeatures)

KimOllivier · Answer

Intellisense works just fine in PythonWin while coding if you first import arcpy in the Interactive Window. No need to go to some other IDE.

import arcpy will check out a licence but it will make Pythonwin aware of the module.
If you only have an arcview licence, then import arcview

You can also then browse the arcpy module from Menu>Tools>Browser> arcpy
instead of the default __builtins__

However I still find the commentary in the ArcGIS help more useful.

DarrenWiens2 · Answer

I might be mistaken, but I believe SQL requires strings to be enclosed in escaped single quotes (\'). So, your query would be:whereClause="[OBJECTID] = \'" + str(x) + "\'"

chriss_ · Answer

Hi!

Thanks to both of you.
Finally I discovered that it was not my SQL Query that didnt work. The problem lies within the "arcpy.SelectLayerByLocation_management" i couldnt get it to work so i changed to "Intersect_analysis" what is better anyhow.

@kimo
I really appreciate debugging advice. Normally for coding, I use the standard python window that comes with python. But compared to typing directly in the arcgis python window i get less "advice". By "advice" i mean arcgis python automatically pops up a list with functions or wahtever i can enter at this point. e.g. i type "arcpy." and then it pops up all functions arcpy has. in the standard python window it doesnt. Where do you write your code? Any tipps are highly appreciated.

Thanks