-----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 :) - -- Nebojša Đorđević - nesh Studio Quattro - Niš - SCG http://studioquattro.biz/ http://djnesh.blogspot.com/ | http://djnesh-django.blogspot.com/ | http://djangoutils.python-hosting.com/ Registered Linux User 282159 [http://counter.li.org] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFD/102t2W58T89D+0RAqncAJ45ud+tGxX1mglnoTCj0i9EWwynwACeMzoU Fa/ETh/IpByxCu3+e0rOth4= =XqD8 -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---