$语句:{if(len(box4) == 0,""," and C.AreaName ='" + box4+ "'") }其中box4 是一个下拉框 我用来获取部门的值 取值办法用的公式公式:SQL("JDBC3"," selectB.AreaName from Dict_ShopInfo Ainner join Dict_ShopArea B on B.AreaNo=A.AreaNoleft join Dict_ShopArea C on C.AreaNo=B.PareNoleft join Dict_ShopArea D on D.AreaNo=C.PareNowhere B.AreaName = '"+$get_dept+"' ",1,1)这个公式取值是正常的,但是参数代入sql后 就取不到值了。如果写死 就没问题