起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 2952|回复: 1

[结贴] 为什么过滤条件会拼出这种sql

[复制链接]

407

主题

926

帖子

2039

积分

金牌会员

Rank: 6Rank: 6

积分
2039
QQ
发表于 2020-7-7 19:44:00 | 显示全部楼层 |阅读模式
sql:SELECT  BID_PERSONHONOR.AWARDNAME AS AWARDNAME, BID_PERSONHONOR.AWARDTILLTIME AS AWARDTILLTIME, BID_PERSONHONOR.AWARDTIME AS AWARDTIME, BID_PERSONHONOR.AWARDUNIT AS AWARDUNIT, BID_PERSONHONOR.FID AS BID_PERSONHONOR, BID_PERSONHONOR.GONGHAO AS GONGHAO, BID_PERSONHONOR.PERSONNAME AS PERSONNAME, BID_PERSONHONOR.PRJNAME AS PRJNAME, BID_PERSONHONOR.PRJRELATED AS PRJRELATED, BID_PERSONHONOR.PROOFFILE AS PROOFFILE, BID_PERSONHONOR.REMARK AS REMARK, BID_PERSONHONOR.SCANFILENO AS SCANFILENO, BID_PERSONHONOR.SORTNUM AS SORTNUM, BID_PERSONHONOR.FCREATDTIME AS fCreatdTime, BID_PERSONHONOR.FCREATEDEPTCODE AS fCreateDeptCode, BID_PERSONHONOR.FCREATEDEPTID AS fCreateDeptID, BID_PERSONHONOR.FCREATEDEPTNAME AS fCreateDeptName, BID_PERSONHONOR.FCREATEPERSONCODE AS fCreatePersonCode, BID_PERSONHONOR.FCREATEPERSONFID AS fCreatePersonFID, BID_PERSONHONOR.FCREATEPERSONID AS fCreatePersonID, BID_PERSONHONOR.FCREATEPERSONNAME AS fCreatePersonName, BID_PERSONHONOR.VERSION AS version FROM BID_PERSONHONOR BID_PERSONHONOR  WHERE  (? = ?) AND (AWARDUNIT = ?)
--> binds:[1, 1, unit]

前台的过滤器:mainData.queryFilter: 1 = 1  and AWARDUNIT = 'unit'

按道理参数传过去应该是  'unit',怎么会 是 unit?

407

主题

926

帖子

2039

积分

金牌会员

Rank: 6Rank: 6

积分
2039
QQ
 楼主| 发表于 2020-7-7 19:46:16 | 显示全部楼层
发错了,结帖吧。
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-6-19 21:21 , Processed in 0.053357 second(s), 24 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表