<cfquery name="deleteNote" datasource="notes">

DELETE FROM tblNotes

</cfquery>

<cfoutput query="deleteNote">Deleted

note...</cfoutput>

1. DELETE queries do not typically return results. So what information are you trying to display in the cfoutput?

2. Both cfquery's have the same name. So if you are attempting to use both in the same page, the second query (ie DELETE) will overwrite the results of first. Resulting in an error when you try and output the results, because there are none for DELETE statements.

If you wish to preserve the results of first SELECT query, give the cfquery's different names:

... #Columns# ....

</cfoutput

You can only output select queries.