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

    Table doesn't exist

    wycks Community Member

      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>

        • 1. Re: Table doesn't exist
          BreakawayPaul Community Member

          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.

          • 2. Re: Table doesn't exist
            wycks Community Member

            That was my actual code... which part of the code are you referring to?  Thanks for the quick reply - Mike

            • 3. Re: Table doesn't exist
              BreakawayPaul Community Member

              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.

              • 4. Re: Table doesn't exist
                wycks Community Member

                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>

                • 5. Re: Table doesn't exist
                  BreakawayPaul Community Member

                  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.

                  • 6. Re: Table doesn't exist
                    wycks Community Member

                    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.

                    • 7. Re: Table doesn't exist
                      BreakawayPaul Community Member

                      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.

                      • 8. Re: Table doesn't exist
                        wycks Community Member

                        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>

                        • 9. Re: Table doesn't exist
                          BreakawayPaul Community Member

                          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.

                          • 10. Re: Table doesn't exist
                            wycks Community Member

                            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>

                            • 11. Re: Table doesn't exist
                              BreakawayPaul Community Member

                              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.

                              • 12. Re: Table doesn't exist
                                wycks Community Member

                                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>

                                • 13. Re: Table doesn't exist
                                  BreakawayPaul Community Member

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

                                  • 14. Re: Table doesn't exist
                                    wycks Community Member

                                    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

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

                                    • 15. Re: Table doesn't exist
                                      BreakawayPaul Community Member

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

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

                                      • 16. Re: Table doesn't exist
                                        BKBK CommunityMVP

                                        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.

                                        • 17. Re: Table doesn't exist
                                          BreakawayPaul Community Member

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