Geez, you're right. I had totally forgotten I had unchecked those privileges in CF since I had originally conceived of the app being view-only. DUH. Thanks so much,
Susan. ----- Original Message ----- From: "Neil Robertson-Ravo" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, January 02, 2003 11:12 AM Subject: Re: Permissions Problem? > check that you have granted Select/Insert/Update privileges to the table in > question in SQL Server AND in ColdFusion > ----- Original Message ----- > From: "Susan H. Allen" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Thursday, January 02, 2003 3:42 PM > 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.
