software store

CFX_List2Query

CFX_List2Query only £5.00 (£6.00 inc. VAT) GBP ($7.59 USD)   BUY NOW!

CFX_List2Query is a high performance list manipulation tool that can convert huge (over 10,000 unique items) lists to a CF query structure in less than half a second.

By converting the list to a query, you are then free to manipulate the data in ways that are impossible in other structures including CF lists.

For example, if you need to know how many instances of a particular item exist in a list, use CFX_List2Query to convert the list to a query, then use Query of Query feature of Cold Fusion to interrogate the result.

CFX_List2Query usage:

<cfx_list2query name="Items" column="item" 
	list="a;b;c;d;e;f;b;a;e;g;s;" delimiter=";">
<cfquery name="NoOfBs" dbtype="query">
	SELECT COUNT(item) AS Total
	FROM Items
	WHERE Item = 'b'
</cfquery>
<cfoutput>#NoOfBs.Total#</cfoutput>

PLEASE NOTE: All our CFX tags and tools are for the Windows platform only.

Latest version released on 24-Jun-2004!

CFX_List2Query only £5.00 (£6.00 inc. VAT) GBP ($7.59 USD)   BUY NOW!

PLEASE NOTE: The price stated in USD is only an indication and payments collected by new media development will be converted at the rates prevailing at the time.