nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Running a for loop over an empty cursor

StormwaterWater_Resources

ArcStandard 10.1

I have the following snippet in my script (with an intentionally empty cursor via where-clause):

271    rows = arcpy.da.SearchCursor(fc, Fields, "1=2") 272    arcpy.AddMessage(str(rows)) 273    arcpy.AddMessage("Before") 274    for row in rows: 275        arcpy.AddMessage("In")

When I run it I get this:

Running script UpDownTest... <da.SearchCursor object at 0x1758E700> Before  Traceback (most recent call last):   File "C:\Projects\UpstreamDownstream\UpDownStorm.py", line 274, in <module>     for row in rows: RuntimeError: A column was specified that does not exist.  Failed to execute (UpDownTest).

I'd thought before I started debugging that maybe I had a field name misspelled, but from printing the cursor I can see that an object is returned (though we know it's an empty cursor), and I can see I'm printing text after the cursor is created. Thus it seems like the error really is in the for loop. I can't figure out what's wrong here. Shouldn't the for loop just be passed over? Any suggestions?

Finde mehr Beiträge mit dem Tag

Accepted answers

MathewCoyle

Check your field names held by your Fields list variable again. Print out rows.fields to make sure.

All comments

curtvprice

On a different topic, do you know how to change the thread icon from a red 'Q' to a green 'A'?

This happens then you check a post as your answer by setting the big checkmark.

Or better how to delete a thread entirely?

Only the uber-moderators can do this. This thread is likely here forever.

StormwaterWater_Resources

Check your field names held by your Fields list variable again. Print out rows.fields to make sure.

Sure enough, programmer error, but that was a particularly obscure typo (which has existed undetected in my table for months). I also would have thought that the updateCursor call would have been where it choked because that's where I first provide the invalid field name. I guess then the default is to ignore fields it can't find.

On a different topic, do you know how to change the thread icon from a red 'Q' to a green 'A'? Or better how to delete a thread entirely?

MathewCoyle

Check your field names held by your Fields list variable again. Print out rows.fields to make sure.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.