query

RESULTSET

query
	NAME	TYPE
1	Example A	1
2	Example B	1
3	Example C	1
4	Example D	2
5	Example E	2
6	Example F	2
7	Example G	3
8	Example H	3
9	Example I	3

CACHED

false

EXECUTIONTIME

31

SQL

select name, type from demo

query

RESULTSET

query
	NAME	TYPE
1	Example A	1
2	Example B	1
3	Example C	1

CACHED

false

EXECUTIONTIME

0

SQL

select type, name from MasterQuery where type = 1 order by Name

query

RESULTSET

query
	NAME	TYPE
1	Example D	2
2	Example E	2
3	Example F	2

CACHED

false

EXECUTIONTIME

15

SQL

select type, name from MasterQuery where type = 2 order by Name

query

RESULTSET

query
	NAME	TYPE
1	Example G	3
2	Example H	3
3	Example I	3

CACHED

false

EXECUTIONTIME

0

SQL

select type, name from MasterQuery where type = 3 order by Name

type 1:

//Extra ,

Example A, Example B, Example C,

//Using Coldfusion Valuelist no extra ,

type 1:

Example A, Example B, Example C

type 2:

Example D, Example E, Example F

type 3:

Example G, Example H, Example I