topic Re: working with string variables in a FeaturClass in Geoprocessing Questions

working with string variables in a FeaturClass

Jose_LuisGarcinuno-Oporto — Fri, 13 Aug 2010 03:08:03 GMT

I am trying to create a variable to be used in the select statement. So far, this is the code that I have right now.
rows1 = gp.SearchCursor(a + "copySelect1")
        row1 = rows1.Next()
        while row1 <> None:
           road = row1.Getvalue("ROADNAME")
           print road

           # Process: Select...the next line of code works, so the challenge is How to incorporate road variable here, to replace 'RD-300', it is in square brakets because it is a FeaturClass in a GeoDataset, I know how to works with shapefiles but this is not the case.
           gp.Select_analysis(a + "copySelect1", "Rclip" + a + "Select", "[ROADNAME] = 'RD-300'")

           gp.Select_analysis(a + "copySelect1", "Rclip" + a + "Select", "'[ROADNAME] = + str(road)), my problems are the double quotes, road variable is a string variable, what happen if it is integer?
Thanks in advance

Re: working with string variables in a FeaturClass

ChrisMathers — Fri, 13 Aug 2010 11:46:57 GMT

You dont want to make the change directly in the tool inputs. Make the string before and just drop it in as a variable.

query="[ROADNAME] = '"+road+"'"
gp.Select_analysis(a + "copySelect1", "Rclip" + a + "Select", query)

Re: working with string variables in a FeaturClass

Jose_LuisGarcinuno-Oporto — Fri, 13 Aug 2010 14:35:08 GMT

Thanks a lot Chris, its work perfectly, I really appreciate your time.