View Full Version : Results with repeated values
03-01-2007, 08:54 PM
Hi i am working with an outbound channel, i am able get the output as hl7 files from database reader, I have only 15 rows in my table, But i got lot of repeated values, Is there any way to stop writing files..
thanks in advance
03-02-2007, 05:16 AM
After reading a row from the database you need to somehow mark it as having been read. I usually have Mirth just set a 'has_been_sent' column to true after it reads a row. Then when you SELECT rows just pick the ones where 'has_been_sent' = false
03-02-2007, 06:35 AM
You may also refer the following post which has a sample SELECT and UPDATE statement:
Send outbound msg only once and update database column after sending?
03-13-2007, 05:04 AM
Thanks a lot..
vBulletin® v3.8.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.