can anyone assist in building a matrix in Boost based on sql data queries? Actually:

matrix<double> pricemat(rowCount,colCount);
            for (unsigned i = 0; i < pricemat.size1 (); ++ i)
                for (unsigned j = 0; j < pricemat.size2 (); ++j)
                    pricemat (i, j) = cmd2[3].asDouble();
                    std::cout << pricemat << std::endl;

prints a [221,3] , matching my expectations:

(rowCount =221 & colCount=3)

However the elements of the matrix are not. Values from cmd2[3].asDouble() are not logically stored as matrix elements for (unsigned i = 0; i < pricemat.size1 (); ++ i) and for (unsigned j = 0; j < pricemat.size2 (); ++j) .

Main issue: since one cannot index cmd2[...].asDouble, the challenge consists of getting in the matrix columns/rows of

pricemat distinct cmd2[3].asDouble() values  for j= 0; j=1, and j=2 and i=0 to 220;

Hope the explanation is clear enough as this is a tricky case

On Sunday, 17 August 2014, 18:59, Ismael Fadiga <ismaeltfadiga@yahoo.co.uk> wrote:

hi all

After executing the below sql query in c++, the printed results are:

WITH rnum AS (SELECT s.ISN, s.Date, ClosedPrice, row_number() OVER (partition BY s.ISN ORDER BY s.ISN, s.Date DESC) AS rownumber FROM SecurityData s INNER JOIN PortfolioHoldings p ON s.ISN = p.ISN WHERE p.Pfid = 1876) SELECT DISTINCT ISN, Date, ClosedPrice FROM rnum WHERE rownumber <= 250))

//ID Date Price

US345 2014-08-17 342

US345 2014-08-16 310

...

FR123 2014-08-17 18.20

FR123 2014-08-16 15

Does anyone know how to build a price matrix for the IDs like:?

|342 18.20|

MAT=|310 15 |

|... ... |

Your feedback would be very appreciated

Cheers