topic How can I fix this SQL clause? in Python Questions

How can I fix this SQL clause?

rescobar — Mon, 23 Jan 2023 23:36:39 GMT

I have the following code which I'm trying to get to select a row by an input task number. It gives me an error, saying that I have an invalid sql clause. However, looking at the error message, I can't see what's invalid.

import arcpy, os from arcpy import env task = arcpy.GetParameterAsText(0) expression = "Task =" + " '" + task +"'" base_arpx = arcpy.mp.ArcGISProject(r"\\Projects_3\Fig_2_Pro.aprx") rows = arcpy.da.SearchCursor(r"\\Projects_3\location.gdb\Task_Project_Name_1", "Task; Name; shp_project_points; shp_buffer; workspace;", where_clause=expression)

Here is the error:

File "<string>", line 8, in <module> RuntimeError: An invalid SQL statement was used. [SELECT OBJECTID,Task; Name; shp_project_points; shp_buffer; workspace; FROM Task_Project_Name_1 WHERE Task = '590']

Re: How can I fix this SQL clause?

SteveCole — Mon, 23 Jan 2023 23:43:29 GMT

You use a comma after the first attribute field in the SQL query (OBJECTID) but then you switch to semi-colons. Try using all commas in your attribute field list inside the SQL query string.

Re: How can I fix this SQL clause?

JoshuaBixby — Mon, 23 Jan 2023 23:44:59 GMT

It isn't just a comma or semicolon issue, the SearchCursor takes a list of strings, not a string of delimited fields.

Re: How can I fix this SQL clause?

Luke_Pinner — Tue, 24 Jan 2023 04:30:24 GMT

Assuming "Task", "Name", "shp_project_points", "shp_buffer", "workspace" are all fields in your featureclass. As @JoshuaBixby notes, this parameter needs to be a list of field names, not a single string.

Change

"Task; Name; shp_project_points; shp_buffer; workspace;"

["Task", "Name", "shp_project_points", "shp_buffer", "workspace"]