0

I have a code in which I'd like a da.UpdateCursor, I have probles with the "where clause", here I am about to use a variable that I get from arcpy.Describe. I have no idea of this even possible. My code is:

    newValue =  arcpy.GetParameterAsText(0)    
    inlyrdsc = arcpy.Describe("layertoedit")
    inFID = inlyrdsc.FIDset
    num = inFID.split("; ")

    inlayer = arcpy.mapping.Layer("layertoedit")
    query = "[OBJECTID] = %s", (num)
    fieldName = "fieldtoupdate"
    with arcpy.da.UpdateCursor(inlayer, (fieldName,), query) as cursor:
        for row in cursor:
            row[0] = newValue
            cursor.updateRow(row)

I get the following error message:

TypeError: 'where_clause' is not a string

Anyways my goal is to write a script which fills the attribute table of the selected element (the selection is described by the OBJECTID). This might not be the best solution so any ideas are welcomed.

Improve this question
2
  • The code that you are presenting does not seem to be the same code run to produce the error because it is missing any setting of the where_clause variable. Commented Sep 28, 2015 at 10:08
  • 1
    Please remember to always include the feature class data source in your question, since different sources may have different SQL expression syntaxes. You should also use Data Access (da) cursors for all ArcGIS versions after 10.1. Commented Sep 28, 2015 at 10:29

1 Answer 1

Reset to default
1

num = inFID.split("; ") generates a python list. You maybe able to leave inFid ( a string of OIDs ) as is and use a query like query = "[OBJECTID] IN '{}'".format(inFid) Or instead of using an update cursor, just use CalculateField to set your new value on the selected set.

Improve this answer
1
  • thanks for showing me the simplier way, CalculateField works fine. :) Commented Sep 28, 2015 at 10:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.