people = queryNew("name,dob", "varchar,date");
queryAddRow(people, 3);
people.name[1] = "barney";
people.dob[1] = createDate(1980, 6, 10);
people.name[2] = "heather";
people.dob[2] = createDate(1980, 2, 12);
people.name[3] = "emery";
people.dob[3] = createDate(2005, 8, 12)
Average age
#sum / people.recordCount# days
Alphabetic Sort
select *
from people
order by name
Name | DOB |
#name# |
#dateFormat(dob, "mmm d, yyyy")# |