sql - How to handle space of postgresql query in wso2esb and wso2dss -



sql - How to handle space of postgresql query in wso2esb and wso2dss -

i'm using wso2esb 4.7.0 , wso2dss 3.1.0 , wish select records table..for have write dbs file in dss , it's configuration :

<query id="capp_select_emercontactid" useconfig="default"> <sql>select userid,mailid,phonenumber muser phonenumber = ? or mailid = ?</sql> <result element="entries" rowname="entry"> <element column="userid" name="userid" xsdtype="string"/> <element column="mailid" name="mailid" xsdtype="string"/> <element column="phonenumber" name="phonenumber" xsdtype="string"/> </result> <param name="phonenumber" ordinal="1" sqltype="string"/> <param name="mailid" ordinal="2" sqltype="string"/> </query> <operation disablestreaming="true" name="capp_select_emercontactid_op"> <call-query href="capp_select_emercontactid"> <with-param name="phonenumber" query-param="phonenumber"/> <with-param name="mailid" query-param="mailid"/> </call-query> </operation>

i have tried in seek service section.when set both conditions true it's working when set single status , 1 blank showing records nowadays in table

<p:capp_select_emercontactid_op xmlns:p="http://ws.wso2.org/dataservice"> **<p:phonenumber></p:phonenumber>** <p:mailid>youtility</p:mailid> </p:capp_select_emercontactid_op>

but if set blanks space in @ phonenumber it's working fine below..

<p:capp_select_emercontactid_op xmlns:p="http://ws.wso2.org/dataservice"> **<p:phonenumber> </p:phonenumber>** <p:mailid>youtility</p:mailid> </p:capp_select_emercontactid_op>

why so? how can handle space in esb?please refer next link db , query description : select query check both or either or condition

have u tried keeping default '?' field u r keeping blank in seek section , seek nail service. in dss whether maintain blank,?, or give space i'm getting proper response. m using dss 3.2.0

sql postgresql wso2 wso2esb wso2dss

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more