I'm not sure if this is a bug or an example of not understanding the documentation.
I have two models in two different databases. I have a router. I'm trying to get a list of customers from one model (about 30 records worth) and filter for records with that customer in the the other. Here are my models, router and view http://dpaste.com/hold/185738/ The view for reference. def index(request): customers = Edi856CtlRef.objects.values_list('customer', flat = True) orders = Order.objects.all() #later on orders = orders.filter(customer__in = customers) When I try to operate on the resultant query set I get a db error saying the table from the Edi856CtlRef model doesn't exist in the default database. What seems to be happening is that the values_list function is returning a ValuesListQuerySet (until checking just now I thought it was just a list) and the orm sees that and tries to do a join instead of evaluating the list and then using it. My questions are: How do I stop this attempted join? and Wouldn't the orm use the router to stop this? Thanks -Francis -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
