[KCFusion] arrays and querys

2001-10-19 Thread Adaryl Wakefield
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

RE: [KCFusion] arrays and querys

2001-10-19 Thread Ellis, Randy
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.