oracle like 怎么传参数阿，高手！！！！

[killerman22]

sprintf(caCnclString," AND CDD_DEAL_IDNTY like %'%s'% ",pCDCDealInqryInBody->caDealSrno);
做模糊查询

我测试过用like \%'%s'\% , like '\%%s\%' , like '%%s%' .都不行，请高手指教阿 ， 在线等，谢谢各位 ……
测试的输出结果均为 ：...AND CDD_DEAL_IDNTY like ' AND CDD_STATUS_INDC = '2' ，like 后的%读不出来,传的值也读不出来。

[killerman22]

已解决。
在传参之前，我用strcpy(),strcat()把他们组合起来，再传进去的。

[killerman22]

按4楼，那样写，出现了错误。

[okifyou]

[Quote=引用楼主 killerman22 的帖子:]
sprintf(caCnclString," AND CDD_DEAL_IDNTY like %'%s'% ",pCDCDealInqryInBody->caDealSrno);
做模糊查询

我测试过用like \%'%s'\% , like '\%%s\%' , like '%%s%' .都不行，请高手指教阿 ， 在线等，谢谢各位 ……
测试的输出结果均为 ：...AND CDD_DEAL_IDNTY like ' AND CDD_STATUS_INDC = '2' ，like 后的%读不出来,传的值也读不出来。
[/Quote]
sprintf(caCnclString," AND CDD_DEAL_IDNTY like %'%s'%% ",pCDCDealInqryInBody->caDealSrno);

[xhs_lh04]

sprintf(caCnclString," AND CDD_DEAL_IDNTY like '%%%s%%' ",pCDCDealInqryInBody->caDealSrno);

[xhs_lh04]

sprintf(caCnclString," AND CDD_DEAL_IDNTY like '%%%s%%' ",pCDCDealInqryInBody->caDealSrno);

[青葱岁月不可追]

sprintf(caCnclString," AND CDD_DEAL_IDNTY like %s%s%s","%",pCDCDealInqryInBody->caDealSrno,"%"); 

这样写就好了啊

[青葱岁月不可追]

[Quote=引用 6 楼 killerman22 的回复:]
按4楼，那样写，出现了错误。
[/Quote]
哦？？？？

呵呵！~

informix我们平时都这么用，提前sprintf，strcat到一起性质一样啊。