[Gvsig_english] Sql language in the shapefile filter

[Marcus C. England]

Hi,

I have a similar question... I can not get sql restriction to work. For 
example, I have a postgis database layer called "california_counties". 
This layer has an attribute column called "county" with the county 
names. In other programs I can load Los Angeles County only by using the 
sql statement:

county = 'Los Angeles County'

This does not work in gvSIG however. I always get a box that says:

"syntax error at or near "=""

I can't figure out what the problem is and I am hoping someone can help.

-Marcus


silvio grosso wrote:
> Hello everybody, 
>
> I am wondering if is it possible to write some simple query in the filter using the SQL language?
>
> I read gvSIG's manual but I didn't find any example about that.
> At present , to select an area I should write: TOPONIMO = 'ASTI' in order to get the selection.
> Nevertheless, in some cases SQL language is faster.
> For example, when I want to select  two areas in a shapefileI am obliged to write two times the word TOPONIMO (e.g TOPONIMO = 'ASTI' or TOPONIMO =  'Aglie'). 
> When I want to select four or more TOPONIMOS in the filter it becomes complicated.
>
> Best regards
>
> Silvio
>
>
>       ___________________________________ 
> Scopri il Blog di Yahoo! Mail: trucchi, novità, consigli... e la tua opinione!
> http://www.ymailblogit.com/blog/
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
>