List Info

Thread: order_with_respect_to




order_with_respect_to
user name
2006-02-24 19:36:36
iīm using 4.0.18 (well, my hosting company does).

besides that, i donīt really understand the query.
it is "SELECT COUNT(*) FROM `skip_filmstarts_a` WHERE
`film_id` = '778".
the film_id i have entered is "7786".

patrick


> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> patrick k wrote:
>> query is:
>> 
>> 'INSERT INTO `skip_filmstarts_a`
(`film_id`,`_order`) VALUES (%s,(SELECT
>> COUNT(*) FROM `skip_filmstarts_a` WHERE `film_id` =
%s))'
> 
> No luck,
> 
> django.core.meta.__init_py:1020
> # TODO: This assumes the database supports subqueries.
> placeholders.append('(SELECT COUNT(*) FROM %s WHERE %s
= %%s)' % \
>  (db.db.quote_name(opts.db_table),
> db.db.quote_name(opts.order_with_respect_to.column)))
> 
> MySQL doc says that all sub queries are supported after
4.1, which version you
> are using?
> 
> Tried with sqlite driver and works and I presume that
postgresql will work
> too.
> 
> Worth a ticket 
> 
> - --


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Django users" group.
To post to this group, send email to django-usersgooglegroups.com
To unsubscribe from this group, send email to
django-users-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )