Re: sqlite3 bug?

2010-02-12 Thread dads
Thank you It just highlights that when your tired things can easily be missed and maybe you should leave things until the morning to view things with fresh eyes =) -- http://mail.python.org/mailman/listinfo/python-list

Re: Re: sqlite3 bug?

2010-02-11 Thread wayne . dads . bell
Thank you It just highlights that when your tired things can easily be missed and maybe you should leave things until the morning to view things with fresh eyes =) -- http://mail.python.org/mailman/listinfo/python-list

Re: sqlite3 bug?

2010-02-10 Thread Tim Chase
dads wrote: When the method below is run it raises 'sqlite3.OperationalError: no such table: dave'. the arguments are ds = a datestamp and w = a string of digits. The path of the db is C:\sv_zip_test\2006\2006.db and the table is definitely named dave. I've run the sql in sql manager and it works

sqlite3 bug?

2010-02-10 Thread dads
When the method below is run it raises 'sqlite3.OperationalError: no such table: dave'. the arguments are ds = a datestamp and w = a string of digits. The path of the db is C:\sv_zip_test\2006\2006.db and the table is definitely named dave. I've run the sql in sql manager and it works. Is this a bu

Re: sqlite3 bug??

2007-06-19 Thread Gerhard Häring
Hyuga wrote: > On Jun 17, 9:16 am, mark carter <[EMAIL PROTECTED]> wrote: >> Should I also explicitly close the cursor and connection, or is that >> taken care of "automagically"? >> > > Somebody correct me if I'm wrong, but I'm pretty sure that the Cursor > and Connection objects properly clean t

Re: sqlite3 bug??

2007-06-18 Thread Hyuga
On Jun 18, 11:01 am, Hyuga <[EMAIL PROTECTED]> wrote: > In fact, I have code in which references to a > db connection are passed around, so I have to be careful about > explicitly closing the connection, lest it be in use by some other > method somewhere. > Hate to reply to myself, but I should cl

Re: sqlite3 bug??

2007-06-18 Thread Hyuga
On Jun 17, 9:16 am, mark carter <[EMAIL PROTECTED]> wrote: > Should I also explicitly close the cursor and connection, or is that > taken care of "automagically"? > Somebody correct me if I'm wrong, but I'm pretty sure that the Cursor and Connection objects properly clean themselves up when deallo

Re: sqlite3 bug??

2007-06-17 Thread Carsten Haese
On Sun, 2007-06-17 at 19:26 +0100, mark carter wrote: > Carsten Haese wrote: > > On Sun, 2007-06-17 at 07:43 -0700, 7stud wrote: > >> Please report the whole docs as a bug. > > > > I imagine the author appreciates constructive criticism. This is not > > constructive criticism. > > > > In other wo

Re: sqlite3 bug??

2007-06-17 Thread Sebastian Wiesner
[ Carsten Haese <[EMAIL PROTECTED]> ] > On Sun, 2007-06-17 at 07:43 -0700, 7stud wrote: > > Please report the whole docs as a bug. > > Calling the entire docs a bug is not helpful. ... unless he also comes up with the "bugfix". ;) -- Freedom is always the freedom of dissenters.

Re: sqlite3 bug??

2007-06-17 Thread mark carter
Carsten Haese wrote: > On Sun, 2007-06-17 at 07:43 -0700, 7stud wrote: >> Please report the whole docs as a bug. > > I imagine the author appreciates constructive criticism. This is not > constructive criticism. > > In other words: Pointing out specific shortcomings and ways to correct > them, su

Re: sqlite3 bug??

2007-06-17 Thread Carsten Haese
On Sun, 2007-06-17 at 07:43 -0700, 7stud wrote: > Please report the whole docs as a bug. I imagine the author appreciates constructive criticism. This is not constructive criticism. In other words: Pointing out specific shortcomings and ways to correct them, such as what the OP is doing, is helpf

Re: sqlite3 bug??

2007-06-17 Thread mark carter
7stud wrote: > On Jun 17, 7:16 am, mark carter <[EMAIL PROTECTED]> wrote: >> David Wahler wrote: >>> On 6/17/07, mark carter <[EMAIL PROTECTED]> wrote: Anyone else getting these problems? >>> Seehttp://www.python.org/dev/peps/pep-0249/(emphasis mine): >>>.commit() >> >> I'm seriously thin

Re: sqlite3 bug??

2007-06-17 Thread 7stud
On Jun 17, 7:16 am, mark carter <[EMAIL PROTECTED]> wrote: > David Wahler wrote: > > On 6/17/07, mark carter <[EMAIL PROTECTED]> wrote: > >> Anyone else getting these problems? > > > Seehttp://www.python.org/dev/peps/pep-0249/(emphasis mine): > > >.commit() > > OK, I tried that, and I appear to

Re: sqlite3 bug??

2007-06-17 Thread mark carter
David Wahler wrote: > On 6/17/07, mark carter <[EMAIL PROTECTED]> wrote: >> Anyone else getting these problems? > > See http://www.python.org/dev/peps/pep-0249/ (emphasis mine): > >.commit() OK, I tried that, and I appear to be cooking. The funny thing is, I could have sworn that I tried t

Re: sqlite3 bug??

2007-06-17 Thread Peter Otten
mark carter wrote: > I hesitate to ask, but ... Don't :-) > I'm using Ubuntu Feisty: > * Python 2.5.1 (r251:54863, May 2 2007, 16:56:35) > [GCC 4.1.2 (Ubuntu 4.1.2-0ubuntu4)] on linux2 > * SQLite version 3.3.13 > > Suppose I run the following program: > import sqlite3 > > conn = sqlite3.conne

Re: sqlite3 bug??

2007-06-17 Thread Carsten Haese
On Sun, 2007-06-17 at 12:59 +0100, mark carter wrote: > I hesitate to ask, but ... > > I'm using Ubuntu Feisty: > * Python 2.5.1 (r251:54863, May 2 2007, 16:56:35) > [GCC 4.1.2 (Ubuntu 4.1.2-0ubuntu4)] on linux2 > * SQLite version 3.3.13 > > Suppose I run the following program: > import sq

Re: sqlite3 bug??

2007-06-17 Thread David Wahler
On 6/17/07, mark carter <[EMAIL PROTECTED]> wrote: > I hesitate to ask, but ... > > I'm using Ubuntu Feisty: > * Python 2.5.1 (r251:54863, May 2 2007, 16:56:35) > [GCC 4.1.2 (Ubuntu 4.1.2-0ubuntu4)] on linux2 > * SQLite version 3.3.13 > > Suppose I run the following program: > import sqlit

sqlite3 bug??

2007-06-17 Thread mark carter
I hesitate to ask, but ... I'm using Ubuntu Feisty: * Python 2.5.1 (r251:54863, May 2 2007, 16:56:35) [GCC 4.1.2 (Ubuntu 4.1.2-0ubuntu4)] on linux2 * SQLite version 3.3.13 Suppose I run the following program: import sqlite3 conn = sqlite3.connect('example') c = conn.cursor() # Create