[GRASSLIST:128] Re: Creating vector from MySQL database (GRASS 6.1)

[Stephan Holl]

Hello Rainer,

On Wed, 15 Mar 2006 12:22:22 +0200 Rainer M Krug <rkrug at sun.ac.za>
wrote:

> When I execute
> 
> v.in.db driver=mysql
> database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
> table=def_renosterbos x=X y=Y z=RX key=_ID 'where=(_RUN = 5) AND
> (_YEAR=99)' output=def_renosterbos_run_5_year_99_2
> 
> I get a Segmentation fault and an empty vector layer is created - am
> I doing something wrong or is it a bug?

Untested: 
use your quotes slightly different:
v.in.db driver=mysql
database="host=ecolmod-mysql,dbname=renpatch_renosterbos"
table=def_renosterbos x=X y=Y z=RX key=_ID where="(_RUN = 5) AND
(_YEAR=99)" output=def_renosterbos_run_5_year_99_2

Perhaps this helps.

	Stephan



-- 
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office      -     Mengendamm 16d      -     D-30177 Hannover
Internet: www.gdf-hannover.de      -      Email: holl at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508