sql变量要用到别的变量怎么办？

wsryyffs

select workid FROM  a, b
where a.flow_no={NewParam_2}
and a.proc=b.workid
and b.stat=1

现在这样写失败，各位是否有好的办法？

xyuan007

char strsql[1024];
strcpy(strsql,"select workid FROM  a, bwhere a.flow_no=");
strcat(strsql,lr_eval_string("{NewParam_2}"));
strcat(strsql," and a.proc=b.workidand b.stat=1");

代码不一定100%正确，大概意思就这样

wsryyffs

录制的脚本为下面，NewParam_4要用NewParam_2，怎么实现
web_link("{NewParam_2}",
                "Text={NewParam_2}",
                "Snapshot=t7.inf",
                EXTRARES,
                "Url=stylesheet/blue_style/images/logo.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/head_bg1.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/tab3.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/tab4.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/line3.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/tab2.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                "Url=stylesheet/blue_style/images/line2.gif", "Referer=http://192.168.217.187:8080/webbusiness/direction.do?wid={NewParam_4}", ENDITEM,
                LAST);

wsryyffs

变量NewParam_4=select WORKITEM_INS_ID from BUS_SER_COMPLAIN a,RT_WORKITEMINST b
where a.flow_no='{NewParam_2}'
and a.PROC_ID=b.PROC_INSTANCE_ID
and b.CURRENT_STATE=1

变量NewParam_2是动态变化的，怎么实现呀？