| 错误代码:1301 数据集配置错误Query:ORA-01861: 文字与格式字符串不匹配,怎么解决， select a.akc191, a.aac003, a.aae135, a.aae072, a.ake010, a.aae140, a.aka130, b.akf002, b.bkc192, b.akc273, b.bkc194, b.aac004, a.bke001, b.bkc232, b.AAC009, c.aaa103, a.aae140, a.aka130, a.akc264, a.ake300, a.ake301, a.ake302, a.ake303, a.ake304, a.ake305 from nxsiwk.kc24 a,nxsiwk.kc21 b,nxsiwk.aa10 c where a.akb020='00000001' and a.ckc126='1' and a.ake010 between '${jsrq}' and '${jsrq2}' ${if(len(jbjg)==0,"","and a.aab034='"+jbjg+"'")} ${if(len(yllb)==0,"","and a.aka130='"+yllb+"'")} ${if(len(xzlb)==0,"","and a.aae140='"+xzlb+"'")} ${if(len(ks)==0,"","and b.akf002='"+ks+"'")} ${if(len(zyh)==0,"","and a.akc191='"+zyh+"'")} ${if(len(ys)==0,"","and b.akc273='"+ys+"'")} ${if(len(sfzh)==0,"","and a.aae135='"+sfzh+"'")} and a.akc190=b.akc190 and a.bab034=c.aaa102 and c.aaa100='AAB034' 这是我的sql |
