topic Re: set order on multiple fields in Python Questions

set order on multiple fields

TerrySilveus — Wed, 20 Apr 2011 17:00:19 GMT

I'm doing this

rows = arcpy.UpdateCursor("c:/gis/temp.shp","","","","POINT_X A, POINT_Y A")

I want to sort on both POINT_X and POINT_Y fields, but it doesn't seem to be working. Can someone let me know how to sort on multiple fields in a cursor?

Re: set order on multiple fields

ChrisSnyder — Wed, 20 Apr 2011 17:15:37 GMT

Try this:

rows = arcpy.UpdateCursor("c:/gis/temp.shp","","","", "POINT_X A; POINT_Y A")

The correct sort field parameter delimiter is a ; and you were using a ,

Re: set order on multiple fields

TerrySilveus — Wed, 20 Apr 2011 18:08:25 GMT

Try this:

rows = arcpy.UpdateCursor("c:/gis/temp.shp","","","", "POINT_X A; POINT_Y A")

The correct sort field parameter delimiter is a ; and you were using a ,

That did it. Thanks so much.

Re: set order on multiple fields

DonnaBest — Thu, 19 May 2011 12:27:11 GMT

I need to sort on multiple fields in vb.net. Any ideas?

Thank you!

Re: set order on multiple fields

TerrySilveus — Thu, 19 May 2011 16:25:15 GMT

I need to sort on multiple fields in vb.net. Any ideas?

Thank you!

In a vba (from access experience not sure how it would be in arcMap) sql statement you just use commas between fields

SELECT ... FROM ... WHERE ... ORDER BY field1, field2 ...

not sure about vb.net