Converts a series of lists into a Query. The Query can then be used just as if it was generated by a CFQUERY tag, etc.
| NAME | Required. The name of the new Query. |
| VARLIST | Required. A comma-separated list of CF variable names. Each of these variables should contain a list of values. Each variable will represent a row in the new query, and each element of the list contained in each variable will become that rows's data. |
| COLUMNLIST |
Required. The names that you would like to be used as the new query's column names, provided as a comma-separated list. VARLIST and COLUMN list must each have the same number of comma-separated items. |
| DELIMITER |
Optional. The delimiter used in the lists you specify in VARLIST. Default is the comma character. Please note that DELIMITER does not refer to how to the lists of variable names you're providing in VARLIST and COLUMN are delimited. The variable names must always be comma-separated. |
Example:
<CFSET Line1 = "A,1,Purple"> <CFSET Line2 = "B,2,Green"> <CFSET Line3 = "C,3,Blue"> <CFSET Line4 = "D,4,Yellow"> <CF_DatalistsToQuery NAME="MyQuery" VARLIST="Line1,Line2,Line3,Line4" COLUMNLIST="Letter,Number,Color"> <CFX_SHOWQUERY QUERY="MyQuery"> The above code would produce the following query:
| LETTER | NU |
|---|