• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Table doesn't exist

Explorer ,
Feb 02, 2013 Feb 02, 2013

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>

Views

2.1K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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

Attribute validation error for tag cfoutput.

The value of the attribute query, which is currently rsNotifyList, is invalid.

I changed the cfoutput in the cfmail to: to <cfoutput query=rsNotifyList>#email#</cfoutput>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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

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 "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>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Feb 02, 2013 Feb 02, 2013

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=new Image; d.MM_p[j++].src=a;}}

}

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)&&d.all) x=d.all; for (i=0;!x&&i<d.forms.length;i++) x=d.forms;

  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

                    &copy;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>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

Copy link to clipboard

Copied

In your HTML table, comment out this line with a CF comment (<!--- 😞

<cfoutput query="rsNotifyList">#rsNotifyList.email#, </cfoutput>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 02, 2013 Feb 02, 2013

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 02, 2013 Feb 02, 2013

Copy link to clipboard

Copied

LATEST

I guess I should probably not assume that people comment out redirects when testing.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation