我想要加一個複選控鍵是廠商ID+廠商名稱的控鍵,我寫了
where 1=1
${if(len(c.vendorid)==0,"","and CONCAT(c.vendorid,c.vendorname) in ('" +CONCAT(c.vendorid,c.vendorname)+ "')")}
但沒跑出參數是我哪裡寫錯了?
if(len(c.vendorid)==0)->這裡我的邏輯是一定要有id才會有name,所以只要判斷id長度即可
改了fr的公式後 id跟name被分成2比參數
${if(len(vendorid)==0,"","and CONCAT(c.vendorid,c.vendorname) in ('" +CONCATENATE(vendorid,vendorname)+ "')")}
这个地方改一下
改成fr的函数CONCATENATE()
帆软没得这个函数
${if(len(vendorid)==0,"","and CONCAT(c.vendorid,c.vendorname) in (CONCAT('" +vendorid+"','"+vendorname+ "'))")}