Is there a PK that you know about? If so, you can do a QoQ.
<cfquery name="myQuery" dbType="query">
SELECT *
FROM theMainQuery
WHERE pk = 'keyYouAreLookingFor'
</cfquery>
----- Original Message -----
From: "Justin Balog" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 13, 2004 5:05 PM
Subject: RE: [CFCDev] Single Query Row
> Roger, but what if you want the whole row passed just as it is?
>
> Thanks for getting back to me on this one.
>
> -----Original Message-----
> From: Roland Collins [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 13, 2004 3:02 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [CFCDev] Single Query Row
>
>
> Use array-style notation:
>
> myQuery.myColumn[RowNumber]
>
> Roland
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Justin Balog
> Sent: Monday, December 13, 2004 4:54 PM
> To: '[EMAIL PROTECTED]'
> Subject: [CFCDev] Single Query Row
>
>
> Is there a way to reference individual rows with a query? i.e. Result
set
> of 10 records, I only want to pass record 6 to my CFC?
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email
> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
> in the message of the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported
> by Mindtool, Corporation (www.mindtool.com).
>
> An archive of the CFCDev list is available at
> [EMAIL PROTECTED]
>
>
>
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email
> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
> in the message of the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported
> by Mindtool, Corporation (www.mindtool.com).
>
> An archive of the CFCDev list is available at
> [EMAIL PROTECTED]
> ----------------------------------------------------------
> You are subscribed to cfcdev. To unsubscribe, send an email
> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
> in the message of the email.
>
> CFCDev is run by CFCZone (www.cfczone.org) and supported
> by Mindtool, Corporation (www.mindtool.com).
>
> An archive of the CFCDev list is available at
[EMAIL PROTECTED]
>
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev'
in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported
by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at
[EMAIL PROTECTED]
