Re: Simple sqlite3 question

2007-04-26 Thread Tim Roberts
cjl [EMAIL PROTECTED] wrote: I am using python 2.5.1 on windows. I have the following code: conn = sqlite3.connect('.\optiondata') This is unrelated to your question, but you have a slash problem there. \o doesn't happen to be a valid escape character, but if you had used testdata as the

Simple sqlite3 question

2007-04-24 Thread cjl
P: I am using python 2.5.1 on windows. I have the following code: conn = sqlite3.connect('.\optiondata') c = conn.cursor() try: c.execute('''create table options (ssymbol text, strike real, osymbol text, bid real, mpp real, upp real)''') except sqlite3.OperationalError: pass I am hoping

Re: Simple sqlite3 question

2007-04-24 Thread Jerry Hill
On 24 Apr 2007 10:03:45 -0700, cjl [EMAIL PROTECTED] wrote: When I run the script and there is no file named optiondata, one is created and the correct data is added to it. If I run the script again then the data from the first run seems to be replaced with the data from the second run. I

Re: Simple sqlite3 question

2007-04-24 Thread John Nagle
Jerry Hill wrote: On 24 Apr 2007 10:03:45 -0700, cjl [EMAIL PROTECTED] wrote: When I run the script and there is no file named optiondata, one is created and the correct data is added to it. If I run the script again then the data from the first run seems to be replaced with the data from