Re: [Tutor] SQLite database not update correctly

2009-11-09 Thread Che M
> It's working fine now, but actually I didn't write exactly what you > suggested. > The "commit" method belongs to the connection, not to the cursor. Therefore, > in my script it should be conn.commit(). Whoops, you're quite right. Went a little too fast there. :D Che

Re: [Tutor] SQLite database not update correctly

2009-11-08 Thread Emmanuel Ruellan
It's working fine now, but actually I didn't write exactly what you suggested. The "commit" method belongs to the connection, not to the cursor. Therefore, in my script it should be conn.commit(). On Sun, Nov 8, 2009 at 9:15 PM, Che M wrote: > > > I've got a functions that should update an sqlit

Re: [Tutor] SQLite database not update correctly

2009-11-08 Thread Emmanuel Ruellan
Thanks a lot, Che! It's working fine now. On Sun, Nov 8, 2009 at 9:13 PM, Che M wrote: > > I've got a functions that should update an sqlite database, among other > things. However > > the database doesn't get updated. When used in isolation, the update > statement works > > fine. What am I d

Re: [Tutor] SQLite database not update correctly

2009-11-08 Thread Che M
> I've got a functions that should update an sqlite database, among other > things. However > the database doesn't get updated. When used in isolation, the update > statement works > fine. What am I doing wrong? > Below is the function. The whole script can be found at > http://past

[Tutor] SQLite database not update correctly

2009-11-08 Thread Emmanuel Ruellan
Hi tutors, I've got a functions that should update an sqlite database, among other things. However the database doesn't get updated. When used in isolation, the update statement works fine. What am I doing wrong? Below is the function. The whole script can be found at http://pastebin.com/m53978f