Good morning, I have been getting an error a few times lately which I am sure has to do with my hosting company, as such (note-my question is not really about the error message):
Error Executing Database Query. Timed out trying to establish connection The error occurred in C:\websites\de8ddr\test\components\Content.cfc: line 136Called from C:\websites\de8ddr\test\customtags\DisplayNavBarDivots.cfm: line 20Called from C:\websites\de8ddr\test\layouts\Standard\LeftNavBar.cfm: line 267Called from C:\websites\de8ddr\test\layouts\Standard\Header.cfm: line 41Called from C:\websites\de8ddr\test\MyAdmin\home.cfm: line 10Called from C:\websites\de8ddr\test\components\Content.cfc: line 136Called from C:\websites\de8ddr\test\customtags\DisplayNavBarDivots.cfm: line 20Called from C:\websites\de8ddr\test\layouts\Standard\LeftNavBar.cfm: line 267Called from C:\websites\de8ddr\test\layouts\Standard\Header.cfm: line 41Called from C:\websites\de8ddr\test\MyAdmin\home.cfm: line 10 134 : Status = <cfqueryparam value="10" cfsqltype="CF_SQL_INTEGER"> AND135 : (Display <= <cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP"> OR Display IS NULL) AND136 : (Expire >= <cfqueryparam value="#Now()#" cfsqltype="CF_SQL_TIMESTAMP"> OR Expire IS NULL)137 : ORDER BY138 : SortOrder DESC, SQL SELECT ContentItemID, ContentItemName, ContentBody, UserID FROM PlumContentItem WHERE Category = (param 1) AND Status = (param 2) AND (Display <= (param 3) OR Display IS NULL) AND (Expire >= (param 4) OR Expire IS NULL) ORDER BY SortOrder DESC, Display DESC DATASOURCE mdfinish Question: I don't really use the Plum content management system in this app. Is there a way to avoid having this query built and run for each page request? It seems wasteful for any application not using the built in content management system. Thanks, Mark Fuqua ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
