[GRASS-user] query of attribute data

GRASS GRASS user
1

Dear List,

using the statement

v.db.select geb_grd_RG2_test3 where="A_area <= 4.195,27"

to query an attribute table gives me the error message

DBMI-DBF driver error:
SQL parser error in statement:
SELECT * FROM geb_grd_RG2_test3 WHERE A_area <= 4.195,27
Error in db_open_select_cursor()

Can anybody help?

Greetings

Chris

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

2

On Mon, 2008-02-25 at 13:51 +0000, christian Brandt wrote:

Dear List,

using the statement

v.db.select geb_grd_RG2_test3 where="A_area <= 4.195,27"

to query an attribute table gives me the error message

DBMI-DBF driver error:
SQL parser error in statement:
SELECT * FROM geb_grd_RG2_test3 WHERE A_area <= 4.195,27
Error in db_open_select_cursor()

Can anybody help?

Christian,

just a silly question: Can you confirm the connection with the database?

db.connect -p driver=dbf

or directly with your table:

db.describe -c geb_grd_RG2_test

or

db.select geb_grd_RG2_tes
        
Greetings

Chris

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

--
Nikos Alexandris
.
Department of Remote Sensing & Landscape Information Systems
Faculty of Forestry & Environmental Sciences, Albert-Ludwigs-University Freiburg
.
Tel. +49 (0) 761 203 3697 / Fax. +49 (0) 761 203 3701 / Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4, D-79106 Freiburg i. Br., Germany

3

On Mon, Feb 25, 2008 at 01:51:38PM +0000, we recorded a bogon-computron collision of the <chrisbrandt74@hotmail.com> flavor, containing:

Dear List,

using the statement

v.db.select geb_grd_RG2_test3 where="A_area <= 4.195,27"

Looks like a syntax error to me --- I don't think the comma in 4.195,27 is
valid.

--
Tom Russo KM5VY SAR502 DM64ux http://www.swcp.com/~russo/
Tijeras, NM QRPL#1592 K2#398 SOC#236 AHTB#1 http://kevan.org/brain.cgi?DDTNM
"And, isn't sanity really just a one-trick pony anyway? I mean all you get is
one trick, rational thinking, but when you're good and crazy, oooh, oooh,
oooh, the sky is the limit!" --- The Tick