Re: HELP! pysqlite2 FTS3 and datetime not returning datetime

2009-08-03 Thread Carol Hatcher
Hi Karen, Thank you very much for your thorough answer. Yes, indeed, using method #2 ('sqlite3.PARSE_COLNAME) in a sample python script does work with virtual tables using fts3. I've decided to go with creating the models' 'datetime' fields with CharFields. I'll probably create some sort of

Re: HELP! pysqlite2 FTS3 and datetime not returning datetime

2009-08-02 Thread Karen Tracey
On Sun, Aug 2, 2009 at 7:06 PM, Carol Hatcher wrote: > > Hi, > > I'm using Django 1.0 and 1.1, pysqlite2 (latest version), sqlite3 > (latest version) and FTS3 (latest > version). > I'm creating some Django models where I recreate the database tables > as virtual tables using > FTS3 so that we can

HELP! pysqlite2 FTS3 and datetime not returning datetime

2009-08-02 Thread Carol Hatcher
Hi, I'm using Django 1.0 and 1.1, pysqlite2 (latest version), sqlite3 (latest version) and FTS3 (latest version). I'm creating some Django models where I recreate the database tables as virtual tables using FTS3 so that we can do full text search. Some of the fields in the tables are datetime fie