Ok so after a bit of guess work this is what I came
up with:
CFQUERY NAME="test"
DATASOURCE="ReservationSystem"SELECT
date_numFROM dbo.DatesTimes
Where class_num = 4;/CFQUERY
cfset date_nums = ArrayNew(1)cfloop
query="test"cfset date_nums[test.currentRow] = date_num
/cfloop
Is it
You
can view the results of a Query as an array.
So
your query...
CFQUERY
NAME="test"
DATASOURCE="ReservationSystem"SELECT
date_numFROM dbo.DatesTimes
Where class_num = 4;/CFQUERY
If test.recordcount
is greater than 0, you can access the results by using the following
syntax.