Hi Eric > One other question I have about the dblookup mediator is whether it can > handle multiple record sets. In the SQL I used, I had a select * from > company. (without a where clause). I wished to have all the matching > records. However , the 'result' node seems capable of holding only one row. > I want the client to get all the matching records out of an SQL query. Is it > possible to achieve this in Synapse with the dblookup mediator. > We developed the DBLookup mediator to be able to perform simple DB related lookups for message enrichment and routing by looking at values in a DB table etc. It would be a straightforward to get the current DBLookup mediator code and extend it to satisfy your custom needs if required, but currently the code will only pick the first record from the result set.
asankha --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
