AttributeError：'Row‘对象没有'title’Web2py属性
提问于 2013-01-27 05:50:22
我度过了漫长的一天，希望得到一点帮助:)
我正在用web2py开发一个搜索表单，我创建了这样的表单
<table>
<form method="post" action="{{=URL('views', 'search')}}">
<tr><td><label>Enter Keywords</label></td><td><input style="background-color: lightgreen; color:#333; font-weight:bold; width:260px;" type="text" name="tags"></td>
</tr>
<tr>
<td>
<label>Select Region</label>
</td>
<td>
<select name="region" style="width:260px">
<option value="" style="background-color: darkgreen; color:#FEFEFE; font-weight:bold; width:260px;">Choose a Region...
{{for region in region_query:}}
<option value="{{=region.id}}" style="background-color: lightgreen; color:#333; font-weight:bold; width:260px;">{{=region.title}}</option>
{{pass}}
</select>
</td>
</tr>
<tr>
<td>
<label>Select Category</label>
</td>
<td>
<select name="category" style="width:260px;">
<option value="" style="background-color: darkgreen; color:#FEFEFE; font-weight:bold; width:260px;">Choose a Category
{{for cat in cat_query:}}
<optgroup label="{{=cat.title}}" style="background-color: darkgreen; color:#FEFEFE; font-weight:bold; width:260px;">
{{sub_query = db(db.sub_category.main_category == cat.id).select(orderby=db.sub_category.title)}}
</optgroup>
{{for sub in sub_query:}}
<option value="{{=sub.id}}" style="background-color: lightgreen; color:#333; width:260px;">{{=sub.title}}</option>
{{pass}}
{{pass}}
</select>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" style="background-color: lightgreen; color:#333; font-weight:bold; width:260px; height:30px" value="Search Business Directory">
</td>
</tr>
</form>
</table>我的控制器由以下几部分组成
def search():
mystr = str(request.post_vars["tags"])
if mystr == "" or mystr == None:
return redirect(URL('default', 'error_search'))
region = str(request.post_vars["region"])
if region == "" or region == None:
return redirect(URL('default', 'error_search'))
category = str(request.post_vars["category"])
if category == "" or mystr == None:
return redirect(URL('default', 'error_search'))
featured = db((db.featured_listing.tag_words.like('%'+mystr+'%')) | (db.listing.region.contains(region)) | (db.listing.sub_category.contains(category))).select(orderby=db.featured_listing.title)
query = (db.listing.tag_words.like('%'+mystr+'%')) | (db.listing.region.contains(region)) | (db.listing.sub_category.contains(category))
orderby = db.listing.title
pcache = (cache.ram, 15)
paginate = Pagination(db, query, orderby, display_count=10, cache=pcache, r=request, res=response)
search_query = paginate.get_set(set_links=True)
return dict(search_query=search_query, featured=featured)我的结果搜索视图包含以下内容
{{for query2 in featured:}}
<div class="listingItem">
<div class="listingItem-content">
<h2>{{=query2.title}}</h2>
....等等等等
我在搜索时收到此错误
Traceback (most recent call last):
File "/var/www/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File "/var/www/web2py/applications/GreenPages_web/views/views/search.html", line 47, in <module>
AttributeError: 'Row' object has no attribute 'title'任何想法，我可以解决这个问题，并实现我正在寻找的结果。
谢谢你给我的建议。
回答 1
Stack Overflow用户
回答已采纳
发布于 2013-01-27 17:15:26
featured = db((db.featured_listing.tag_words.like('%'+mystr+'%')) |
(db.listing.region.contains(region)) |
(db.listing.sub_category.contains(category))).select(orderby=db.featured_listing.title)上面的查询引用了两个不同的表(db.featured_listing和db.listing)。因此，结果将包括来自两个表的字段，因此您将需要使用表名和字段名来引用每个记录中的字段。如果"title“字段在db.featured_listing表中，则必须通过query2.featured_listing.title而不是query2.title引用它。
请注意，尽管您的查询引用了两个表，但它不涉及联接，因此此查询可能不会返回预期的结果。
参见http://web2py.com/books/default/chapter/29/06#Inner-joins。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/14544812
复制相关文章
腾讯云开发者
