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

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.

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.

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.

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.

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.