ls参数为什么会这样呢

SELECT * from ${if(ls="否","(

SELECT  count(*) as 来单 from 

${if(len(qy)=0&&len(fb)=0,"dm_sj_ld",if(len(qy)<>0&&len(fb)=0,"dm_sj_ld","dm_sj_ld_sjs"))} 

where xldrq BETWEEN '${startdate}' and '${enddate}'

${if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")}

${if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")}

${if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")}

)a","(

SELECT  count(*) as 交订 from 

${if(len(qy)=0&&len(fb)=0,"dm_sj_jd",if(len(qy)<>0&&len(fb)=0,"dm_sj_jd","dm_sj_jd_sjs"))} 

where xjdrq BETWEEN '${startdate}' and '${enddate}'

 ${if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")}

${if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")}

${if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")}

)b")}

image.png

FineReport 用户52076492 发布于 2023-10-18 15:27
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
snrtuemcLv8专家互助
发布于2023-10-18 15:32

语法错误,改成

SELECT * from ${if(ls="否","(

SELECT  count(*) as 来单 from 

"+if(len(qy)=0&&len(fb)=0,"dm_sj_ld",if(len(qy)<>0&&len(fb)=0,"dm_sj_ld","dm_sj_ld_sjs"))+" 

where xldrq BETWEEN '"+startdate+"' and '"+enddate+"'

"+if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")+

if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")+

if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")+"

)a","(

SELECT  count(*) as 交订 from 

"+if(len(qy)=0&&len(fb)=0,"dm_sj_jd",if(len(qy)<>0&&len(fb)=0,"dm_sj_jd","dm_sj_jd_sjs"))+" 

where xjdrq BETWEEN '"+startdate+"' and '"+enddate+"'

 "+if(len(qy)=0,"and 1=1","and qyjc2='"+qy+"'")+

if(len(fb)=0,"and 1=1","AND fbjc2=N'"+fb+"'")+

if(len(qd)=0,"and 1=1","AND qdgsbm in (N'"+qd+"')")+"

)b")}

image.png

最佳回答
0
Z4u3z1Lv6专家互助
发布于2023-10-18 15:30

参数里面加参数不是这样的

"+if(len(qy)=0&&len(fb)=0,"dm_sj_ld",if(len(qy)<>0&&len(fb)=0,"dm_sj_ld","dm_sj_ld_sjs"))+"

后面都是差不多的改法

image.png

  • 1关注人数
  • 171浏览人数
  • 最后回答于:2023-10-18 15:32
    请选择关闭问题的原因
    确定 取消
    返回顶部