Re: Compare two tables in a secondary database

2011-12-22 Thread Edvinas Narbutas
Im trying to query the second DB for information. Its a back up from another database, its separate from default, here is the settings.py -> DATABASES: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': '#', 'USER': '#', 'PASSWORD': '#',

Re: Compare two tables in a secondary database

2011-12-22 Thread Edvinas Narbutas
Yeah, the ORM didn't work out as i thought for this. I have written this raw query with a model. Alot less code compared to as before. class itemSearch(models.Model): typeID = models.SmallIntegerField(primary_key = True)typeName = models.CharField(max_length = 200) item_search_results = itemS

Re: Compare two tables in a secondary database

2011-12-23 Thread Edvinas Narbutas
' ) for name in item_search_results: results.append(name.typeName) When i wrote it i modified the search_query before the actual raw query. But i like how you did it in the params, one less line of code :) . Thanks for helping me, i appreciate it greatly. :) On Fri, Dec 23, 2011 at 5: