One Star

How to retrieve values from tMySqlRow within a tIterateToFlow

I need to be able to extract a list of id's from an XML file. Then run a SQL query into a DB and see if that id exists in the DB. Then I need to make a decision based on whether the id is in the DB or not.
Any recommendations on how best to do this?
I am running the following:
tFileInputMSXML -> tFlowToIterate ->tMySqlRow -> tIterateToFlow -> tLogRow
The SQL query in the tMySqlRow is :
"SELECT '1' as idExists FROM Sales WHERE id = '"
+((String)globalMap.get("XML.id"))+
"'"
My problem is that I don't see how to get access to the value of idExists.
I suppose it really is about understanding how to log output while inside a tIterate.
Anyone know how to get this done ?
glen
openbusinessassociates
2 REPLIES
One Star cri
One Star

Re: How to retrieve values from tMySqlRow within a tIterateToFlow

Hi,
instead of using
tFileInputMSXML -> tFlowToIterate ->tMySqlRow -> tIterateToFlow -> tLogRow
I would try to use
tFileInputMSXML -> tFlowToIterate ->tMySqlInput -> tLogRow

for the SELECT statement in tMySQLInput you can use the statement you pasted in your post.

HTH
Christian
One Star

Re: How to retrieve values from tMySqlRow within a tIterateToFlow

ACE. Works. Tks