go to post ED Coder · Apr 7, 2020 Hi Vic, Thank you for reviewing my question. I had to censor everything :) but the adapter status changed as soon as the end point was connected. I thought it was a status that I had to update on the job and that confused me. Regards, Eric
go to post ED Coder · Apr 7, 2020 Hi Cristiano, thank you for getting back to me. You were right, our end point was down, and automatically the adapter was dequeued. As soon the connection was re-established it worked. The adapter status confused me, sorry. thank you so much. Regards, Eric
go to post ED Coder · Oct 31, 2019 Hi Craig, thank you so much for replying to my query and also sharing an example for me. The above solution helped me. Regards, Eric
go to post ED Coder · Sep 4, 2019 Thank You Guys, I found the method, and used your advice to getValueat(), this solved my question.
go to post ED Coder · Sep 4, 2019 Hi, solved this by using the following function:pRequest.SegCountGet() -> This gave me the number of segments in the HL7 Message, and because I knew that my required value is in the last segment in the 5th field, I could retrive it then using GetValueat()
go to post ED Coder · Aug 30, 2019 Thank You Marc, I tried that in my function, and its giving me the following errorNo such function foundRegards,Eric
go to post ED Coder · Aug 30, 2019 Hi Marc, thank you so much. Actually I had to edit my question. My aim is to get the 5th field value from the last OBX segment in my HL7 message. Because I can have varying number of OBX segments but I know that the value I want is in the last OBX segment. So I thought if I could get the number of segments in a message, and then index that to get the last segment I could get the value I want.Is there a better way to do that?Sorry for the confusion. Appreciate your help
go to post ED Coder · Aug 26, 2019 Awesome!!! I've always got superb guidance, and direction to all my questions. Thank you guys !!Nice to put faces to the people :) Great job guys !!
go to post ED Coder · Aug 21, 2019 This was solved by writing a new function with the PrepareW command. I had the mySQL 8.0 Unicode driver installed. I cannot understand why I had to write a new function but it works. Following are the checks to consider (that I made):1. Check the quotes against the values that you enter2. Test with PrepareW statements3. Increase the max_allocated_packet from 4M to 16M [in the more recent versions of mySQL it is default to 512M]Regards,Eric
go to post ED Coder · Aug 21, 2019 Hi Eduard, After using the prepareW statements the select query started working.I simply deleted the entire function, and re-wrote it again and it now works. Did nothing different, just deleted the function, and copied the code back into the new function.Cannot understand what the issue was. crazy. but solved nowEric
