Re: Query with no-correspondence results

2011-12-26 Thread wgis
Sorry for digging this up but I have a more complex funcionality to implement and I was hoping you could help I had mydatabase_votecontext (id, name) (1, Flavour) (2, Smell) (3, Usability) (4, Size) mydatabase_vote (id, thing, context, user, vote) (1, Potatoes, Flavour, Me, 2.0) (2, Potatoes, Sm

Re: Query with no-correspondence results

2011-12-11 Thread wgis
hmm.. I did not take that into consideration. I'm using MySQL. That's unfortunately, indeed it was doing what I asked for. Well, thank you both. My project is more in tune now. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this gro

Re: Query with no-correspondence results

2011-12-08 Thread wgis
Ian Clelland, it worked! Thanks a lot for your perseverance Tom's secret sauce it's not working, unfortunately =( Just (Carrots, Flavour, 3.0) I guess since some 'contexts' don't have an associated thing-vote, the filter will cut them off. It would be more neat with the ORM, but I must be looking

Re: Query with no-correspondence results

2011-12-07 Thread wgis
First, thank you both for your answers. I'm now realizing that doing this with the ORM is not so easy as I thought it would be to others django fellows (it's my first django project, but I'm nailing it =P). I saw your RAW SQL solution and it looked genius-simple. I have short experience with the JO

Re: Query with no-correspondence results

2011-12-06 Thread wgis
ots, Smell, null) (Carrots, Usability, null) (Carrots, Size, null) I could just list them, without further querying. On 6 Dez, 12:46, Reinout van Rees wrote: > On 06-12-11 06:43, wgis wrote: > > > But then I would have something like > > (Carrots, Flavor,2.0) > > as the r

Re: Query with no-correspondence results

2011-12-05 Thread wgis
, Usability, null) (Carrots, Size, null) Or am I missing something? I tested it btw =P On 5 Dez, 23:42, Reinout van Rees wrote: > On 05-12-11 23:10, wgis wrote: > > > > > > > > > > > Hi guys, > > I'm trying to solve this without raw SQL, from the past 4/

Query with no-correspondence results

2011-12-05 Thread wgis
Hi guys, I'm trying to solve this without raw SQL, from the past 4/5 days. I've been also researching a lot to understand more complex queries in django so I would realy appreciate your help since I plan to continue using django in my projects. I have a: class VoteContext(models.Model):

Subquery most voted object

2011-10-14 Thread wgis
Hi, I currently have this models: class Place(models.Model): () class VoteContext(models.Model): name = models.CharField(max_length = 15, unique = True) class Vote(models.Model): place = models.ForeignKey(Place, related_name='voted_place') context = models.