> but what abt in CF4.0?
Not within CF4.0.
To achieve the same effect, you could do this (never tried it... hope that
someone will correct me if the order or syntax is wrong)
- CFLOOP over the original record set
- use CFIF to see if a column's value matches your criteria
- append rows that match to a list
- CFLOOP over your list like this
<CFLOOP FROM="1" TO="#ListLen(variables.YourList)#" INDEX="CurrentRow">
#YourQuery.ColumnName[CurrentRow]#
</CFLOOP>
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists