Re: [GRASS-user] db.select driver issue

2010-03-28 Thread Vincent Bain 
Richard, FYI the problem may be located at the driver level: with 'pg'
driver this query works fine.

Bye,
Vincent



Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit :
 In a previous thread, I mentioned trouble with Grass-GIS's database 
 driver on complex queries, but couldn't remember an example.
 
 I've bumped into one this morning. In MySQL, this query works fine:
 
 select sum(population) from australia
 
 in Grass-GIS:
 
 echo select sum(population) from Australia | db.select -c
 
 returns:
 
  DBMI-DBF driver error:
  SQL parser error: syntax error, unexpected '(', expecting FROM 
  processing '('
  in statement:
  select sum(population) from Australia
 
  Error in db_open_select_cursor()
 Richard
 ___
 grass-user mailing list
 grass-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/grass-user
 


___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

Re: [GRASS-user] db.select driver issue

2010-03-28 Thread Richard Chirgwin 

Micha Silver wrote:

On 03/28/2010 11:08 AM, Vincent Bain wrote:

Richard, FYI the problem may be located at the driver level: with 'pg'
driver this query works fine.

Bye,
Vincent



Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit :
  

In a previous thread, I mentioned trouble with Grass-GIS's database
driver on complex queries, but couldn't remember an example.

I've bumped into one this morning. In MySQL, this query works fine:

select sum(population) from australia

in Grass-GIS:

echo select sum(population) from Australia | db.select -c

returns:



DBMI-DBF driver error:
   

So is it a dbf driver or mysql?
db.connect -p??
Whack. I think the cluestick just hit me. I will double-check the 
connection and try again ...


RC



SQL parser error: syntax error, unexpected '(', expecting FROM
processing '('
in statement:
select sum(population) from Australia

Error in db_open_select_cursor()
   

Richard
___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

 


___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

This mail was received via Mail-SeCure System.


   





___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

[GRASS-user] db.select driver issue

2010-03-27 Thread Richard Chirgwin 
In a previous thread, I mentioned trouble with Grass-GIS's database 
driver on complex queries, but couldn't remember an example.


I've bumped into one this morning. In MySQL, this query works fine:

select sum(population) from australia

in Grass-GIS:

echo select sum(population) from Australia | db.select -c

returns:


DBMI-DBF driver error:
SQL parser error: syntax error, unexpected '(', expecting FROM 
processing '('

in statement:
select sum(population) from Australia

Error in db_open_select_cursor()

Richard
___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user