How do you pull a data set out of sql and assign variables to subsets of the data set in powershell.
Posted on 2016-08-05
How do you pull a data set out of sql and assign variables to subsets of the data set.
So in powershell i would like to run a query to grab some data and then go row by row to assign data to varibles.
The idea is I want check if a version of something before i publish and then check it after.
Name | VersionNumber |
and i want to assign:
TempVar1 = Blabla.flmx
TempVar2 = 346
so i would have to iterate through the record set. There are about 14 rows in all so not that big.
And then I would have to check it after the publish happens to the original.