question Re: Passing in multiple attributes to ExecuteSQL in Archives of Support Questions (Read Only)

Passing in multiple attributes to ExecuteSQL

mliem — Tue, 28 Jun 2016 00:11:59 GMT

Hello,

I have an executeSQL processor that takes in two attributes ($fromDate and $toDate)

ex. select * from table where date > $fromDate and date <$toDate.

The data for these attributes are stored in separate files so my flow looks like this:

fetchFile->extractText->

executeSQL

fetchFile->extractText->

Even though both extractText are connected to the same execute SQL, what I'm noticing is that executeSQL will take only one of these variables and run. I want tobe able to pass in both at the same time before running. I am also surprised it's even able to run with only one parameter. Example, if I disabled either the top or bottom flow, the sql still executes fine. Does it used a cached value?

Re: Passing in multiple attributes to ExecuteSQL

mliem — Tue, 28 Jun 2016 01:25:26 GMT

nevermind, it looked like I was setting my attributes correctly. I combined both the toDate and fromDate into one file, and now my flow looks like:

fetchFile->extractText->executeSQL

fetchFile is from local FS, I use regex to pull the fields I need from the file and set them to their respective variables and use those variables in my executeSQL

Re: Passing in multiple attributes to ExecuteSQL

waghmithu — Fri, 18 Aug 2017 20:09:11 GMT

Hi mliem,can you share screenshot of the processor(properties)