CFTHREAD

Hi Experts,

I have two <cfoutput queries> that groups a large amount of data  and takes about 2-5 seconds to execute.  I would like to use <cfthread> to run these at the same time, however I am unsure of the exact format required.

My current test code is;

<cfthread action="run" name="go1">
  <cfquery name="getqaecounts" datasource="#dev#">
    select…
  </cfquery>

  <cfquery name="getqaecounts" datasource="#dev#">
    select…
  </cfquery>

</cfthread>

When I run the above code, the queryies do not display anything.  When I run the above code without the <CFTHREAD>, the results are displayed.

Thank you,

Eric
ehart12Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dgrafxConnect With a Mentor Commented:
<cfthread action="run" name="go1" priority="low">
<cfquery name="getqaecounts1" datasource="#dev#">
select somvar, someothervar
</cfquery>
<cfoutput query="getqaecounts1">
#somevar# - #someothervar#<br>
</cfoutput>
<cfquery name="getqaecounts2" datasource="#dev#">
select somvar, someothervar
</cfquery>
<cfoutput query="getqaecounts2">
#somevar# - #someothervar#<br>
</cfoutput>
</cfthread>
<cfthread action="join" timeout="10000" />

#go1.output#

in the cfthread block above (notice the priority=low) just code your queries and your output loops
then you join the thread with the current page
the go1.output will be the html output generated
you can also cfset vars within the cfthread
like you can put <cfset go1.getqaecounts2=getqaecounts2> within the cfthread
then after joining the thread you can do <cfdump var="#go1.getqaecounts1#">
0
 
ehart12Author Commented:
Hi dgrafx,

Thank you for the sample code.  I will give this a try and get back to you in the next few weeks with any questions.

Have a great day,

Eric
0
 
dgrafxCommented:
glad it helped ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.