CF_Struct_toQuery is a ColdFusion Custom Tag that allows you to convert a "struct type" variable into a "query-type" variable.

 

This component is very useful if you want to store related data into one variable. This will enable you for easier manipulation of data, for queries are associative and simple SQL synthax can be applied.

 

CF_Struct_toQuery is valuable in instances where you want to pass two related list of data as parameters. Like a field list and its data type for each field list.

 

   *Group related parameters into one variable (eg. fieldkey, fieldname, fielddatatype).

   *Use standard SQL to query set parameters.

   *Manipulate query data using standard SQL.

 

Example:
   *A test template is included the commercial file

 

   *I'll be using this tag on my parametized recordbrowser custom tag.