|
|
问题：本人不能点“高级查询”－html统计报表或excel统计报表查询，一点刚报如下错误：
请联系管理员 错误#1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or FLOW_RUN.RUN_ID in (1)) order by FLOW_RUN.RUN_ID desc' at line 1
SQL语句: SELECT FLOW_RUN.RUN_ID,RUN_NAME,END_TIME,BEGIN_TIME,FLOW_TYPE.FLOW_ID,FLOW_NAME,FLOW_TYPE,FLOW_RUN.ATTACHMENT_ID,FLOW_RUN.ATTACHMENT_NAME from FLOW_TYPE,FLOW_RUN,USER WHERE FLOW_RUN.BEGIN_USER=USER.USER_ID AND FLOW_TYPE.FLOW_ID=FLOW_RUN.FLOW_ID and FLOW_TYPE.FLOW_ID='33' AND FLOW_RUN.DEL_FLAG=0 and BEGIN_TIME>='2012-01-01 00:00:00' and ( or FLOW_RUN.RUN_ID in (1)) order by FLOW_RUN.RUN_ID desc
文件：D:/MYOA/webroot/general/workflow/query/flow_report.php
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\general\workflow\query\flow_report.php on line 166
但可以点“查询列表”，可以以列表方式查询，也可以点“查询列表”后点“ 导出excel”进行查询。
上述问题，如果用admin用户进去查询，则不报错，即用admin用户进去后点“高级查询”－点html统计报表或excel统计报表查询，都不报错。
这是什么问题呢？
|
|
发表于 2012-2-1 09:37:18
楼主
发表于 2012-2-1 17:53:41
