Hi All,
I have a question: how to use table A.column1 as parameter to query result
from table B?
I have two tables :
1. UserStay
id candidatePoiIds selectedPoiId
1 101,102,103 100
2. POIs
id name address
100 starbuck 100 main st,
101 mcdonalds 101 main st,
i want to get all candiate POI's name and address when i fetch User stays,
the following code does not work , i also tried Manager with raw SQL, but i
dont' know how to pass the candidatePois to manager, can i get the string
value of "candidatePois" in model ?
class UserStays(models.Model):
startTime = models.IntegerField('startTime', max_length=255)
candidatePois = models.CharField('CharField', max_length=255)
poiRes = POIS.objects.filter(id in F('*candidatePois*') )
// poiRes = POIS.objects.filter(id = 100 )
//print poiRes.name + poiRes.address
Thanks
Rock
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/722f80db-4069-4e30-a94a-c7d58a9c6c3d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
