Re: [Tutor] help with data insert into Access table

2014-01-29 Thread eryksun
On Wed, Jan 29, 2014 at 3:53 PM, Keith Winston wrote: > I had the impression that Peter was employing tuples because, > as an immutable type, it couldn't inadvertently/inauspiciously > be changed by a user Per footnote 5 of PEP 249, the parameters need to be in a type that supports __getitem__ (s

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Keith Winston
On Wed, Jan 29, 2014 at 3:03 PM, Mark Lawrence wrote: > Nothing to do with tuples. Tools such as syntax checkers or MkI eyeballs > come in useful here. Although such tools probably won't pick up the > incorrect spelling of "harboUr" :) Alas, now I'm more confused. I don't see any mispellings in

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Mark Lawrence
On 29/01/2014 19:47, Keith Winston wrote: On Wed, Jan 29, 2014 at 12:11 PM, Mark Lawrence wrote: I think it's worth pointing out that there is a difference here between the OP's 'Site Name's Harbor.JPG' and Peter's "Site Name's Harbor.JPG". Left as homework for the newbies :) I'll bite. But

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Keith Winston
On Wed, Jan 29, 2014 at 12:11 PM, Mark Lawrence wrote: > I think it's worth pointing out that there is a difference here between the > OP's 'Site Name's Harbor.JPG' and Peter's "Site Name's Harbor.JPG". Left as > homework for the newbies :) I'll bite. But are you just referring to the tuple iss

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Ahmed, Shakir
Thanks, it worked exactly what I was trying to do so. -Original Message- From: Tutor [mailto:tutor-bounces+shahmed=sfwmd@python.org] On Behalf Of Peter Otten Sent: Wednesday, January 29, 2014 11:47 AM To: tutor@python.org Subject: Re: [Tutor] help with data insert into Access table

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Mark Lawrence
On 29/01/2014 16:46, Peter Otten wrote: Ahmed, Shakir wrote: I am trying to insert a record in the access table, the value has a quote and could not insert the record. Any idea how I can insert records like this quotes. cursor.execute("INSERT INTO PicsPostInfo(Pics_name) values ('Site Name's

Re: [Tutor] help with data insert into Access table

2014-01-29 Thread Peter Otten
Ahmed, Shakir wrote: > I am trying to insert a record in the access table, the value has a quote > and could not insert the record. Any idea how I can insert records like > this quotes. > cursor.execute("INSERT INTO PicsPostInfo(Pics_name) values ('Site Name's > Harbor.JPG')") Traceback (most rec