[GRASS5] sql query error in db.select

Michael Barton michael.barton at asu.edu
Tue Dec 7 13:47:28 EST 2004


A student and I just tried to look up something in an attribute table in
GRASS 5.7 using db.select via the autogenerated gui. I've included the
generated command below. We've also tried this with single quotes and no
quotes around the field value of "La Contienda". This same syntax works fine
in d.vect. I'm pretty sure that this computer is using a 11 November version
of 5.7. Any thoughts?

db.select table=jaciments_dispersio
database=$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ driver=dbf 'sql=TOPONIM="La
Contienda"' fs=| -v


DBMI-DBF driver error:
SQL parser error in statement:
TOPONIM="La Contienda"
Error in db_open_select_cursor()

Michael
______________________________
Michael Barton, Professor of Anthropology
School of Human, Evolution and Social Change
Arizona State University
Tempe, AZ  85287-2402
USA

voice: 480-965-6262; fax: 480-965-7671
www: http://www.public.asu.edu/~cmbarton




More information about the grass-dev mailing list