He meant that in CF 4.0 (4.5) you would have to use CFLOOP. Something
like this
<CFLOOP query=myquery>
<CFIF myquerydata = mycriteria>
Insert into your new query / structure / array / whatever
</CFIF>
</CFLOOP>
At 09:08 PM 03/21/2001 +0800, you wrote:
>but what abt in CF4.0?
>
>JAIME HOI
>
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, March 21, 2001 8:59 PM
>To: CF-Talk
>Subject: RE: Can we do another select on a cfquery resultset?
>
>
>You can query a query in CF5 I believe. You would have to use <CFLOOP>.
>
>-----Original Message-----
>From: JAIME HOI [mailto:[EMAIL PROTECTED]]
>Sent: 21 March 2001 12:54
>To: CF-Talk
>Subject: Can we do another select on a cfquery resultset?
>
>
>
>hi
> i was juz wondering if it is possible to do a select on the resultset
>returned from <cfquery>?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists