> hi
>
> is there any reason why a basic query of query with only if statements
> and no loops would make the jrun processor shoot up and for it to
> eventually time out
>
> thanks
this is the code:
<cfquery name="newQuery" dbtype="query">
select query.subjectID
<cfif queryType neq "subject">
,query.projectID
</cfif>
<cfif queryType eq "testOccasion" or queryType eq "test">
,query.testOccasionID
</cfif>
<cfif arraylen(newColumnArray) gt 0>
,#arraytolist(newColumnArray)#
</cfif>
,mergedColumnsQuery.#currentColumn#
from query, mergedColumnsQuery
</cfabort>
there are 2 queries named as above, they both have data in them, the
currentcolumn does exist in the mergedcolumnquery, and the newColumnArray has 2
elements and both exist in the query
if i place an abort before the query of query then it aborts in a couple of
seconds, but if i place it after the query then it clogs up the jrun and just
times out
thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308363
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
