Webmaster Forum / ColdFusion / Advanced Techniques / July 2008

Hi,

I have an array like this :

DATA  |   YEAR   |   SCENARIO   |  JAN  |   FEB   |   MAR   |   ....
data1        2008             1                120       101         109  
data2        2008             2                120       105         104  
data3        2007             1                100       108         111  
data4        2008             1                124       101         116  

and I want to search something like we do with a query but on an array

SELECT JAN
FROM myArray
WHERE
YEAR = 2008
AND SCENARIO = 1
AND DATA=  data3

is it possible ? and how to do it ?

Thanks !