I may have found a bug in d.m. However, I may not be issuing the sql
statement properly in d.m. For example If issue the following
command on the command line:
d.vect test fcolor=none where="type='JAPI'"
the expected polygons are displayed.
However, in d.m, if I type in the SQL where statement field:
"type = 'JAPI'"
which I believe is the same command minus the (where=) that worked
on the command line, no vectors are displayed. Console output is as
follows:
Sorry for taking so long in response.
On Mar 6, 2006, at 3:34 PM, Maciek Sieczka via RT wrote:
Kirk wrote:
I may have found a bug in d.m. However, I may not be issuing the sql
statement properly in d.m. For example If issue the following
command on the command line:
d.vect test fcolor=none where="type='JAPI'"
the expected polygons are displayed.
However, in d.m, if I type in the SQL where statement field:
"type = 'JAPI'"
which I believe is the same command minus the (where=) that worked
on the command line, no vectors are displayed. Console output is as
follows:
Sorry for taking so long in response.
On Mar 6, 2006, at 3:34 PM, Maciek Sieczka via RT wrote:
Kirk wrote:
I may have found a bug in d.m. However, I may not be issuing the sql
statement properly in d.m. For example If issue the following
command on the command line:
d.vect test fcolor=none where="type='JAPI'"
the expected polygons are displayed.
However, in d.m, if I type in the SQL where statement field:
"type = 'JAPI'"
which I believe is the same command minus the (where=) that worked
on the command line, no vectors are displayed. Console output is as
follows:
Text-string matching requires the text part to be ‘single quoted’ and multiple queries should be contained in “double quotes”. e.g.
d.vect map where=“individual=‘juvenile’ and area=‘beach’”
As far as I know, type=‘JAPI’ and ‘SP’ is not standard SQL.
Text-string matching requires the text part to be 'single quoted' and multiple queries should be contained in "double quotes". e.g.
d.vect map where="individual='juvenile' and area='beach'"
The quoting issue is a different one from the fact that [type='JAPI' and 'SP'] is invalid as you have to repeat the field/column name.
As was already hinted at by others, the quoting rules in the documentation target the command line. Quoting is handled differently in the GUI interface.
So in the command line, you would have to type:
where="type='JAPI' and type='SP'"
but in the GUI you put
type='JAPI' and type='SP'
into the "where" text field.
As far as I know, type='JAPI' and 'SP' is not standard SQL.
> My understanding from examples in the docs
> (http://grass.itc.it/grass61/manuals/html61_user/sql.html) is that
> the use of double quotes to allow more than one query run in a
> single statment. Am I wrong on this?
>
> Text-string matching requires the text part to be 'single quoted'
> and multiple queries should be contained in "double quotes". e.g.
> d.vect map where="individual='juvenile' and area='beach'"
The quoting issue is a different one from the fact that [type='JAPI'
and 'SP'] is invalid as you have to repeat the field/column name.
As was already hinted at by others, the quoting rules in the
documentation target the command line. Quoting is handled differently
in the GUI interface.
I have updated the help page to clarify that you only need the double
quotes when specifying the query from the command line.