Re: [sqlite] passing error messages to pysqlite

2014-10-07 Thread Kees Nuyt
On Sat, 04 Oct 2014 10:44:20 -0400, Mark Halegua wrote: > self.cdata.execute('insert into publishers(publisher_name, >remarks) values("test", "remarks");') Are you sure this is correct? In SQL, string literals are delimited by single quotes. Double

Re: [sqlite] passing error messages to pysqlite

2014-10-07 Thread FarSight Data Systems
> > > >of capturing/redirecting the stderr output and using an except there. > > > > > > > >On Friday, October 03, 2014 11:35:08 PM you wrote: > > > >> the sqlite3 command line doesn't require a commit, it gave an error > > > >>

Re: [sqlite] passing error messages to pysqlite

2014-10-06 Thread Mark Halegua
> > > >of capturing/redirecting the stderr output and using an except there. > > > > > > > >On Friday, October 03, 2014 11:35:08 PM you wrote: > > > >> the sqlite3 command line doesn't require a commit, it gave an error > > > >>

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
e3 > >>> sqlite3.sqlite_version > > '3.8.7' > > >>> sqlite3.version > > '2.6.0' > > > sqlite3.version is the version number of pysqlite ... > > >-Original Message- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
- > >boun...@sqlite.org] On Behalf Of Mark Halegua > >Sent: Saturday, 4 October, 2014 10:11 > >To: General Discussion of SQLite Database > >Subject: Re: [sqlite] passing error messages to pysqlite > > > >and now the windows version, with sqlite 3.8.6 and a local databa

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Keith Medcalf
on number of pysqlite ... >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mark Halegua >Sent: Saturday, 4 October, 2014 10:11 >To: General Discussion of SQLite Database >Subject: Re: [sqlite] passing

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
and now the windows version, with sqlite 3.8.6 and a local database and local code in the same directory is doing the same, database locked. And yet, at the command line I could do an insert no problem. Mark On Saturday, October 04, 2014 12:00:59 PM Mark Halegua wrote: > Kieth, > > the

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread FarSight Data Systems
sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Mark Halegua > >Sent: Friday, 3 October, 2014 20:58 > >To: sqlite-users@sqlite.org > >Subject: [sqlite] passing error messages to pysqlite > > > >I have a sqlite3 database. In

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread FarSight Data Systems
nge? > > >-Original Message- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Mark Halegua > >Sent: Friday, 3 October, 2014 20:58 > >To: sqlite-users@sqlite.org > >Subject: [sqlite] passing error messages to

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
Kieth, the database is not locked. It is a copy residing on the local hard drive in the same directory as the python code and that version of sqlite3. I was able to do an insert with the same sqlite3 in that directory as the code, so this behavior is somehow wrong. The two systems I've

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
lite requires one? > > >> > > >> Mark > > >> > > >> On Friday, October 03, 2014 09:06:56 PM Keith Medcalf wrote: > > >> > Are you committing the change? > > >> > > > >> > >-Original Me

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Keith Medcalf
and using an except there. >> > >> >On Friday, October 03, 2014 11:35:08 PM you wrote: >> >> the sqlite3 command line doesn't require a commit, it gave an error >> >> after the attempted insert command. >> >> >> >> pysqlite requires o

Re: [sqlite] passing error messages to pysqlite

2014-10-04 Thread Mark Halegua
>> > Are you committing the change? > >> > > >> > >-Original Message- > >> > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >> > >boun...@sqlite.org] On Behalf Of Mark Halegua > >> > >Sent: Friday,

Re: [sqlite] passing error messages to pysqlite

2014-10-03 Thread Keith Medcalf
Friday, October 03, 2014 09:06:56 PM Keith Medcalf wrote: >> > Are you committing the change? >> > >> > >-Original Message- >> > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >> > >boun...@sqlite.org] On Behalf Of Mark Halegu

Re: [sqlite] passing error messages to pysqlite

2014-10-03 Thread Mark Halegua
ers-boun...@sqlite.org [mailto:sqlite-users- > > >boun...@sqlite.org] On Behalf Of Mark Halegua > > >Sent: Friday, 3 October, 2014 20:58 > > >To: sqlite-users@sqlite.org > > >Subject: [sqlite] passing error messages to pysqlite > > > > > >I hav

Re: [sqlite] passing error messages to pysqlite

2014-10-03 Thread Keith Medcalf
Are you committing the change? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Mark Halegua >Sent: Friday, 3 October, 2014 20:58 >To: sqlite-users@sqlite.org >Subject: [sqlite] passing error messages to

[sqlite] passing error messages to pysqlite

2014-10-03 Thread Mark Halegua
I have a sqlite3 database. In the networkied are I have the db is locked (wee've discussed this before, and I'm using it mostly on a local machine, but I need to test certain conditions, networking being one). In the sqlite3 command line, when I try to insert new info I get a dabase locked