Re: [GRASS-user] query of attribute data

2008-02-25 Thread Nikos Alexandris

On Mon, 2008-02-25 at 13:51 +, 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


signature.asc
Description: This is a digitally signed message part
___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user


Re: [GRASS-user] query of attribute data

2008-02-25 Thread Tom Russo
On Mon, Feb 25, 2008 at 01:51:38PM +, we recorded a bogon-computron 
collision of the [EMAIL PROTECTED] 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 RussoKM5VY   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
___
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user