Hi All, Why do I get this error Error - AttributeError: 'Rows' object has no attribute '_db'. Please have a look at the code given below. Whenever I hit the myfriends url, I get the below issue. =============ERROR================ Ticket ID 127.0.0.1.2012-01-09.16-23-52.fb79b661-40af-4431-bdfa-7f1d5d3af482 <type 'exceptions.AttributeError'> 'Rows' object has no attribute '_db'
Version web2py™ (1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46, 14), 'stable') Python Python 2.7.2: C:\Python27\python.exe Traceback 1.2.3.4.5.6.7.8.9.10.11.12. Traceback (most recent call last): File "D:\WEB2PY\web2py\gluon\restricted.py", line 204, in restricted exec ccode in environment File "D:/WEB2PY/web2py/applications/Build_Connect/controllers/ default.py", line 735, in <module> File "D:\WEB2PY\web2py\gluon\globals.py", line 172, in <lambda> self._caller = lambda f: f() File "D:/WEB2PY/web2py/applications/Build_Connect/controllers/ default.py", line 707, in myfriends csv=False, maxtextlength=128, paginate=50) File "D:\WEB2PY\web2py\gluon\sqlhtml.py", line 1455, in grid db = query._dbAttributeError: 'Rows' object has no attribute '_db' ============= -------Here's the code--------- My Controller: #This lists friends def myfriends(): db.friends.id.readable=False query = db((db.friends.reguserid==session.logged_in_user_id) & (db.friends.status=="Friend")).select(db.friends.friend_name) print db._lastsql fields = (db.friends.id, db.friends.reguserid, db.friends.friendid, db.friends.status, db.friends.friend_name,) headers ={'friends.id': 'ID', 'friends.reguserid': 'ReguserID', 'friends.friendid': 'FriendID', 'friends.status': 'Status', 'friends.friend_name': 'Friend Name', } #default_sort_order = [db.friends.friendid] #, db.projects_posts.expected_start_date links = [lambda row: A(SPAN(_class='icon check'),'View Profile',_class='positive button',_title='View this friends profile', _href=URL("default","view_friend_profile",args=[row.friendid])), lambda row: A(SPAN(_class='icon cross'),'Remove Friend',_class='negative button',_title='Remove from friend list', _href=URL("default","remove_friend",args=[row.friendid]))] table = SQLFORM.grid( query=query, #fields=fields, #headers=headers, #orderby=default_sort_order, user_signature=False, links=links, create=False, searchable=False, details=False, showbuttontext=False, deletable=False, editable=False, csv=False, maxtextlength=128, paginate=50) return dict(table=table) #View Friends Profile def view_friend_profile(): session.myfriendid = request.args[0] #print session.myfriendid query = db(db.reguser.id==session.myfriendid).select() table = SQLFORM.grid(query=query) return dict(table= table) #Remove Friend from Friends list def remove_friend(): session.myfriendid = request.args[0] db((db.friends.reguserid==session.logged_in_user_id) & (db.friends.friendid==session.myfriendid) ).update(status='Rejected') #print db._lastsql return dict() ----x----------------------- My View: (myfriends.html) {{extend 'layout.html'}} <h3>Friends List</h3> <head> <link rel="stylesheet" href="{{=URL(r=request,c='static',f='css/ css3buttons.css')}}" media="all" /> </head> <hr /> {{=table}} -----------x--------------------------------- My Table in db.py reqstatus = ["Friend","Rejected","Sent"] db.define_table('friends', Field('reguserid'), Field('friendid'), Field('status', requires=IS_IN_SET(reqstatus)), Field('friend_name'), ) ---------------------------------------------------------------- I am using - web2py1.99.4 , Win7 and python 2.7 Sincerely, Rahul D