Re: [sqlite] Can someone explain this error....

2007-12-10 Thread Jonathan O
On 12/10/07, Tom Shaw <[EMAIL PROTECTED]> wrote: > > I periodically get the following error: > > Error!: SQLSTATE[HY000]: General error: 17 database schema has changed > > However all I am doing is selecting, inserting and updating. How can > those functions change the schema? > Just a guess but

[sqlite] Re: SQLite News

2007-12-10 Thread Jonathan O
On 12/10/07, Jonathan O <[EMAIL PROTECTED]> wrote: > > http://sqlite.org/news.html has a bad link to http://sqlite.org/download, > instead it should be http://sqlite.org/download.html . The link is under > 3.5.3 news second paragraph first sentence called download.html. >

[sqlite] SQLite News

2007-12-10 Thread Jonathan O
http://sqlite.org/news.html has a bad link to http://sqlite.org/download, instead it should be http://sqlite.org/download.html. The link is under 3.5.3 news second paragraph first sentence called download.html. Jonathan

Re: [sqlite] Re: Re: Calculating Average Time

2007-11-19 Thread Jonathan O
On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > Jonathan O <[EMAIL PROTECTED]> wrote: > > On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]> > > wrote: > >> > >> Jonathan O > >> <[EMAIL PROTECTED]> > >&g

Re: [sqlite] Calculating Average Time

2007-11-19 Thread Jonathan O
On 11/19/07, P Kishor <[EMAIL PROTECTED]> wrote: > > On Nov 19, 2007 5:43 PM, Jonathan O <[EMAIL PROTECTED]> wrote: > > I have searched (archives/google) and haven't found a solution for what > I > > need and can't think of a solution so below is my questio

Re: [sqlite] Re: Calculating Average Time

2007-11-19 Thread Jonathan O
On 11/19/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > Jonathan O <[EMAIL PROTECTED]> wrote: > > I have searched (archives/google) and haven't found a solution for > > what I need and can't think of a solution so below is my question. > > I have: > &

[sqlite] Calculating Average Time

2007-11-19 Thread Jonathan O
I have searched (archives/google) and haven't found a solution for what I need and can't think of a solution so below is my question. I have: Job 1 run 1 with a time of '01:00:15' Job 1 run 2 with a time of '01:00:21' What I do is: select sum(strftime('%H%M%S', time_column))/2 from table;