You need to open the ColdFusion Administrator and allow delete in the properties of the data source. :)
-----Original Message----- From: Susan H. Allen [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:43 AM To: SQL Subject: Permissions Problem? Good morning, I have just created a new table in an existing SQL2000 database and wrote CF code to delete and insert into that table. I am getting this error: "Error Executing Database Query. Executing the SQL statement is not allowed." The permissions on this table are the same as all other tables in the database; I've never gotten such an error before on any other delete/insert statements in any other database. What is up with that? TIA, Susan Allen Pfingsten Publishing, L.L.C. [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
