One more thing, I put the auth.user.id in place of the db.auth_user
table and it selectd the single user... Very nice indeed!
Best Regards,
Jason
On 10/10/2010 08:13 AM, Jason Brower wrote:
Ooops, yeah, that was easy! I think I am getting it now.
Best Regards,
Jason Brower
On 10/09/2010 10:21 PM, ron_m wrote:
There is something wrong with the line in your last version of
users_advertisements. For clarity I put one condition per line
users_advertisements = db((db.auth_user.id==db.user_tags.user_id)&
(db.user_tags.tag_id==db.tag.id)&
(db.advertisement.id == db.advertisement_tags.advertisement_id)&
(db.tag.id == db.advertisement_tags.tag_id)).select()
So the last operator between conditions should be& not == as it is in
your statement above unless of course it is just a transciption error
from your code to the message board..
Nothing happens in the sql end of the data access code to touch the
database until you do a select() so that is why the error comes out
only then.
On Oct 9, 11:44 am, Jason Brower<encomp...@gmail.com> wrote:
I tried...
users_advertisements = db((db.auth_user.id==db.user_tags.user_id)&
(db.user_tags.tag_id==db.tag.id)& (db.advertisement.id ==
db.advertisement_tags.advertisement_id) == (db.tag.id ==
db.advertisement_tags.tag_id)).select()'
and it works until I use select()
In additon to these I need to get the specific logged in user id on top
of all this.
BR
Jason
On 10/09/2010 09:25 PM, ron_m wrote:
The last statement is between two db(condition1& condition2) as in
db(condition1& condition2)& db(condition3& condition4)
Why not make this statement and try it
db(condition1& condition2& condition3& condition4).select()
Ron
On Oct 9, 11:09 am, Jason Brower<encomp...@gmail.com> wrote:
#Get the users tags
users_tags = db((db.auth_user.id==db.user_tags.user_id)&
(db.user_tags.tag_id==db.tag.id))
#Get the advertisement's tags too
advertisements_tags = db((db.advertisement.id ==
db.advertisement_tags.advertisement_id)& (db.tag.id ==
db.advertisement_tags.tag_id))
#Now glue dem tegever and select them
users_advertisements = (advertisements_tags&
users_tags).select()
I am trying to get the tags that the current use and the
advertisements
have in common. This is to do targeted advertising. auth_user is my
auth database.
How can I make it happen? Why doesn't the last one work?
---
Best Regards,
Jason Brower
