Copy link to clipboard
Copied
I'm working on this page and I can't figure out why I keep getting the error:
Error Executing Database Query. | |
General error: Table 'mymindsnotrighttest.notifylist' doesn't exist |
The thing is, the page loads on my testing server but not when I put it online. (On the testing server, the cfmail isn't functional but I know it's not supposed to be). I'm aware I have the 'notifylist' cfquery twice, but it doesn't work when it's just one or the other.
this is some of the code I've been working with. Any help would be very much appreciated. Thanks. - Mike
==========================================================================================
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="mymindsnotrighttest" password="Mex0Wix0" username="mikewycklendt">
INSERT INTO boardtopics (post_id, board_id, user_id, username, title, content, date)
VALUES (<cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "">
<cfqueryparam value="#FORM.post_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">
<cfqueryparam value="#FORM.board_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">
<cfqueryparam value="#FORM.user_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">
<cfqueryparam value="#FORM.username#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">
<cfqueryparam value="#FORM.title#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">
<cfqueryparam value="#FORM.content#" cfsqltype="cf_sql_clob" maxlength="2147483647">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">
<cfqueryparam value="#FORM.date#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
)
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM notifylist
</cfquery>
<cfmail
TO="<cfoutput query=rsNotifyList>#rsNotifyList.email#, </cfoutput>"
from="MyMindsNotRight@mymindsnotright.com"
subject="New Post Just For Me"
server="scriptmail.intermedia.net"
>
#FORM.username# has made a new post:
==================================================
#FORM.title#
--------------------------------------------------
#FORM.content#
-------------------------------------------------
You can see the full discussion by clicking this link:
http://www.mymindsnotright.com/discussionGenReplies.cfm?post_id=#FORM.post_id#
</cfmail>
</cfquery>
<cflocation url="discussionGenReplies.cfm?post_id=#post_id#">
</cfif>
<cfquery name="Recordset1" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
WHERE board_id = 1
ORDER BY post_id DESC
</cfquery>
<cfquery name="rsRepliesNumber" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM board_replies
WHERE board_id = 1
</cfquery>
<cfquery name="rsTopicRecordCount" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
</cfquery>
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM notifylist
</cfquery>
Copy link to clipboard
Copied
In your actual code, do you really have a <cfquery> inside another <cfquery>, or was that a pasting accident?
Also, as a side note, those four last queries could probably be combined into one, using JOINs.
Copy link to clipboard
Copied
That was my actual code... which part of the code are you referring to? Thanks for the quick reply - Mike
Copy link to clipboard
Copied
Your "INSERT INTO boardtopics" query tag (which has no name="" attribute) is still open when you start your "<cfquery name="rsNotifyList" query, and doesn't close until after the </cfmail> close. AFAIK, nesting cfquery tags is not allowed.
Copy link to clipboard
Copied
Thanks for the reply. Ok, I changed the code to what i've pasted below. Now, the first half of the page loads, but halfway down I get this new error message:
Attribute validation error for tag cfoutput. | |
The value of the attribute query, which is currently rsNotifyList, is invalid. |
====================================================
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM notifylist
</cfquery>
<cfquery datasource="mymindsnotrighttest" password="Mex0Wix0" username="mikewycklendt">
INSERT INTO boardtopics (post_id, board_id, user_id, username, title, content, date)
VALUES (<cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "">
<cfqueryparam value="#FORM.post_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">
<cfqueryparam value="#FORM.board_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">
<cfqueryparam value="#FORM.user_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">
<cfqueryparam value="#FORM.username#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">
<cfqueryparam value="#FORM.title#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">
<cfqueryparam value="#FORM.content#" cfsqltype="cf_sql_clob" maxlength="2147483647">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">
<cfqueryparam value="#FORM.date#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
)
<cfmail
TO="<cfoutput query=rsNotifyList>#rsNotifyList.email#, </cfoutput>"
from="MyMindsNotRight@mymindsnotright.com"
subject="New Post Just For Me"
server="scriptmail.intermedia.net"
>
#FORM.username# has made a new post:
==================================================
#FORM.title#
--------------------------------------------------
#FORM.content#
-------------------------------------------------
You can see the full discussion by clicking this link:
http://www.mymindsnotright.com/discussionGenReplies.cfm?post_id=#FORM.post_id#
</cfmail>
</cfquery>
<cflocation url="discussionGenReplies.cfm?post_id=#post_id#">
</cfif>
<cfquery name="Recordset1" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
WHERE board_id = 1
ORDER BY post_id DESC
</cfquery>
<cfquery name="rsRepliesNumber" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM board_replies
WHERE board_id = 1
</cfquery>
<cfquery name="rsTopicRecordCount" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
</cfquery>
Copy link to clipboard
Copied
Can you do a <cfdump var="#rsNotifyList#"> and see what it gives you? Stick it after the close of the "INSERT INTO boardtopics" query (which you should really give a name to) and the beginning of your <cfmail> tag.
Also, the second code example shows the <cfmail inside the close </cfquery> so make sure to close the query tag before the mail tag starts.
Copy link to clipboard
Copied
did both of those things and get the same error message (invalid rsNotifyList). I moved the /cfquery that was below the cfmail to above the cfmail I put the cfdump right after the /cfquery that i moved above the cfmail.
Copy link to clipboard
Copied
Just to be clear, is the error message still about the <cfoutput> tag, or the <cfdump> tag?
Also, you don't need to prefix your <cfoutput> variable with a query name when you're using query="" inside the cfoutput, unless you're pulling a variable from a query other than the one specified in the query="" attrib. You can just use <cfoutput query=rsNotifyList>#email#, </cfoutput>, although I'd probably build my list of recipients outside of the <cfmail> tag, because I think you're going to get an extra comma on the end the way you're doing it, and I don't know if that'll throw an error or not.
Also, I think you can do <cfmail query="" and use #email# in the TO="" attrib.
Copy link to clipboard
Copied
Still not working. Looks like the error message is about the cfoutput tag because the error message is:
Error Occurred While Processing Request | |||
|
I changed the cfoutput in the cfmail to: to <cfoutput query=rsNotifyList>#email#</cfoutput>
Copy link to clipboard
Copied
Yeah. Change your cfmail tag to this:
<cfmail
query="rsNotifyList"
to="#rsNotifyList.email#"
from="MyMindsNotRight@mymindsnotright.com"
subject="New Post Just For Me"
server="scriptmail.intermedia.net"
>
...
Give your second query (the INSERT one) a name="" because that's listed as required.
Let's see if you get the same error.
Copy link to clipboard
Copied
i just gave the second query the name "named" for now... should I change it to something else or does it just need a name? This is the code I'm working with now, but I get the exact same error message halfway down the page.
Error Occurred While Processing Request | |||
|
=======================================
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM notifylist
</cfquery>
<cfquery datasource="mymindsnotrighttest" password="Mex0Wix0" username="mikewycklendt">
INSERT INTO boardtopics (post_id, board_id, user_id, username, title, content, date)
VALUES (<cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "named">
<cfqueryparam value="#FORM.post_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">
<cfqueryparam value="#FORM.board_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">
<cfqueryparam value="#FORM.user_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">
<cfqueryparam value="#FORM.username#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">
<cfqueryparam value="#FORM.title#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">
<cfqueryparam value="#FORM.content#" cfsqltype="cf_sql_clob" maxlength="2147483647">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">
<cfqueryparam value="#FORM.date#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
)
</cfquery>
<cfdump var="#rsNotifyList#">
<cfmail
query="rsNotifyList"
to="#rsNotifyList.email#"
from="MyMindsNotRight@mymindsnotright.com"
subject="New Post Just For Me"
server="scriptmail.intermedia.net"
>
#FORM.username# has made a new post:
==================================================
#FORM.title#
--------------------------------------------------
#FORM.content#
-------------------------------------------------
You can see the full discussion by clicking this link:
http://www.mymindsnotright.com/discussionGenReplies.cfm?post_id=#FORM.post_id#
</cfmail>
<cflocation url="discussionGenReplies.cfm?post_id=#post_id#">
</cfif>
<cfquery name="Recordset1" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
WHERE board_id = 1
ORDER BY post_id DESC
</cfquery>
<cfquery name="rsRepliesNumber" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM board_replies
WHERE board_id = 1
</cfquery>
<cfquery name="rsTopicRecordCount" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
</cfquery>
Copy link to clipboard
Copied
Odd, since there's no longer a <cfoutput> on that page.
Move the cfdump up to just below the "rsNotifyList" query and see if you get results from it.
Copy link to clipboard
Copied
moved it there and the cfdump doesn't show anywhere on the page at all.
One thing I haven't mentioned is that there's a cfinclude further down the page for the form that, when submitted, is supposed to notify me with the cfmail.
the code for that form is:
=================================================
<form method="post" name="form1" action="<cfoutput>#CurrentPage#</cfoutput>">
<table align="center" cellpadding="4">
<tr valign="baseline">
<td colspan="2" align="left" nowrap bgcolor="#E0E0E0" class="blogtitle">Post New Topic<a name="postGenDis"></a></td>
</tr>
<tr valign="baseline">
<td align="right" nowrap class="bloguserandwho"> </td>
<td><input type="hidden" name="user_id" value="<cfoutput>#rsGetUserID.user_id#</cfoutput>" size="32"></td>
</tr>
<tr valign="baseline">
<td align="right" nowrap class="bloguserandwho">Username:</td>
<td><input type="hidden" name="username" value="<cfoutput>#Session.MM_Username#</cfoutput>" size="32">
<cfoutput>#Session.MM_Username#</cfoutput></td>
</tr>
<tr valign="baseline">
<td align="right" nowrap class="bloguserandwho">Title:</td>
<td><input type="text" name="title" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap class="bloguserandwho">Content:</td>
<td><textarea name="content" cols="30" rows="5"></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Post New Topic"></td>
</tr>
</table>
<input type="hidden" name="post_id" value="<cfoutput>#IncrementValue(rsTopicRecordCount.RecordCount)#</cfoutput>">
<input type="hidden" name="board_id" value="1">
<input type="hidden" name="date" value="<cfoutput>#now()#</cfoutput>">
<input type="hidden" name="MM_InsertRecord" value="form1">
</form>
Copy link to clipboard
Copied
Do you get a line number for the <cfoutput> error? I don't think the error is coming from that form.
Copy link to clipboard
Copied
No line error. The form include I pasted above is still the same, but this is the code for the entire page I'm having problems with. Thanks a ton for helping me with this today.
=-==============================================================
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM notifylist
</cfquery>
<cfdump var="#rsNotifyList#">
<cfquery datasource="mymindsnotrighttest" password="Mex0Wix0" username="mikewycklendt">
INSERT INTO boardtopics (post_id, board_id, user_id, username, title, content, date)
VALUES (<cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "named">
<cfqueryparam value="#FORM.post_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">
<cfqueryparam value="#FORM.board_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">
<cfqueryparam value="#FORM.user_id#" cfsqltype="cf_sql_numeric">
<cfelse>
NULL
</cfif>
, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">
<cfqueryparam value="#FORM.username#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">
<cfqueryparam value="#FORM.title#" cfsqltype="cf_sql_clob" maxlength="65535">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">
<cfqueryparam value="#FORM.content#" cfsqltype="cf_sql_clob" maxlength="2147483647">
<cfelse>
''
</cfif>
, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">
<cfqueryparam value="#FORM.date#" cfsqltype="cf_sql_timestamp">
<cfelse>
NULL
</cfif>
)
</cfquery>
<cfmail
query="rsNotifyList"
to="#rsNotifyList.email#"
from="MyMindsNotRight@mymindsnotright.com"
subject="New Post Just For Me"
server="scriptmail.intermedia.net"
>
#FORM.username# has made a new post:
==================================================
#FORM.title#
--------------------------------------------------
#FORM.content#
-------------------------------------------------
You can see the full discussion by clicking this link:
http://www.mymindsnotright.com/discussionGenReplies.cfm?post_id=#FORM.post_id#
</cfmail>
<cflocation url="discussionGenReplies.cfm?post_id=#post_id#">
</cfif>
<cfquery name="Recordset1" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
WHERE board_id = 1
ORDER BY post_id DESC
</cfquery>
<cfquery name="rsRepliesNumber" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM board_replies
WHERE board_id = 1
</cfquery>
<cfquery name="rsTopicRecordCount" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
SELECT *
FROM boardtopics
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>My Minds Not Right -- General Discussion Board</title>
<link rel="stylesheet" type="text/css" href="HTML/style.css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
.blogcontent {
font-size: 11pt;
font-family: Tahoma, Geneva, sans-serif;
}
.comments {
font-family: Tahoma, Geneva, sans-serif;
font-size: 12px;
font-weight: bold;
text-decoration: underline;
text-align: right;
color: #246494;
}
.FeaturedBlogList {
font-family: Tahoma, Geneva, sans-serif;
font-size: 11px;
}
.FeaturedBlogListHeader {
font-family: Tahoma, Geneva, sans-serif;
font-size: 12px;
font-weight: bold;
color: #246494;
/* [disabled]border-bottom-style: solid; */
}
.blogdate {
font-size: 9pt;
font-style: italic;
font-family: Tahoma, Geneva, sans-serif;
}
.bloguserandwho {
font-size: 10pt;
font-style: normal;
font-family: Tahoma, Geneva, sans-serif;
}
.redlink {
font-family: Tahoma, Geneva, sans-serif;
color: #F00;
font-size: 10pt;
}
.blogtitle {
font-size: 16px;
font-weight: bold;
font-family: Tahoma, Geneva, sans-serif;
color: #246494;
}
.quoteStyle {
font-family: Verdana, Geneva, sans-serif;
font-size: 11pt;
font-style: italic;
color: #000;
}
.justified {
text-align: justify;
}
</style>
<script type="text/javascript">
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>
</head>
<body bgcolor="#ffffff" leftmargin=0 topmargin=0 marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/about_invert.jpg','images/discussion_invert.jpg','images/family_invert.jpg','images/askquestion_invert.jpg','images/newsletters_invert.jpg','images/home_invert.jpg')">
<table border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
<tr>
<td width="50%" background="images/bg.gif" valign="top"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td valign="top" background="images/bg_left.gif"><img src="images/bg_left.gif" alt="" width="17" height="16" border="0">
</td>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="780"></td>
<td width="100%">
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/logo01new.jpg" width="510" height="126"><img src="images/logo02clean.jpg" width="270" height="126" border="0"></td>
</tr>
<tr>
<cfinclude template="topBar.cfm">
</tr>
</table>
</td>
</tr>
</table>
<cfinclude template="sideBar.cfm">
<p class="left"><cfinclude template="includes/sidebarLinks.cfm">
<br>
</p>
<!-- /left -->
</td>
<td rowspan="2" width="100%">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td background="images/fon_right.gif"><img src="images/BARS/GENERALDISCUSSIONTOP.jpg" width="323" height="35" alt="" border="0"></td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td background="images/fon_right.gif"> </td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td valign="top" rowspan="2" width="100%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2"><img src="images/2_f_2.gif" width="2" height="35"></td>
<td background="images/2_f_2_fon.gif" width="100%"><img src="images/topend.jpg" width="28" height="36"></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td background="images/fon01.gif" style="background-position: top; background-repeat: repeat-x; font-size: 9px; font-family: Tahoma, Geneva, sans-serif; color: #000;"><table border="0" cellspacing="0" cellpadding="0" width="90%" background="" align="center">
<tr valign="top">
<td align="left"><br>
<table width="96%" border="0">
<tr>
<td width="76%"><span class="bloguserandwho">Post anything here that doesn't really fit anywhere else.</span></td>
<td width="24%" align="right"><a href="#postGenDis" class="redlink"><strong>Post New Topic</strong></a></td>
</tr>
</table>
<p class="bloguserandwho"> </p>
<hr align="left" width="95%" class="blogtitle">
<table border="0">
<tr class="FeaturedBlogListHeader">
<td width="310">Post Title:</td>
<td width="90">Posted By:</td>
<td width="75">Posted On:</td>
</tr>
<cfoutput query="Recordset1">
<tr class="bloguserandwho">
<td width="310"><a href="discussionGenReplies.cfm?post_id=#Recordset1.post_id#">#Recordset1.title#</a></td>
<td width="90">#Recordset1.username#</td>
<td width="75">#LSDateFormat(Recordset1.date,'M/DD/YY')#</td>
</tr>
</cfoutput>
</table>
<table width="96%" border="0">
<tr>
<td height="39" align="right"><hr></td>
</tr>
<tr>
<td align="right"><a href="#postGenDis" class="redlink"><strong>Post New Topic</strong></a></td>
</tr>
</table>
<p> </p>
<cfoutput query="rsNotifyList">#rsNotifyList.email#, </cfoutput>
<p class="blogtitle"></p></td>
</tr>
</table>
</td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td background="images/fon01.gif" style="background-position: top; background-repeat: repeat-x;">
<br></td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
</tr>
<tr>
<td background="images/fon02.gif" colspan="3"><img src="images/BARS/DISCUSSIONBOARDSMID.jpg" width="563" height="43" alt="" border="0"></td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td background="images/fon_right.gif" width="100%"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"><cfinclude template="discussion_include.cfm">
<p> </p>
<p> </p></td>
<td bgcolor="#B9B9B9"> </td>
<td> </td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"><blockquote>
<p> </p>
<p> </p>
<cfinclude template="discussionGeneralTopicForminclude.cfm">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</blockquote>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
<td bgcolor="#B9B9B9"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
<td>
<div align="left"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></div>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#246494">
<td valign="bottom">
<table border="0" cellspacing="0" cellpadding="0" width="188" height="67" background="images/left_bot.gif">
<tr>
<td valign="bottom">
<p class="left" style="margin-bottom: 0px; margin-left: 20px;">Copyright
©2010<br>
MyMindsNotRight.com<br>
All rights reserved</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" width="100%" height="77" background="images/fon_bot.gif">
<tr>
<td valign="top" width="780">
<cfinclude template="bottomBar.cfm">
</td>
<td><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
</tr>
<tr>
<td><img src="images/px1.gif" width="780" height="1" alt="" border="0"></td>
<td><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>
</td>
<td valign="bottom" background="images/bg_right.gif"><img src="images/bg_right.gif" alt="" width="17" height="16" border="0"></td>
<td width="50%" background="images/bg.gif" valign="top"><img src="images/px1.gif" width="1" height="1" alt="" border="0"></td>
</tr>
</table>
</body>
</html>
Copy link to clipboard
Copied
In your HTML table, comment out this line with a CF comment (<!--- 😞
<cfoutput query="rsNotifyList">#rsNotifyList.email#, </cfoutput>
Copy link to clipboard
Copied
The page could do with some restructuring and simplifying. Its structure is essentially as follows:
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery name="rsNotifyList" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
</cfquery>
<cfdump var="#rsNotifyList#">
<cfquery datasource="mymindsnotrighttest" password="Mex0Wix0" username="mikewycklendt">
</cfquery>
<cfmail>
</cfmail>
<cflocation url="discussionGenReplies.cfm?post_id=#post_id#">
</cfif>
<cfquery name="Recordset1" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
</cfquery>
<cfquery name="rsRepliesNumber" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
</cfquery>
<cfquery name="rsTopicRecordCount" datasource="mymindsnotrighttest" username="mikewycklendt" password="Mex0Wix0">
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
</html>
This immediately reveals at least one issue. The cfdump is redundant. If the if-condition is satisfied, the page will redirect to discussionGenReplies.cfm, and no dump will be displayed.
Copy link to clipboard
Copied
I guess I should probably not assume that people comment out redirects when testing.