- DTN Headline News
Ag Weather Forum
By John Baranick
Friday, October 2, 2026 9:41AM CDT

As expected, another week of heavy rain has inundated parts of the country. This was discussed late last week here, https://www.dtnpf.com/…, when it became obvious that the remnants of Hurricane Polo were going to move through a large portion of the U.S., bringing areas of heavy rain and slowing down the progress for fall harvest and winter planting. The system is on its way out, and a drier pattern is settling into the country. Though it has been a rough September with lots of rain across widespread areas of the Corn Belt, the pattern is starting to become more favorable for fieldwork.

With a cold front meeting the remnants of Hurricane Polo, rainfall has been intense this week. A widespread, solid zone of more than an inch of rain fell from the Four Corners area into the Great Lakes. Most areas saw more than two inches. Some pockets of extremely heavy rain exceeded four inches. And a couple of places in Nebraska and across Texas saw more than eight inches. That is on top of some rather hefty amounts from the previous two weeks, which also hit parts of the Plains and Midwest. Widespread flood watches were posted ahead of the rainfall this week and flood advisories were scattered across the region when the heaviest rains moved through. Though the rain is moving southeast on Friday, Oct. 2, 2026, and will continue through the Southeast over the coming weekend, the water left behind will take quite some time to recede, especially in areas with more clay in their soil texture as well as low-lying areas.

The rain couldn't have come at a worse time for harvest. Producers watched their crops mature early in late August and early September, only to have them get extremely wet from about mid-September now into the first couple of days of October. According to data from the Iowa Environmental Mesonet, rainfall in September reached a top 10 ranking in multiple climate districts from Arizona to Wisconsin as well as in parts of Indiana, Ohio, and the Dakotas as a very active weather pattern across the north set the tone for the heavy rain repeatedly throughout much of the month. The inclusion of a remnant hurricane at the end of the month made things worse across the Southwest and into the Plains. Pictures posted on X of sprouting corn and flooded fields are making their way around, showcasing some of the damage over the last few weeks.

The silver lining to the rainfall is that it is going a long way to reducing the extreme drought across some areas of the Southwest and Plains. For producers that grow winter crops or have pastures and rangeland for livestock, the water will be a long-term benefit in helping to green up existing plants and set the table for good establishment of winter crops. Despite the boost in water, rainfall deficits are still extremely large in the region. Steady, consistent rainfall will be needed to truly eliminate the drought.

But that will be a tough task over the coming weeks. The weather pattern is shifting, moving an upper-level ridge from the Southeast back toward the West. In doing so, the ridge will create a block in the pattern for the western half of the country. Disturbances will move over the ridge through western Canada and deepen as they move into the eastern U.S. and Canada. But these systems should be moisture-starved, much like clipper systems in winter. Several systems will be moving through Canada, and their cold fronts will move through the U.S., particularly across the north, but the prospect for additional rainfall will be quite low. Unless these systems develop farther south into the U.S. and are able to bring up moisture from the Gulf of Mexico (Gulf of America), only isolated showers should be expected. With the ridge also providing warmer air eastward through the country, this will allow wet and flooded areas a good chance to dry out quickly.

This type of setup is expected to last through much of the month of October. Though rain will still fall at times, the risks are lower for heavy amounts, and the general forecast is calling for below-normal rainfall for all areas of the country outside of the immediate Gulf Coast and Florida, which are staying active into next week. In the short term, that will help with the receding floodwater. But in the long term, we could see more drought growth in areas that did not see heavy rain over the last month, particularly in some areas of the Great Basin and Southeast.

You can make your own maps from the excellent data at the Iowa Environmental Mesonet here: https://mesonet.agron.iastate.edu/….

To stay up to date with weather conditions and your local forecast for free from DTN, head over to https://www.dtnpf.com/…

John Baranick can be reached at john.baranick@dtn.com


blog iconDTN Blogs & Forums
DTN Market Matters Blog
Editorial Staff
Friday, October 2, 2026 12:08PM CDT
Monday, September 28, 2026 9:32AM CDT
Friday, September 25, 2026 12:11PM CDT
Fundamentally Speaking
Joel Karlin
DTN Contributing Analyst
Wednesday, September 30, 2026 10:45AM CDT
Thursday, September 24, 2026 9:45AM CDT
Thursday, September 24, 2026 9:45AM CDT
DTN Ag Policy Blog
Chris Clayton
DTN Ag Policy Editor
Thursday, October 1, 2026 8:46AM CDT
Wednesday, September 30, 2026 3:17PM CDT
Wednesday, September 30, 2026 3:17PM CDT
DTN Ag Weather Forum
Bryce Anderson
DTN Ag Meteorologist and DTN Analyst
Friday, October 2, 2026 9:42AM CDT
Tuesday, September 29, 2026 9:07AM CDT
Tuesday, September 29, 2026 9:07AM CDT
DTN Production Blog
Pam Smith
Crops Technology Editor
Monday, September 28, 2026 10:06AM CDT
Monday, September 28, 2026 10:06AM CDT
Monday, September 14, 2026 4:30PM CDT
Harrington's Sort & Cull
John Harrington
DTN Livestock Analyst
Monday, September 28, 2026 3:42PM CDT
Monday, September 21, 2026 3:37PM CDT
Monday, September 14, 2026 3:24PM CDT
An Urban’s Rural View
Urban Lehner
Editor Emeritus
Thursday, October 1, 2026 10:25AM CDT
Thursday, September 17, 2026 6:37AM CDT
Wednesday, September 9, 2026 7:20AM CDT
Machinery Chatter
Dan Miller
Progressive Farmer Senior Editor
Monday, April 20, 2026 11:09AM CDT
Monday, January 19, 2026 1:10PM CDT
Friday, November 14, 2025 8:44AM CDT
Canadian Markets
Cliff Jamieson
Canadian Grains Analyst
Wednesday, September 9, 2026 10:24AM CDT
Thursday, August 27, 2026 11:54AM CDT
Thursday, August 27, 2026 11:54AM CDT
Editor’s Notebook
Greg D. Horstmeier
DTN Editor-in-Chief
Friday, July 3, 2026 5:23AM CDT
Monday, June 29, 2026 8:06AM CDT
Thursday, June 18, 2026 8:59AM CDT
Copyright DTN. All rights reserved. Disclaimer.
Powered By DTN


Debugging Information
ColdFusion Server Standard 2023,0,25,330977
Template /index.cfm
Time Stamp 11-Oct-26 06:07 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 216.73.217.152
Host Name 216.73.217.152


Execution Time

Total Time Avg Time Count Template
85 ms 85 ms 1 D:/ColdFusion2023/cfusion/wwwroot/index.cfm
40 ms 40 ms 1 D:/aghost/contexts/common/share/body.cfm
37 ms 37 ms 1 D:/aghost/contexts/common/share/headlinenews.cfm
32 ms 32 ms 1 D:/aghost/contexts/common/share/news_dtnag_package.cfm
27 ms 27 ms 1 D:/aghost/contexts/common/share/dtnBlogsForums.cfm
24 ms 24 ms 1 D:/aghost/contexts/common/share/header232.cfm
20 ms 3 ms 7 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc | execute([complex value]) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc
19 ms 19 ms 1 D:/aghost/contexts/common/share/company_include.cfm
7 ms 7 ms 1 CFC[ D:/ColdFusion2023/cfusion/wwwroot/Application.cfc | onRequestStart(/index.cfm) ] from D:/ColdFusion2023/cfusion/wwwroot/Application.cfc
6 ms 6 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/svc/security/AuthorizationSVC.cfc | generateAgHostToken(dxc = [complex value]) ] from D:/aghost/CFC/com/dtn/aghost/svc/security/AuthorizationSVC.cfc
5 ms 5 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/svc/system/DelegateSVC.cfc | process(dxc = [complex value]) ] from D:/aghost/CFC/com/dtn/aghost/svc/system/DelegateSVC.cfc
5 ms 5 ms 1 D:/aghost/CustomTags/jquery.cfm
4 ms 1 ms 3 D:/aghost/CustomTags/queryTreeSort.cfm
4 ms 1 ms 3 D:/aghost/contexts/common/share/serverpath.cfm
3 ms 3 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/dmc/security/AgHostTokenDMC.cfc | createDO(CustomerID = 3457, AccountType = aghost, UserID = 0, SiteID = 1) ] from D:/aghost/CFC/com/dtn/aghost/dmc/security/AgHostTokenDMC.cfc
2 ms 2 ms 1 D:/aghost/CustomTags/charts/AgOnlineChart_Popup.cfm
2 ms 0 ms 43 D:/aghost/CustomTags/news/publishDateTimeFormat.cfm
2 ms 2 ms 1 D:/aghost/contexts/common/share/headermenu.cfm
1 ms 1 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/dmc/security/AgHostTokenDMC.cfc | encryptDO([complex value]) ] from D:/aghost/CFC/com/dtn/aghost/dmc/security/AgHostTokenDMC.cfc
1 ms 0 ms 6 D:/aghost/CustomTags/convertcolor.cfm
1 ms 1 ms 1 D:/aghost/WEB/site/ui/superfish.cfm
1 ms 1 ms 1 D:/aghost/contexts/common/share/checkservicelevel.cfm
1 ms 1 ms 1 D:/aghost/contexts/common/share/noindexsearch.cfm
1 ms 1 ms 1 D:/aghost/contexts/common/share/page_secure.cfm
1 ms 1 ms 1 D:/aghost/contexts/common/share/setdtnquerystring.cfm
1 ms 1 ms 2 D:/aghost/contexts/common/share/templatedtnmenu.cfm
1 ms 1 ms 1 //AgHostFSProd04.dtndmz.com/wwwdocs/aghost/static/js/detectcookiesettings.js
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/DataModelingComponentMapping.cfc | getQualifiedName(AgHostTokenDMC) ] from D:/aghost/CFC/com/dtn/aghost/framework/DataModelingComponentMapping.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc | getDXC(svc = AuthorizationSVC, task = generateAgHostToken, type = AgHost) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc | getDXC(svc = DelegateSVC, task = process, type = OnRequestStart) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc
0 ms 0 ms 4 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc | getDXC(svc = EnvironmentConfigSVC, task = getEnvironmentConfig) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc | setDXCHeader(svc = EnvironmentConfigSVC, task = getEnvironmentConfig, dxc = [complex value]) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceBroker.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc | getQualifiedName(AuthenticationSVC) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc | getQualifiedName(AuthorizationSVC) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc | getQualifiedName(DelegateSVC) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc
0 ms 0 ms 5 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc | getQualifiedName(EnvironmentConfigSVC) ] from D:/aghost/CFC/com/dtn/aghost/framework/ServiceComponentMapping.cfc
0 ms 0 ms 2 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/UtilityComponentMapping.cfc | getQualifiedName(DateUtility) ] from D:/aghost/CFC/com/dtn/aghost/framework/UtilityComponentMapping.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/framework/UtilityComponentMapping.cfc | getQualifiedName(StringUtility) ] from D:/aghost/CFC/com/dtn/aghost/framework/UtilityComponentMapping.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/svc/security/AuthenticationManagerSVC.cfc | getSecurityContext([complex value]) ] from D:/aghost/CFC/com/dtn/aghost/svc/security/AuthenticationManagerSVC.cfc
0 ms 0 ms 5 CFC[ D:/aghost/CFC/com/dtn/aghost/svc/system/EnvironmentConfigSVC.cfc | getEnvironmentConfig(dxc = [complex value]) ] from D:/aghost/CFC/com/dtn/aghost/svc/system/EnvironmentConfigSVC.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/utility/DateUtility.cfc | DateTimeFormat2(dateTime = {ts '2026-10-11 23:37:49'}, separator = T, dateMask = yyyy-mm-dd, timeMask = HH:mm:ss.000Z) ] from D:/aghost/CFC/com/dtn/aghost/utility/DateUtility.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/utility/DateUtility.cfc | dateTimeFormat2({ts '2026-10-11 18:07:49'}, yyyy-mm-dd, HH:mm:ss) ] from D:/aghost/CFC/com/dtn/aghost/utility/DateUtility.cfc
0 ms 0 ms 1 CFC[ D:/aghost/CFC/com/dtn/aghost/utility/udf/StringUtility.cfc | EZeroFormat(3457, 1) ] from D:/aghost/CFC/com/dtn/aghost/utility/udf/StringUtility.cfc
0 ms 0 ms 2 D:/aghost/CustomTags/css.cfm
0 ms 0 ms 1 D:/aghost/CustomTags/editcustuseraccountreturnto.cfm
0 ms 0 ms 3 D:/aghost/CustomTags/listFromQueryTree.cfm
0 ms 0 ms 2 D:/aghost/CustomTags/rendertext.cfm
0 ms 0 ms 2 D:/aghost/CustomTags/udfinclude.cfm
0 ms 0 ms 1 D:/aghost/UDF/ValidateRequestPath.cfm
0 ms 0 ms 1 D:/aghost/UDF/varsvalidate.cfm
0 ms 0 ms 1 D:/aghost/contexts/common/share/com/getwxkey.cfm
0 ms 0 ms 1 D:/aghost/contexts/common/share/editcustuseraccountgeneratereturntostring.cfm
0 ms 0 ms 1 D:/aghost/contexts/common/share/footer232.cfm
0 ms 0 ms 1 D:/aghost/contexts/common/share/showad.cfm
0 ms 0 ms 1 D:/aghost/contexts/common/share/showadbasic.cfm
0 ms 0 ms 3 D:/aghost/contexts/common/share/templateDynamicMenu.cfm
0 ms 0 ms 2 //AgHostFSProd04.dtndmz.com/wwwdocs/aghost/static/js/cookie.js
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
94 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getMktCustID (Datasource=Ag, Time=1ms, Records=0) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT MarketerCustomerID
		FROM MarketerCustomer
		WHERE AgHostCustID = ?
			AND status = 1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3457

getcustsite (Datasource=Host, Time=1ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT TOP 1 *, ISNULL(WebSiteZip, Zip) AS Customer_Zip, WebSiteWeatherStationID as DefaultWXStation,
			(select top 1 ccp.useProducerAgreement
			from [CustCashBidPref] ccp
			WHERE ccp.CustID = cs.CustID
			AND ccp.SiteID = cs.SiteID) as ProducerAgreementForce,
			(select top 1 ccp.ProducerAgreementDTstamp
			from [CustCashBidPref] ccp
			WHERE ccp.CustID = cs.CustID
			AND ccp.SiteID = cs.SiteID) as ProducerAgreementDTstamp
		FROM CustSite cs
		WHERE cs.CustID = ?
			AND cs.SiteID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getCustServiceCodes (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT dbo.getServiceCodes(
			  ?
			, ?
			, getDate()
			, getDate()
		) AS theServiceCodes
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3457
Parameter #2(cf_sql_integer) = 1

PremiumExchanges (Datasource=Ag, Time=0ms, Records=15, Cached Query) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT ExchangeId, [Name]
			FROM Exchange
			WHERE Premium = 1
AuthorizedPremiumExchanges (Datasource=host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT CodeValue
			FROM CustServices
			WHERE CustID = ?
				AND SiteID = ?
				AND ServiceCode = 'FULLQUOTES'
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getSecureDtnMenuItems (Datasource=Host, Time=0ms, Records=0) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT dtnMenuID
		FROM custDtnMenuSecure
		WHERE custID = ?
			AND siteID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3457
Parameter #2(cf_sql_integer) = 1

CustTemplate (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT TOP 1 *
		FROM CustTemplate
		WHERE CustID = ?
			AND SiteID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

DTNMenuDetails (Datasource=Host, Time=2ms, Records=8) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT m.[id] AS DtnMenuID, m.[name], m.agCatID, m.[action] AS StandardAction, o.[Action] AS OverridingAction, adx.AdSlotID
				FROM DTNMenu m
					LEFT OUTER JOIN DTNMenuActionOverride o ON m.[ID] = o.DTNMenuID
						AND o.ServiceCode IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					LEFT OUTER JOIN adSlotMenuXRef adx ON m.[ID] = adx.dtnMenuID
						AND adx.CustID = ?
						AND adx.SiteID = ?
				WHERE m.[ID] IN (?,?,?,?,?,?,?,?,?)
				
					AND m.[name] NOT IN ('Quotes','Futures Markets','Options')
				
				ORDER BY CHARINDEX(',' + CONVERT(varchar(50),m.[id]) + ',',?),
					ISNULL(o.Priority,0)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGOCHARTS
Parameter #2(cf_sql_varchar) = BASIC150
Parameter #3(cf_sql_varchar) = CANNEWS
Parameter #4(cf_sql_varchar) = CCBEMAIL
Parameter #5(cf_sql_varchar) = CCBSMS
Parameter #6(cf_sql_varchar) = CSHBD
Parameter #7(cf_sql_varchar) = CSHBDCSV
Parameter #8(cf_sql_varchar) = CSHOFFNAGO
Parameter #9(cf_sql_varchar) = CUSTTXTMSG
Parameter #10(cf_sql_varchar) = DOCLIB
Parameter #11(cf_sql_varchar) = DTNAGPKG
Parameter #12(cf_sql_varchar) = FULLQUOTES
Parameter #13(cf_sql_varchar) = FUTURESMS
Parameter #14(cf_sql_varchar) = NOFUTURES
Parameter #15(cf_sql_varchar) = USRBLTN
Parameter #16(CF_SQL_INTEGER) = 3457
Parameter #17(CF_SQL_INTEGER) = 1
Parameter #18(cf_sql_integer) = 1
Parameter #19(cf_sql_integer) = 65
Parameter #20(cf_sql_integer) = 3
Parameter #21(cf_sql_integer) = 33
Parameter #22(cf_sql_integer) = 39
Parameter #23(cf_sql_integer) = 68
Parameter #24(cf_sql_integer) = 47
Parameter #25(cf_sql_integer) = 73
Parameter #26(cf_sql_integer) = 88
Parameter #27(cf_sql_varchar) = ,1,65,3,33,39,68,47,73,88,

TemplateImage (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT TOP 1 [name], image
		FROM TemplateImages
		WHERE ImageID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8

GetTemplate (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT TOP 1 *
		FROM templates
		WHERE templateID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 232

GetColorScheme (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT TOP 1 *
		FROM ColorScheme
		WHERE CSID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 784

GetAugmentingSites (Datasource=Host, Time=0ms, Records=0) in D:\aghost\contexts\common\share\company_include.cfm @ 18:07:49.049
SELECT *
		FROM CustSiteAugmentingSiteXref
		WHERE CustID = ?
		  AND SiteID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3457
Parameter #2(cf_sql_integer) = 1

CheckForRSS (Datasource=Host, Time=0ms, Records=0) in D:\aghost\contexts\common\share\noindexsearch.cfm @ 18:07:49.049
SELECT cm2.MenuName, x.*
		FROM CustMenu cm
		  INNER JOIN RSSPageXref x ON cm.CustID=x.CustID AND cm.SiteID=x.SiteID AND cm.MenuID=x.MenuID
		  INNER JOIN CustMenu cm2 ON cm2.CustID=x.CustID AND cm2.SiteID=x.SiteID AND cm2.MenuID=x.SourceMenuID
		WHERE cm.CustID = ?
		  AND cm.SiteID = ?
		  AND cm.MenuType = 42
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3457
Parameter #2(cf_sql_integer) = 1

SecCnt (Datasource=Host, Time=0ms, Records=1) in D:\aghost\contexts\common\share\headermenu.cfm @ 18:07:49.049
SELECT COUNT(*) AS LoginCnt
	FROM CustMenu
	WHERE custid = ?
		AND siteID = ?
		AND visible = 'C'
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getTheCustSiteMenu (Datasource=host, Time=1ms, Records=5) in D:\aghost\contexts\common\share\headermenu.cfm @ 18:07:49.049
SELECT CASE TypeAction
				WHEN 0 THEN menuURL	
				WHEN 1 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 2 THEN menuURL									
				WHEN 3 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 4 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 5 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 6 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				WHEN 7 THEN MenuHRef + '&mid=' + LTRIM(STR(menuID))		
				ELSE 'index.cfm'		
			END AS useThisHref, *
		FROM CustMenu c
			INNER JOIN MenuTypes m ON c.MenuType = m.TypeID
		WHERE c.CustID = ?
			AND c.SiteID = ?
			AND c.Visible = ?
		ORDER BY menusort
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_VARCHAR) = Y

TemplateMenus (Datasource=Host, Time=1ms, Records=3) in D:\aghost\contexts\common\share\header232.cfm @ 18:07:49.049
SELECT [Name], Rank, Depth
					FROM TemplateMenu
					WHERE TemplateID = ?
					ORDER BY Rank
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 232

GetDTNMenuItems (Datasource=Host, Time=1ms, Records=1) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getTheDynamicMenu (Datasource=Host, Time=0ms, Records=11) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = ,1,65,3,33,39,68,47,73,88,
Parameter #2(CF_SQL_INTEGER) = 3457
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 1

GetDTNMenuItems (Datasource=Host, Time=0ms, Records=1) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getTheDynamicMenu (Datasource=Host, Time=1ms, Records=0) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = ,1,65,3,33,39,68,47,73,88,
Parameter #2(CF_SQL_INTEGER) = 3457
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 2

GetDTNMenuItems (Datasource=Host, Time=0ms, Records=1) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT DTNMenu, InvisibleDtnMenu
	FROM CustTemplate
	WHERE CustID = ?
		AND SiteID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3457
Parameter #2(CF_SQL_INTEGER) = 1

getTheDynamicMenu (Datasource=Host, Time=0ms, Records=0) in D:\aghost\CustomTags\queryTreeSort.cfm @ 18:07:49.049
SELECT i.SiteMenuItemID
					,i.MenuID
					,i.NodeType
					,i.ParentNodeID
					,i.NodeDesc
					,i.NodeAliasName
					,i.SortOrder
					,i.MenuRank
					,CASE i.NodeType
						WHEN 1 THEN 
							CASE WHEN mt.TypeAction IN (0,2) THEN cm.MenuURL
							ELSE mt.MenuHRef + '&mid=' + LTRIM(STR(cm.menuID)) END
						ELSE NULL 
					END AS URL
					,cm.MenuTarget
					,mt.TypeAction
					,cm.MenuType
					,cm.PageOrder
					,cm.windowSize
					,CASE i.NodeType
						When 1 Then
							CASE 
								When cm.visible = 'N' Then 'N'
								When cm.visible = 'C' Then 'C'
								ELSE 'Y' 
							END
						WHEN 0 THEN
							CASE 
								WHEN CHARINDEX(','+CONVERT(varchar(10),i.MenuID)+',',?) > 0 THEN 'Y'
								ELSE 'N' 
							END
						WHEN 2 THEN 'Y'
						WHEN 3 THEN 'N'
						ELSE NULL
					END AS Visible,
					CASE i.NodeType
						WHEN 1 THEN cm.MenuSecurity
						ELSE NULL
					END AS MenuSecurity
			FROM SiteMenuItem i
				LEFT OUTER JOIN CustMenu cm ON i.CustID = cm.CustID AND i.SiteID = cm.SiteID AND i.MenuID = cm.MenuID AND i.NodeType = 1
				LEFT OUTER JOIN MenuTypes mt ON cm.MenuType = mt.TypeID
			WHERE i.CustID = ?
				AND i.SiteID = ?
				AND i.MenuRank = ?
				AND i.NodeType IN (1,2,0)
			ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = ,1,65,3,33,39,68,47,73,88,
Parameter #2(CF_SQL_INTEGER) = 3457
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 3

getwxkey (Datasource=Ag, Time=0ms, Records=1) in D:\aghost\contexts\common\share\com\getwxkey.cfm @ 18:07:49.049
SELECT WxDomain, WxHour, WxKey
		FROM   AgWxKey
		WHERE  Id = 1
getServiceLevelServiceCodes (Datasource=Host, Time=1ms, Records=1) in D:\aghost\contexts\common\share\checkservicelevel.cfm @ 18:07:49.049
SELECT dbo.getServiceCodes(3457, 1, getDate(), getDate()) AS theServiceCodes
Story (Datasource=Ag, Time=0ms, Records=1) in D:\aghost\contexts\common\share\news_dtnag_package.cfm @ 18:07:49.049
SELECT s.Title, s.SubTitle, s.PublishDate, s.Content, RTRIM(s.Author) AS Author
			FROM AgOnlineNewsStory s
			  INNER JOIN AgOnlineNewsProductXref x ON x.LPN = s.Page
			WHERE x.Product = '/aghost/agnews1'
				AND s.Page = ?
				AND s.Page NOT IN ( 
			  	SELECT Page 
			  	FROM AgOnlineNewsExcludeStory 
			  	WHERE OverridingServiceCode IS NULL 
			  	   OR OverridingServiceCode NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 0702BF51
Parameter #2(cf_sql_varchar) = AGOCHARTS
Parameter #3(cf_sql_varchar) = BASIC150
Parameter #4(cf_sql_varchar) = CANNEWS
Parameter #5(cf_sql_varchar) = CCBEMAIL
Parameter #6(cf_sql_varchar) = CCBSMS
Parameter #7(cf_sql_varchar) = CSHBD
Parameter #8(cf_sql_varchar) = CSHBDCSV
Parameter #9(cf_sql_varchar) = CSHOFFNAGO
Parameter #10(cf_sql_varchar) = CUSTTXTMSG
Parameter #11(cf_sql_varchar) = DOCLIB
Parameter #12(cf_sql_varchar) = DTNAGPKG
Parameter #13(cf_sql_varchar) = FULLQUOTES
Parameter #14(cf_sql_varchar) = FUTURESMS
Parameter #15(cf_sql_varchar) = NOFUTURES
Parameter #16(cf_sql_varchar) = USRBLTN

HeadlineNews (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\news_dtnag_package.cfm @ 18:07:49.049
SELECT TOP 3 h.Page, h.Title, h.SubTitle, h.StorySummary, h.PublishDate
		FROM AgOnlineNewsHeadline h
		  INNER JOIN AgOnlineNewsProductXref x ON x.LPN = h.Page
		WHERE x.Product = '/aghost/agnews1'
		AND h.Page NOT IN ( 
	  	SELECT Page 
	  	FROM AgOnlineNewsExcludeStory 
	  	WHERE OverridingServiceCode IS NULL 
	  	   OR OverridingServiceCode NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
		ORDER BY h.PublishDate DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGOCHARTS
Parameter #2(cf_sql_varchar) = BASIC150
Parameter #3(cf_sql_varchar) = CANNEWS
Parameter #4(cf_sql_varchar) = CCBEMAIL
Parameter #5(cf_sql_varchar) = CCBSMS
Parameter #6(cf_sql_varchar) = CSHBD
Parameter #7(cf_sql_varchar) = CSHBDCSV
Parameter #8(cf_sql_varchar) = CSHOFFNAGO
Parameter #9(cf_sql_varchar) = CUSTTXTMSG
Parameter #10(cf_sql_varchar) = DOCLIB
Parameter #11(cf_sql_varchar) = DTNAGPKG
Parameter #12(cf_sql_varchar) = FULLQUOTES
Parameter #13(cf_sql_varchar) = FUTURESMS
Parameter #14(cf_sql_varchar) = NOFUTURES
Parameter #15(cf_sql_varchar) = USRBLTN

CurrentStories (Datasource=Ag, Time=0ms, Records=2) in D:\aghost\contexts\common\share\news_dtnag_package.cfm @ 18:07:49.049
SELECT TOP 1 Page, StorySummary, PublishDate
		FROM AgOnlineNewsHeadline
		WHERE Page IN (
			SELECT LPN 
			FROM AgOnlineNewsProductXref
			WHERE Product = 'GRAINCOMMENTARY'
		)
		AND Page NOT IN ( 
	  	SELECT Page 
	  	FROM AgOnlineNewsExcludeStory 
	  	WHERE OverridingServiceCode IS NULL 
	  	   OR OverridingServiceCode NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )

		UNION ALL

		SELECT TOP 1 Page, StorySummary, PublishDate
		FROM AgOnlineNewsHeadline
		WHERE Page IN (
			SELECT LPN 
			FROM AgOnlineNewsProductXref
			WHERE Product = 'LIVESTOCKCOMMENTARY'
		)
		AND Page NOT IN ( 
	  	SELECT Page 
	  	FROM AgOnlineNewsExcludeStory 
	  	WHERE OverridingServiceCode IS NULL 
	  	   OR OverridingServiceCode NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGOCHARTS
Parameter #2(cf_sql_varchar) = BASIC150
Parameter #3(cf_sql_varchar) = CANNEWS
Parameter #4(cf_sql_varchar) = CCBEMAIL
Parameter #5(cf_sql_varchar) = CCBSMS
Parameter #6(cf_sql_varchar) = CSHBD
Parameter #7(cf_sql_varchar) = CSHBDCSV
Parameter #8(cf_sql_varchar) = CSHOFFNAGO
Parameter #9(cf_sql_varchar) = CUSTTXTMSG
Parameter #10(cf_sql_varchar) = DOCLIB
Parameter #11(cf_sql_varchar) = DTNAGPKG
Parameter #12(cf_sql_varchar) = FULLQUOTES
Parameter #13(cf_sql_varchar) = FUTURESMS
Parameter #14(cf_sql_varchar) = NOFUTURES
Parameter #15(cf_sql_varchar) = USRBLTN
Parameter #16(cf_sql_varchar) = AGOCHARTS
Parameter #17(cf_sql_varchar) = BASIC150
Parameter #18(cf_sql_varchar) = CANNEWS
Parameter #19(cf_sql_varchar) = CCBEMAIL
Parameter #20(cf_sql_varchar) = CCBSMS
Parameter #21(cf_sql_varchar) = CSHBD
Parameter #22(cf_sql_varchar) = CSHBDCSV
Parameter #23(cf_sql_varchar) = CSHOFFNAGO
Parameter #24(cf_sql_varchar) = CUSTTXTMSG
Parameter #25(cf_sql_varchar) = DOCLIB
Parameter #26(cf_sql_varchar) = DTNAGPKG
Parameter #27(cf_sql_varchar) = FULLQUOTES
Parameter #28(cf_sql_varchar) = FUTURESMS
Parameter #29(cf_sql_varchar) = NOFUTURES
Parameter #30(cf_sql_varchar) = USRBLTN

Blogs (Datasource=Ag, Time=0ms, Records=14) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT b.DisplayName, b.BlogHandle, b.AuthorPhoto, b.AuthorName, b.AuthorTitle, b.AuthorId, b.BlogLandingPage
		FROM DtnBlog b
		WHERE b.Active = 1
		  AND DTNBlogID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
		ORDER BY CHARINDEX(','+ RTRIM(DTNBlogID) +',', ?)
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 12
Parameter #3(cf_sql_integer) = 13
Parameter #4(cf_sql_integer) = 5
Parameter #5(cf_sql_integer) = 7
Parameter #6(cf_sql_integer) = 6
Parameter #7(cf_sql_integer) = 2
Parameter #8(cf_sql_integer) = 4
Parameter #9(cf_sql_integer) = 10
Parameter #10(cf_sql_integer) = 8
Parameter #11(cf_sql_integer) = 11
Parameter #12(cf_sql_integer) = 9
Parameter #13(cf_sql_integer) = 14
Parameter #14(cf_sql_integer) = 15
Parameter #15(cf_sql_varchar) = ,1,12,13,5,7,6,2,4,10,8,11,9,14,15,

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = grainmarkets

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = agtechnical

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = agfundamental

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = policy

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = business

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = weather

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = ethanol

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = production

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = livestock

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = southamerica

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = editorsnotebook

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = agequipment

BlogEntries (Datasource=Ag, Time=1ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = canadamarkets

BlogEntries (Datasource=Ag, Time=0ms, Records=3) in D:\aghost\contexts\common\share\dtnBlogsForums.cfm @ 18:07:49.049
SELECT TOP 3 
								 e.Title
								,e.Link
								,e.BlogHandle
								,e.RSSBlogEntryID
								,e.Summary
								,e.PublishDate
								,b.DTNAuthorPageId
							FROM DTNBlogEntry e, DTNBlog b
							WHERE e.BlogHandle = b.BlogHandle and e.BlogHandle = ?
							ORDER BY e.SeqID
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = editorsnotebook2

Debug Rendering Time: 6 ms