发新话题
打印

SQL语句家参数报错,请帮忙解决下

${has(apid)?(" and apid=" + apid):""}
${has(status)?(" and sign_status=" + status):""}
这两句,似乎没错误。但其余的${}比这两句复杂,是不是调一下,这样写有没有问题:

select subscriberid,sign_name,sign_phone,apid,sign_card,Operate_Type,sign_status,createdate
from SubscriberInfo where 1=1
${has(apid)?(" and apid=" + apid):""}
${has(status)?(" and sign_status=" + status):""}

TOP

发新话题
最近访问的版块