[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904

Question

I keep getting the following error message
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00904: "REVISIONDATE":
invalid identifier from a call to a method in a CFC.

The method basically runs the following query in a CFQUERY
tag

SELECT REVISIONDATE,TITLE FROM TBL_DOCUMENTS WHERE
UUID=<cfqueryparam type="cf_sql_varchar"
value="#arguments.uuid#">

I have recently added the new field REVISIONDATE to the
database table.

I have checked to ensure the field exists (which it does). I
have actually ran the query as a stand alone script and it works
without any errors.

Newsgroup_User · Answer

(the original post was from one of my colleagues).

False alarm on this one.

Muggins here (ie: me) had set the wrong user/pwd in a config file which
some of our legacy code uses, so the legacy code was looking @ one DB, the
new code (that ran the update) was looking at the correct DB.

So what looked like a variation of that JDBC problem with using SELECT * on
recently modified tables, was just me being stupid.

This has already wasted a couple hours of my time scratching my head, and
another couple of hours of my colleagues time scratching his whilst I
swanned off to a conference ("A Wee Dram o Scotch", which was very good,
btw). And now we're faced with two DBs that are screwed because of updates
being split across both of them, buggering up both. So that's another few
hours for me to fix that.

Well done, Adam.

:-(

--
Adam

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