Send grass-windows mailing list submissions to
grass-windows@lists.osgeo.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/grass-windows
or, via email, send a message with subject or body 'help' to
grass-windows-requ...@lists.osgeo.org
You can reach the person managing the list at
grass-windows-ow...@lists.osgeo.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of grass-windows digest..."
Today's Topics:
1. Re: db.execute not working (Glynn Clements)
2. RE: db.execute not working (Louis Becker)
3. RE: db.execute not working (Glynn Clements)
----------------------------------------------------------------------
Message: 1
Date: Wed, 6 Oct 2010 23:50:13 +0100
From: Glynn Clements <gl...@gclements.plus.com>
Subject: Re: [GRASS-windows] db.execute not working
To: "Louis Becker" <louis.bec...@leo.na>
Cc: grass-windows@lists.osgeo.org
Message-ID: <19628.64805.735195.422...@cerise.gclements.plus.com>
Content-Type: text/plain; charset=us-ascii
Louis Becker wrote:
> I want to use db.execute in a script, but can't get it working.
>
> Trying:
>
> Echo "select * from Coverage2011_4" | db.execute
In Windows' shell (cmd.exe), the quotes will be retained, causing a
syntax error; try:
Echo select * from Coverage2011_4 | db.execute
--
Glynn Clements <gl...@gclements.plus.com>
------------------------------
Message: 2
Date: Thu, 7 Oct 2010 07:43:00 +0200
From: "Louis Becker" <louis.bec...@leo.na>
Subject: RE: [GRASS-windows] db.execute not working
To: "Glynn Clements" <gl...@gclements.plus.com>
Cc: grass-windows@lists.osgeo.org
Message-ID:
<21a6a90e7cd2584db72892049e1de78f02f18...@mail01.99eight.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Glynn
Have tried. I get:
DBMI-SQlite driver error:
Error in sqlite3_step()
not an error
ERROR: Error while executing: 'select * from Coverage2011_4
'
Different error this time.
Louis Becker
Project Control Manager
T +264 855 550 000
C +264 855 510 136
F +264 855 202 010
mailto:louis.bec...@leo.na
http://www.leo.na
> -----Original Message-----
> From: Glynn Clements [mailto:gl...@gclements.plus.com]
> Sent: 07 October 2010 00:50
> To: Louis Becker
> Cc: grass-windows@lists.osgeo.org
> Subject: Re: [GRASS-windows] db.execute not working
>
>
> Louis Becker wrote:
>
> > I want to use db.execute in a script, but can't get it working.
> >
> > Trying:
> >
> > Echo "select * from Coverage2011_4" | db.execute
>
> In Windows' shell (cmd.exe), the quotes will be retained, causing a
> syntax error; try:
>
> Echo select * from Coverage2011_4 | db.execute
>
> --
> Glynn Clements <gl...@gclements.plus.com>
DISCLAIMER
This message is intended solely for the individual(s) and entity(s) to which it
is addressed. It is confidential and may contain legally privileged
information.
Any unauthorized review, use, copying, storage, disclosure or distribution of
this e-mail and any attachments is strictly prohibited. If you are not the
named
recipient or have otherwise received this communication in error, please
destroy this message from your system and kindly notify the sender by e-mail.
------------------------------
Message: 3
Date: Thu, 7 Oct 2010 09:42:10 +0100
From: Glynn Clements <gl...@gclements.plus.com>
Subject: RE: [GRASS-windows] db.execute not working
To: "Louis Becker" <louis.bec...@leo.na>
Cc: grass-windows@lists.osgeo.org
Message-ID: <19629.34786.917726.17...@cerise.gclements.plus.com>
Content-Type: text/plain; charset=us-ascii
Louis Becker wrote:
> DBMI-SQlite driver error:
> Error in sqlite3_step()
> not an error
>
> ERROR: Error while executing: 'select * from Coverage2011_4
> '
I don't know if it's related, but you probably shouldn't be using
db.execute for a select statement. You would normally use db.select
for queries.
--
Glynn Clements <gl...@gclements.plus.com>
------------------------------
_______________________________________________
grass-windows mailing list
grass-windows@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-windows
End of grass-windows Digest, Vol 50, Issue 3
********************************************
