17 Replies Latest reply: Feb 2, 2013 12:35 PM by BreakawayPaul

Table doesn't exist

wycks Feb 2, 2013 8:29 AM

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

==========================================================================================

INSERT INTO boardtopics (post_id, board_id, user_id, username, title, content, date)

VALUES (<cfif IsDefined("FORM.post_id") AND #FORM.post_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.board_id") AND #FORM.board_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.user_id") AND #FORM.user_id# NEQ "">

NULL

</cfif>

, <cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">

</cfif>

, <cfif IsDefined("FORM.title") AND #FORM.title# NEQ "">

</cfif>

, <cfif IsDefined("FORM.content") AND #FORM.content# NEQ "">

</cfif>

, <cfif IsDefined("FORM.date") AND #FORM.date# NEQ "">

NULL

</cfif>

)

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>

</cfif>

SELECT *

FROM boardtopics

WHERE board_id = 1

ORDER BY post_id DESC

</cfquery>

SELECT *

FROM board_replies

WHERE board_id = 1

</cfquery>

SELECT *

FROM boardtopics

</cfquery>

SELECT *

FROM notifylist

</cfquery>

1. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 9:19 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
2. Re: Table doesn't exist

wycks Feb 2, 2013 9:23 AM (in response to BreakawayPaul)

That was my actual code... which part of the code are you referring to? Thanks for the quick reply - Mike
Like Show 0 Likes (0)

Actions
3. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 10:37 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
4. Re: Table doesn't exist

wycks Feb 2, 2013 10:44 AM (in response to BreakawayPaul)

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>
Like Show 0 Likes (0)

Actions
5. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 10:56 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
6. Re: Table doesn't exist

wycks Feb 2, 2013 11:02 AM (in response to BreakawayPaul)

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.
Like Show 0 Likes (0)

Actions
7. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 11:13 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
8. Re: Table doesn't exist

wycks Feb 2, 2013 11:15 AM (in response to BreakawayPaul)

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>
Like Show 0 Likes (0)

Actions
9. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 11:18 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
10. Re: Table doesn't exist

wycks Feb 2, 2013 11:24 AM (in response to BreakawayPaul)

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>
Like Show 0 Likes (0)

Actions
11. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 11:31 AM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
12. Re: Table doesn't exist

wycks Feb 2, 2013 11:38 AM (in response to BreakawayPaul)

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>
Like Show 0 Likes (0)

Actions
13. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 11:43 AM (in response to wycks)

Do you get a line number for the <cfoutput> error? I don't think the error is coming from that form.
Like Show 0 Likes (0)

Actions
14. Re: Table doesn't exist

wycks Feb 2, 2013 11:56 AM (in response to BreakawayPaul)

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>

          </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>
Like Show 0 Likes (0)

Actions
15. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 12:20 PM (in response to wycks)

In your HTML table, comment out this line with a CF comment (<!--- ):
<cfoutput query="rsNotifyList">#rsNotifyList.email#, </cfoutput>
Like Show 0 Likes (0)

Actions
16. Re: Table doesn't exist

BKBK Feb 2, 2013 12:33 PM (in response to wycks)

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.
Like Show 0 Likes (0)

Actions
17. Re: Table doesn't exist

BreakawayPaul Feb 2, 2013 12:35 PM (in response to BKBK)

I guess I should probably not assume that people comment out redirects when testing.
Like Show 0 Likes (0)

Actions