Solved

CFTHREAD

Posted on 2010-11-15
4
525 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:ehart12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34143932
0
 
LVL 25

Accepted Solution

by:
dgrafx earned 500 total points
ID: 34145098
<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
 

Author Comment

by:ehart12
ID: 34175128
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
 
LVL 25

Expert Comment

by:dgrafx
ID: 34303634
glad it helped ...
0

Featured Post

Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question