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[i])&&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[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
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[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].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[i]))!=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','image s/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>