主题 : 请问如何调用数据库arti_article表的is_recommend字段
级别: 秀才
UID: 53096
积分:90 加为好友
威望: 0 精华: 0
主题:9 回复:25
注册时间:2013-10-11
在线时长:0
1#   发表于:2014-05-22 14:20:13  IP:218.227.*.*
请问在模版中如何调用数据库arti_article表的is_recommend字段

a.attr.recommend
a.recommend
a.attr.isRecommend
a.isRecommend

以上都试过了……
级别: 状元
UID: 33380
积分:50625 加为好友
威望: 21 精华: 3
主题:88 回复:30687
注册时间:2012-05-07
在线时长:0
2#   发表于:2014-05-22 14:23:46  IP:182.10.*.*
那个表下的?这个字段你生成了*类吗
功成由勤,业精于勤。
级别: 秀才
UID: 53096
积分:90 加为好友
威望: 0 精华: 0
主题:9 回复:25
注册时间:2013-10-11
在线时长:0
3#   发表于:2014-05-22 14:27:21  IP:218.227.*.*
jc_content表的字段is_recommend,纯净安装的,没有处理过后台源码
级别: 状元
UID: 33380
积分:50625 加为好友
威望: 21 精华: 3
主题:88 回复:30687
注册时间:2012-05-07
在线时长:0
4#   发表于:2014-05-22 14:31:32  IP:182.10.*.*
is_recommend这个字段只有两个默认值0 1 默认是0 你取这个值在你对象属性里调用a.recommend 
功成由勤,业精于勤。
级别: 秀才
UID: 53096
积分:90 加为好友
威望: 0 精华: 0
主题:9 回复:25
注册时间:2013-10-11
在线时长:0
5#   发表于:2014-05-22 15:08:29  IP:218.227.*.*
Error on line 44, column 126 in WEB-INF/t/cms/www/red/content/下载内容_App.html
Expecting a string, date or number here, Expression a.recommend is instead a freemarker.template.TemplateBooleanModel$1
The problematic instruction:
----------
==> ${a.recommend} [on line 44, column 124 in WEB-INF/t/cms/www/red/content/下载内容_App.html]
 in user-directive cms_content_list [on line 42, column 17 in WEB-INF/t/cms/www/red/content/下载内容_App.html]
----------

Java backtrace for programmers:
----------
freemarker.core.NonStringException: Error on line 44, column 126 in WEB-INF/t/cms/www/red/content/下载内容_App.html
Expecting a string, date or number here, Expression a.recommend is instead a freemarker.template.TemplateBooleanModel$1
at freemarker.core.Expression.getStringValue(Expression.java:126)
at freemarker.core.Expression.getStringValue(Expression.java:93)
at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:179)
at freemarker.core.Environment.visit(Environment.java:417)
at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.Environment$1.render(Environment.java:235)
at com.jeecms.cms.action.directive.ContentListDirective.execute(ContentListDirective.java:70)
at freemarker.core.Environment.visit(Environment.java:263)
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.Environment.process(Environment.java:190)
at freemarker.template.Template.process(Template.java:237)
at com.jeecms.common.web.springmvc.SimpleFreeMarkerView.renderMergedTemplateModel(SimpleFreeMarkerView.java:111)
at org.springframework.web.servlet.view.AbstractTemplateView.renderMergedOutputModel(AbstractTemplateView.java:167)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:745)
级别: 状元
UID: 33380
积分:50625 加为好友
威望: 21 精华: 3
主题:88 回复:30687
注册时间:2012-05-07
在线时长:0
6#   发表于:2014-05-22 15:10:07  IP:182.10.*.*
 ${a.recommend!} 这么取看下
功成由勤,业精于勤。
级别: 秀才
UID: 53096
积分:90 加为好友
威望: 0 精华: 0
主题:9 回复:25
注册时间:2013-10-11
在线时长:0
7#   发表于:2014-05-22 16:06:02  IP:218.227.*.*
 ${a.recommend!} 这么取看下


这个方式取的话,都是取不到的,因为不存在……
级别: 状元
UID: 33380
积分:50625 加为好友
威望: 21 精华: 3
主题:88 回复:30687
注册时间:2012-05-07
在线时长:0
8#   发表于:2014-05-22 16:12:46  IP:182.10.*.*
上面那方法去有没有报错
功成由勤,业精于勤。
级别: 秀才
UID: 53096
积分:90 加为好友
威望: 0 精华: 0
主题:9 回复:25
注册时间:2013-10-11
在线时长:0
9#   发表于:2014-05-23 09:02:42  IP:218.227.*.*
回复第8楼



Error on line 44, column 127 in WEB-INF/t/cms/www/red/content/下载内容_App.html
Expecting a string, date or number here, Expression a.recommend! is instead a freemarker.template.TemplateBooleanModel$1
The problematic instruction:
----------
==> ${a.recommend!} [on line 44, column 125 in WEB-INF/t/cms/www/red/content/下载内容_App.html]
 in user-directive cms_content_list [on line 42, column 17 in WEB-INF/t/cms/www/red/content/下载内容_App.html]
----------

Java backtrace for programmers:
----------
freemarker.core.NonStringException: Error on line 44, column 127 in WEB-INF/t/cms/www/red/content/下载内容_App.html
Expecting a string, date or number here, Expression a.recommend! is instead a freemarker.template.TemplateBooleanModel$1
at freemarker.core.Expression.getStringValue(Expression.java:126)
at freemarker.core.Expression.getStringValue(Expression.java:93)
at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:179)
at freemarker.core.Environment.visit(Environment.java:417)
at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.Environment$1.render(Environment.java:235)
at com.jeecms.cms.action.directive.ContentListDirective.execute(ContentListDirective.java:70)
at freemarker.core.Environment.visit(Environment.java:263)
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.Environment.process(Environment.java:190)
at freemarker.template.Template.process(Template.java:237)
at com.jeecms.common.web.springmvc.SimpleFreeMarkerView.renderMergedTemplateModel(SimpleFreeMarkerView.java:111)
at org.springframework.web.servlet.view.AbstractTemplateView.renderMergedOutputModel(AbstractTemplateView.java:167)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:817)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:745)
级别: 状元
UID: 33380
积分:50625 加为好友
威望: 21 精华: 3
主题:88 回复:30687
注册时间:2012-05-07
在线时长:0
10#   发表于:2014-05-23 09:06:35  IP:182.13.*.*
取不到应该是没有生成*类了,这个recommend参数是在[@content_list ]里用的,你自己到数据库加过一个自动生成下*类
功成由勤,业精于勤。
1 2 > >| 共2页