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 the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to