I'm sure this is a pretty common action but for some reason I can't get it to work. A little help would be appreciated. Ive tried to search the forums and found a few articles but haven't been able to figure it out yet.
All I want to do is run a sql query and display the results in a dropdown for the user to select a value.
I've followed one post in the forum to create an adodataset iterator and an enhanced Prompt for Variables.
The ADO Dataset Iterator executes and I can see the log, but it seems like only the last value gets saved to my custom variable, not the whole list.
How do I display the whole dataset from the query as a seperate option in the dropdown?
In the log, do you see the variable get set to each row in the dataset? After its done executing it makes sense it will only have the last value. Assuming its iterating correctly, you could add a child action under the iterator to append to a new/different variable with the value from the iterator variable, with a CRLF or TAB separator between. I haven’t used the dataset iterator before though, so this is just theoretical based on my experience with other iterators.
The variable that you have specified in the iterator action will be set to a value each iteration, not appended too. You will need to use a second variable to build up the list of values returned each iteration (using the Append To Variable action).