Unable to execute INSERT in RDS Query Viewer

Forum|Forum|15 years ago
December 5, 2010
2 replies
1176 views

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.

Database access

This topic has been closed for replies.

Owainnorth

Inspiring

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

A

Adam Cameron.

Inspiring

Don't feed 'em.

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

--

Adam

R

robert_d_redford

Participating Frequently

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?

D

Dan_Bracuk

Inspiring

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded