You can reference a query in cfscript:
<cfquery name="qryName">
select
col1, col2
from
....
</cfquery>
<cfscript>
rownum = 0;
while (row lt qryName.RecordCount)
{
rownum = IncrementValue(rownum);
col1= qryName.col1[rownum];
col2 = qryName.col2[rownum];
}
</cfscript>
On 10/19/06, Richard White <[EMAIL PROTECTED]> wrote:
>
> Hi, i hope this is a very simple question! but i want to be able to call a
> query but i want the result of the query to be stored in a structure format
> so that i can use in cfscript, the only examples i can find is if the result
> is used in a <cfoutput query"queryName"></cfoutput tags.
>
> could someone possibly provide a simple example on how to store the result
> in a sturcture format so that i can use it in cfscript
>
> thanks very much
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257500
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
