i have noticed that if i run the query without the line:
mergedColumnsQuery.#currentColumn#
and if i dont add the mergedColumnsQuery query onto the from line then it works
fine but when i add these then it actually doesnt even time it, it just keeps
on loading the page and doesnt ever stop and jrun shoots up to use 70-80% of
the processing speed
does anyone have any clue why this would happen?
thanks
richard
> <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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:308380
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
