查询之后查不出对应的数据

下拉框查询数据，第一个是日期控件能查到，第二个下拉框就查不出对应的数据了

FineReporthjU337 发布于 2016-9-28 14:47

关注问题

悬赏：2 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共7回答

最佳回答

cherishdqy发布于2016-9-28 14:47（编辑于 2023-9-6 09:34）

555

cherishdqy发布于2016-9-28 14:51（编辑于 2023-9-6 09:34）

555

hjU337发布于2016-9-28 14:55（编辑于 2023-9-6 09:34）

555

举报收起评论(1)

cherishdqy

你导出的是内置数据模板，看不到sql语句

2016-09-28 15:05

cherishdqy发布于2016-9-28 15:05（编辑于 2023-9-6 09:34）

555

举报收起评论(1)

hjU337(提问者)

select grid_goods_type.name,
grid_goods.unit,
grid_goods.numb,
grid_goods.memo,
grid_goods.address,
grid_info_goods_recordtype.name as dz,
grid_goods_record.dt,
grid_goods_record.dt + time_change as nextdt,
ceil(grid_goods_record.dt + time_change - sysdate) as syday
from grid_goods
inner join grid_goods_type
on grid_goods_type.id
= grid_goods.nameid
inner join grid_info_goods_recordtype
on grid_info_goods_recordtype.goodsid = grid_goods_type.id
left join grid_goods_record
on grid_goods_record.recordtype = grid_info_goods_recordtype.name
and grid_goods_record.goodsid = grid_goods.id
and grid_goods_record.islast = 1
where status = 0
and (nvl(dt, sysdate) = sysdate or
to_char(grid_goods_record.dt + time_change, \'yyyy-mm-dd\') < \'${endtime}\')

复制代码

2016-09-28 15:24

hjU337发布于2016-9-28 15:24（编辑于 2023-9-6 09:34）

555

举报收起评论(1)

cherishdqy

你的sql中没有对CZ操作做过滤啊

2016-09-28 15:27

cherishdqy发布于2016-9-28 15:27（编辑于 2023-9-6 09:34）

555

举报收起评论(1)

hjU337(提问者)

select grid_goods_type.name,
grid_goods.unit,
grid_goods.numb,
grid_goods.memo,
grid_goods.address,
grid_info_goods_recordtype.name as dz,
grid_goods_record.dt,
grid_goods_record.dt + time_change as nextdt,
ceil(grid_goods_record.dt + time_change - sysdate) as syday
from grid_goods
inner join grid_goods_type
on grid_goods_type.id
= grid_goods.nameid
inner join grid_info_goods_recordtype
on grid_info_goods_recordtype.goodsid = grid_goods_type.id
left join grid_goods_record
on grid_goods_record.recordtype = grid_info_goods_recordtype.name
and grid_goods_record.goodsid = grid_goods.id
and grid_goods_record.islast = 1
where status = 0
and (nvl(dt, sysdate) = sysdate or
to_char(grid_goods_record.dt + time_change, \'yyyy-mm-dd\') < \'${endtime}\')
and grid_info_goods_recordtype.name=\'${dz}\'

复制代码

2016-09-28 15:41

hjU337发布于2016-9-28 15:41（编辑于 2023-9-6 09:34）

555

举报收起评论(1)

cherishdqy

操作绑定的字段是CZ？你的sql中没有CZ啊
[attach]45956[/attach]

最后一行代码改成${if(len(dz)=0,\"\",\"and grid_info_goods_recordtype.name=\'\"+dz+\"\'\")}

2016-09-28 14:47

0关注人数

317浏览人数

最后回答于：2016-9-28 15:41

活动推荐更多

热门课程更多

提问

查询之后查不出对应的数据

悬赏者（0）

添加悬赏