Re: Many2Many question about Database API

2007-05-17 Thread Ben Jones
> Apparently it's a bug in the version of sqlite that's bundled with the > Windows installer (3.3.4). The Python 2.5 installer, that is. . . -- -Ben --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django use

Re: Many2Many question about Database API

2007-05-16 Thread Ben Jones
I see where this has already been addressed in ticket #2457 http://code.djangoproject.com/ticket/2457 Apparently it's a bug in the version of sqlite that's bundled with the Windows installer (3.3.4). The command line version of sqlite that I'm running is much more recent, which explains the dif

Re: Many2Many question about Database API

2007-05-16 Thread Ben Jones
> Might be worthwhile having a look at the SQL Django is generating. From > the shell prompt import db.connection and have a look at > db.connection.queries after running the query. > > I wouldn't be too surprised to discover this is a bug caused by using a > left outer join here, in which case it

Re: Many2Many question about Database API

2007-05-16 Thread Malcolm Tredinnick
On Wed, 2007-05-16 at 20:53 -0500, Ben Jones wrote: > Thanks for the help, Russ. > > > > > For test data, I have entered 3 categories and 3 pieces of content > > > (one in each of the 3 categories). > > > > You have 3 categories and 3 content objects, but what is in the m2m > > table between the

Re: Many2Many question about Database API

2007-05-16 Thread Ben Jones
Thanks for the help, Russ. > > For test data, I have entered 3 categories and 3 pieces of content > > (one in each of the 3 categories). > > You have 3 categories and 3 content objects, but what is in the m2m > table between them? What is the matrix of category/content > relationships? It's the

Re: Many2Many question about Database API

2007-05-16 Thread Russell Keith-Magee
On 5/17/07, Ben Jones <[EMAIL PROTECTED]> wrote: > > I have 2 models that I'm using "for training": Content and Category > with a ManyToMany field in Content to relate them. > > For test data, I have entered 3 categories and 3 pieces of content > (one in each of the 3 categories). You have 3 cate

Many2Many question about Database API

2007-05-16 Thread Ben Jones
First, since this is my first post to this group, let me say that Django is phenomenal. So serious. In fact, "phenomenal" doesn't even begin to scratch the surface . . . using that phrase to describe it is an insult! Many, many thanks to everyone who has contributed! On to business . . . I have