topic Re: Simple question in Geoprocessing Questions

Simple question

KarenSnitzer — Mon, 10 Nov 2014 13:44:29 GMT

New student here...

I am trying to select by attributes, but when I put in the query, no records are selected. I looked at one record in the table and there are multiple features under the tree. Can this be causing the problem? And how can I get around it?

Thanks.

Re: Simple question

TimWitt2 — Mon, 10 Nov 2014 13:56:25 GMT

Hi Karen,

Can you post your query here?

Tim

Re: Simple question

KarenSnitzer — Mon, 10 Nov 2014 14:27:16 GMT

When I selected each row manually from the attribute table and made it into a layer it worked.

Here is how I did the query tho for those attributes:

LANDCODE = '941' AND LANDCODE = '980' AND LANDCODE = '910' AND LANDCODE = '940' AND LANDCODE = '930' AND LANDCODE = '734'

I don't understand why it wouldn't do the same thing as selecting each row manually, tho. Can you explain?

Thanks!

Re: Simple question

KarenSnitzer — Mon, 10 Nov 2014 14:31:54 GMT

Re: Simple question

TimWitt2 — Mon, 10 Nov 2014 14:34:14 GMT

Karen,

instead of AND use OR. When you use AND it looks for a row that has all of the LANDCODE you specify in it.

With OR it selects each number.

Tim

Re: Simple question

StevenGraf1 — Mon, 10 Nov 2014 14:42:17 GMT

You could write your query as such also:

"LANDCODE" IN ('941', '980', '910', '940', '930', '734')

Here is a SQL Query Reference Guide.

Steven

Re: Simple question

KarenSnitzer — Mon, 10 Nov 2014 15:21:56 GMT

Thanks!! I'll try both methods!

Karen