|
|
发表于 2011-8-11 15:43:59
|
显示全部楼层
|阅读模式
来自 广东省广州市番禺区
我想给一个厂部的一个部门弄监控权限，但是不知道哪里弄，还出现的错误的代码。错误#1054: Unknown column 'RUN_NAME' in 'field list'
SQL语句: SELECT FLOW_RUN_PRCS.PRCS_ID,FLOW_RUN.RUN_ID,FLOW_RUN.FLOW_ID,PRCS_FLAG,FLOW_PRCS,FLOW_NAME,RUN_NAME,FLOW_TYPE,LIST_FLDS_STR,FORM_ID from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID='admin' and DEL_FLAG='0' and PRCS_FLAG<>'4' and PRCS_FLAG<>'5' and CHILD_RUN='0' order by FLOW_RUN_PRCS.PRCS_FLAG,PRCS_TIME desc limit 0,15
文件: D:/MYOA/webroot/general/mytable/intel_view/index.php
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\general\mytable\工作流.php on line 23
|
|
发表于 2011-8-11 16:20:18