web stats
com.mirth.connect.server.userutil.MirthCachedRowSe t error when running select db call - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2018, 04:43 AM
Kevin Carlin Kevin Carlin is offline
Mirth Newb
 
Join Date: Mar 2012
Posts: 18
Kevin Carlin is on a distinguished road
Default com.mirth.connect.server.userutil.MirthCachedRowSe t error when running select db call

Mirth 3.1.1.7461

I have a thread which is taking in a HL7 message and I am storing the data to a sql db.

One of the fields I have to store in the main DB is a patient location field. I have created a second db table (2 columns, one called hospital and one with the hospital code) with the values for the hospital location to call from. There are about 65 locations total.

Im getting the value from the MSH-4 field (where the vendor is sending it) and populating a value called "SourceCode". This works.

When I create and run the query below...

var query = "SELECT Hospital FROM "DB LOCATION" WHERE SourceCode = '"+$('SourceCode')+"'";

Its populating my DB field with this...

com.mirth.connect.server.userutil.MirthCachedRowSe t@bb0a1a8

Any idea what I may be doing wrong? Any help would be appreciated.

Last edited by Kevin Carlin; 07-11-2018 at 04:45 AM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Mirth Corporation