Sorry. Am not sure about value of Auth.user_id
On Jun 15, 2017 07:25, "Anthony" <[email protected]> wrote:
> What is the value of auth.user_id? Are you sure there are records in the
> database whose "post_by" value is equal to it?
>
> On Thursday, June 15, 2017 at 12:03:54 AM UTC-4, Maurice Waka wrote:
>>
>> when trying to view posts created by author, i tried this piece of code
>> on controller:
>>
>> 1. option one: replies = db(db.answers.posted_by==auth.
>> user_id).select(orderby=~db.answers.posted_by,limitby=(0,10))
>> 2. option two where the author has two fields populated with
>> information:
>> 1. questions = db(db.answers.quest == auth.user_id).select()
>> 2. replies = db(db.answers.report == auth.user_id).select()
>>
>> With above options, i keep getting a blank screen., but messages are
>> posted to the database
>> With this option below, i get to view all posts by not only the author's
>> posts but by all authors logged. I want it private that ONLY the author can
>> view his/her posts.
>>
>> - replies = db(db.answers).select()
>> - return dict(replies=replies)
>>
>> The code on the models is:
>>
>> db.define_table('answers',
>> Field('quest', 'text', 'reference auth_user'),
>> Field('report', 'text', 'reference auth_user'),
>> Field('posted_by','reference
>> auth_user',readable=False,writable=False),
>> auth.signature
>> )
>>
>>
>> code on view.html:
>>
>> 1. Option one: all authors posts are seen on view
>>
>> {{for reply in replies:}}
>> {{=reply.quest}}
>> {{=reply.report.}}
>> {{pass}}
>>
>>
>> 1. Option two. gives a blank screen/view
>>
>> {{for question in questions:}}
>> {{=question.quest}}
>> {{pass}}
>> {{for reply in replies:}}
>> {{=reply.reportt}}
>> {{pass}}
>>
>>
>>
>> I don't know where am going wrong. Please assist
>> Kind regards
>>
>>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/Msoj2qZO7RU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
