Re: [sqlite] last modified time or version of sqlite database

Thanks for your suggestions :) Chris.

Re: [sqlite] last modified time or version of sqlite database

Ignore this bit - cut and paste error con=apsw.Connection("aaa") con=apsw.Connection("temp") Martin

Re: [sqlite] last modified time or version of sqlite database

in - Original Message - From: "Chris Fletcher" <[EMAIL PROTECTED]> To: Sent: Monday, April 03, 2006 11:49 PM Subject: Re: [sqlite] last modified time or version of sqlite database <http://sqlite.org/capi3ref.html#sqlite3_total_changes> Thanks - but this seems to g

Re: [sqlite] last modified time or version of sqlite database

On Mon, April 3, 2006 15:49, Chris Fletcher wrote: >> > > Thanks - but this seems to give the number of changes during the > lifetime of a db session. With CGI the sessions will be short lived. > On a new session I want to know when the db wa

RE: [sqlite] last modified time or version of sqlite database

, April 03, 2006 3:50 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] last modified time or version of sqlite database > <http://sqlite.org/capi3ref.html#sqlite3_total_changes> Thanks - but this seems to give the number of changes during the lifetime of a db session. With CGI t

Re: [sqlite] last modified time or version of sqlite database

Thanks - but this seems to give the number of changes during the lifetime of a db session. With CGI the sessions will be short lived. On a new session I want to know when the db was last modified (or some other indication of changes).

Re: [sqlite] last modified time or version of sqlite database

Regards

[sqlite] last modified time or version of sqlite database

I am generating web pages from an sqlite database. I would like to generate an ETag header so I need some handle on when the database has changed, either a last modified time or a revision number of the data. Is there an easy way to get this out of SQLite? In this case the db is very simple so