Unable to execute INSERT in RDS Query Viewer

[Guest]

Attempting to execute an INSERT statement within RDS Query Viewer within ColdFusion Builder but receive the message:

"Statement.executeQuery() cannot be called with a statementthat returns a row count."

Is this a configuration issue. Following Ben Forta's book seems to indicate a config issue but the book does not seem to match CF Builder or I messed up the config.

[Dan_Bracuk]

Not quite sure what you are talking about but the error message suggests that queryaddrow and querysetcell may work for you.

[Owainnorth]

Posting here just so this guy replies again for my own amusement.

[Adam Cameron.]

Don't feed 'em.

(I've reported the first one as spam, because that's all I think it is...)

--

Adam

[robert_d_redford]

It's not spam, although the OP doesn't give enough information. How do I know? Because I found this thread looking for answer to the same problem:

Using Coldfusion Builder 2 with Forta's WACK volume 1, page 72, he has this INSERT statement:

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

That generates the error the OP mentions if you try to execute from Builder's RDS Query Viewer. The database uses Derby Embedded. Anyone know what the problem with the above is?