[Qgis-user] Selecting features in attribute table using query builder

Micha Silver micha at arava.co.il
Thu Oct 1 08:46:10 PDT 2009


Zane Selvans wrote:

> Hi all,
>
> I'm trying to select a subset of the features in a layer based on some
> values in their attribute table, and I keep getting the following
> error:
>
> syntax error, unexpected COLUMN_REF
>
>
> The where clause I'm using is:
>
> 2_LIN_ID < 1_LIN_ID
>
>   
Just a shot in the dark: Can column names begin with a digit? You might 
need to change to LIN_ID_1 and LIN_ID_2
-- 
Micha
> each of 2_LIN_ID and 1_LIN_ID are the names of fields (columns) in the
> attribute table.  They contain integers.  The layer is a collection of
> points, representing the intersections between some lines I digitized,
> and those fields are the IDs of the lines.
>
> Am I just doing something stupid, or is there brokenness here?
>
> Thanks for any insight,
> Zane
>
>   




More information about the Qgis-user mailing list