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-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 -~----------~----~----~----~------~----~------~--~---