|
Mark,
You'll definitely want to resolve this issue before you
deactivate any calls to the CMS, which Plum uses internally anyway.
Once you have the error resolved, you can safely remove the
call to cf_DisplayContent in the Header.cfm that displays the announcement, if
one is published.
Respectfully,
Adam Phillip Churvis
Certified Advanced ColdFusion MX 7
Developer
BlueDragon Alliance Founding Committee
Get advanced intensive Master-level training in
C# & ASP.NET 2.0
for ColdFusion Developers at
ProductivityEnhancement.com
----- Original Message -----
Sent: Wednesday, March 29, 2006 11:02
AM
Subject: [plum] plum's content
management
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
**********************************************************************
|
