insert into tp_pub_servicertadm (CHANNELCODE, P_SERVICECODE, STEPSEQNO, MODULECODE, TRANSCODE, ROUTERSTATUS, CALLMTH, TIMEOUT, CALLCOND, PREVASSOPER, SVRPRVD, TCISVCID, STEPREGFLG, COMITFLG, CORTFLG, CORTMC, CORTTC)
values ('*', 'TP200043', 5, 'TRN', 'DPS004', '1', '1', 10, '@__REQ__["sdgxflag"]@=="true" && @__REQ__["sta"]@=="true"', '@__REQ__["sta"]@=@__REQ__["TRN_DPS003"]["sta"]@;@__REQ__["prdcode"]@=@__REQ__["TRN_DPS003"]["prdcode"]@', 'local', '', '1', '1', '0', '', '');
上条语句 插入后 &&会消失
把&替换成 ' || chr(38) || ' 即可, chr(38)是&的ASCⅡ码
如下即可:
insert into tp_pub_servicertadm (CHANNELCODE, P_SERVICECODE, STEPSEQNO, MODULECODE, TRANSCODE, ROUTERSTATUS, CALLMTH, TIMEOUT, CALLCOND, PREVASSOPER, SVRPRVD, TCISVCID, STEPREGFLG, COMITFLG, CORTFLG, CORTMC, CORTTC)
values ('*', 'TP200043', 5, 'TRN', 'DPS004', '1', '1', 10, '@__REQ__["sdgxflag"]@=="true" '||chr(38)||''||chr(38)||' @__REQ__["sta"]@=="true"', '@__REQ__["sta"]@=@__REQ__["TRN_DPS003"]["sta"]@;@__REQ__["prdcode"]@=@__REQ__["TRN_DPS003"]["prdcode"]@', 'local', '', '1', '1', '0', '', '');