set order on multiple fields

Question

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?

TerrySilveus · Answer

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

DonnaBest · Answer

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

Thank you!

TerrySilveus · Answer

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.