2

Just started using ColdFusion Builder 2 with ColdFusion 9 and saw the RDS viewer ability in it. I thumbed through Forta's WACK book and tried a simple example from it, a basic INSERT using a Derby Embedded database:

INSERT INTO Directors(FirstName,LastName)
VALUES('Ben','Forta')

If you execute that query using the RDS Query Viewer you get an error:

Statement.executeQuery() cannot be used with a query that returns a row count.

Are INSERTs, DELETEs, and UPDATEs not allowed using this tool? I'm probably just spoiled using SQL Server's Management Studio which will let you do anything if you have the rights.

Thanks!

James A Mohler
  • 11,060
  • 15
  • 46
  • 72
red4d
  • 277
  • 2
  • 4
  • 10

1 Answers1

1

Ya, AFAIK INSERTs, DELETEs, and UPDATEs not allowed

Henry
  • 32,689
  • 19
  • 120
  • 221
  • Not allowed at all, with *any* databases ...? – Leigh Jun 12 '11 at 07:03
  • Aha...got it. I guess a more informative error message would've helped. I couldn't find anything in the documentation that said one way or the other, but I could've missed it. Thanks! – red4d Jun 12 '11 at 14:57