If you execute the generated SQL directly in Oracle does it give the same error?
David ----- Original Message ----- From: "Tim Blankenship" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, April 06, 2006 3:26 PM Subject: Re: [plum] Column not found using cf_insertrecord For a test I did the following code and it gave the exact same error. <cf_InsertRecord table="CIS.UNIX_VMS" redirectTo="#Application.absoluteUrlRoot#/reqs/UNIX_VMSList.cfm?FromAction=1 "> <cf_PassColumnToAction column="SBCUID" type="varchar(100)" value="AB1234" valueIfEmpty="NULL"> <cf_PassColumnToAction column="CREATE" type="varchar(10)" value="Y" valueIfEmpty="NULL"> <cf_PassColumnToAction column="MODIFY" type="varchar(10)" value="Y" valueIfEmpty="NULL"> <cf_PassColumnToAction column="REMOVE_ACCESS" type="varchar(10)" value="Y" valueIfEmpty="NULL"> <cf_PassColumnToAction column="GRANT_SUDO_ACCESS" type="varchar(10)" value="Y" valueIfEmpty="NULL"> <cf_PassColumnToAction column="EXPLAIN_SUDO_REQUIRNMENT" type="varchar(250)" value="test" valueIfEmpty="NULL"> <cf_PassColumnToAction column="LIST_SERVERS" type="varchar(250)" value="test" valueIfEmpty="NULL"> <cf_PassColumnToAction column="VMS_REQUIRNMENT" type="varchar(250)" value="test" valueIfEmpty="NULL"> </cf_InsertRecord> On 4/6/06, David Churvis <[EMAIL PROTECTED]> wrote: > Tim, > > This is strange. Are you able to execute that SQL directly, or does it > throw the same error? > > David > ----- Original Message ----- > From: "Tim Blankenship" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, April 06, 2006 2:11 PM > Subject: Re: [plum] Column not found using cf_insertrecord > > > Alright here is the meat of the error message - > > LINE 148 was highlighted. > > 146 : ) > 147 : VALUES ( > 148 : #PreserveSingleQuotes(Arguments.values)# > 149 : ) > 150 : </cfquery> > > SQL > INSERT INTO CIS.UNIX_VMS( SBCUID, CREATE, MODIFY, REMOVE_ACCESS, > GRANT_SUDO_ACCESS, EXPLAIN_SUDO_REQUIRNMENT, LIST_SERVERS, > VMS_REQUIRNMENT ) VALUES ( 'QW1234', 'Y', 'Y', 'Y', 'Y', 'test', > 'test', 'test' ) > > > > > > > > > On 4/5/06, Tim Blankenship <[EMAIL PROTECTED]> wrote: > > I'll post this tonight or the AM - Another hard 5 hrs of work, it's > > time to go home. > > On 4/5/06, David Churvis <[EMAIL PROTECTED]> wrote: > > > Turn off error handlers in the framework and try it. Let's see what > kind of > > > SQL is being sent to Oracle - I think that will help us find the real > > > problem. > > > > > > David > > > ----- Original Message ----- > > > From: "Tim Blankenship" <[EMAIL PROTECTED]> > > > To: <[email protected]> > > > Sent: Wednesday, April 05, 2006 3:29 PM > > > Subject: Re: [plum] Column not found using cf_insertrecord > > > > > > > > > Grey error box? Plum sends me to errors/ViewExceptionMessage.cfm > > > I added CIS with no luck. > > > <cf_InsertRecord table="CIS.UNIX_VMS" > > > > redirectTo="#Application.absoluteUrlRoot#/reqs/UNIX_VMSList.cfm?FromAction=1 > > > "> > > > > > > > > > > > > > > > On 4/5/06, David Churvis <[EMAIL PROTECTED]> wrote: > > > > Plum isn't going to put the CIS. in front of the table name, so it's > > > > possible that you're logged in with a user whose default tablespace is > > > > something other than CIS. This is just my first reaction, but I think > > > that > > > > may be the problem. > > > > > > > > If you still have problems, copy the failed SQL out of the grey error > box > > > > and send that. > > > > > > > > David > > > > ----- Original Message ----- > > > > From: "Tim Blankenship" <[EMAIL PROTECTED]> > > > > To: <[email protected]> > > > > Sent: Wednesday, April 05, 2006 11:09 AM > > > > Subject: Re: [plum] Column not found using cf_insertrecord > > > > > > > > > > > > This might help into the confusion. > > > > > > > > INSERT INTO "CIS"."UNIX_VMS" ("SBCUID" ,"CREATE" ,"MODIFY" , > > > > "REMOVE_ACCESS" ,"GRANT_SUDO_ACCESS" , > > > > "EXPLAIN_SUDO_REQUIRNMENT" ,"LIST_SERVERS" ,"VMS_REQUIRNMENT" > > > > ) > > > > VALUES ('TB6859' ,'' ,'' ,'' ,'' ,'' ,'' ,'' ) > > > > > > > > Worked! What suggestions would you have to remedy this? > > > > > > > > > > > > On 4/5/06, Tim Blankenship <[EMAIL PROTECTED]> wrote: > > > > > Error: > > > > > ORA-01747: invalid user.table.column, table.column, or column > > > > specification > > > > > > > > > > SBCUID is FK to CLIENT_SBCUID in the CLIENTDATA table. > > > > > The problem is inserting into table UNIX_VMS > > > > > I think I might have a relationship error? > > > > > Here is some ddl info to help - don't laugh at the layout , it is > just > > > > > a for demoing the app. > > > > > TABLE - CLIENTDATA > > > > > CREATE TABLE "CIS"."CLIENTDATA" ("CLIENT_SBCUID" VARCHAR2(100 > > > > > byte) NOT NULL, "CLIENT_SSN" VARCHAR2(100 byte), > > > > > "CLIENT_FIRSTNAME" VARCHAR2(100 byte), "CLIENT_MIDDLENAME" > > > > > VARCHAR2(100 byte), "CLIENT_LASTNAME" VARCHAR2(100 byte), > > > > > "CLIENT_TITLE" VARCHAR2(100 byte), "CLIENT_DEPARTMENT" > > > > > VARCHAR2(100 byte), "CLIENT_PHONE" VARCHAR2(100 byte), > > > > > "CLIENT_FAX" VARCHAR2(100 byte), "CLIENT_ADDRESS" > > > > > VARCHAR2(100 byte), "CLIENT_EMAIL" VARCHAR2(100 byte), > > > > > "CLIENT_REGION" VARCHAR2(100 byte), "CLIENT_COMPANY" > > > > > VARCHAR2(100 byte), "CLIENT_NCSDATE" DATE, "CLIENT_RCCODE" > > > > > VARCHAR2(100 byte), "CLIENT_SUPERVISORNAME" VARCHAR2(100 > > > > > byte), "CLIENT_SUPERVISORSBCUID" VARCHAR2(100 byte), > > > > > "CLIENT_SUPERVISORPHONE" VARCHAR2(100 byte), > > > > > "CLIENT_CONTRACTOR" VARCHAR2(100 byte), > > > > > "CLIENT_CONTRACTORCOMPANY" VARCHAR2(100 byte), > > > > > "CLIENT_CONTRACTEXP" DATE, "CLIENT_SPONSORSBCUID" > > > > > VARCHAR2(100 byte), "CLIENT_BUSANAYLST" VARCHAR2(100 byte), > > > > > "CLIENT_CCOP" VARCHAR2(100 byte), "CLIENT_CLIENTSERVICES" > > > > > VARCHAR2(100 byte), "CLIENT_DBA" VARCHAR2(100 byte), > > > > > "CLIENT_DEVELOPER" VARCHAR2(100 byte), "CLIENT_HELPDESK" > > > > > VARCHAR2(100 byte), "CLIENT_ITOTHER" VARCHAR2(100 byte), > > > > > "CLIENT_MANAGEMENT" VARCHAR2(100 byte), "CLIENT_NEWEMPLOYEE" > > > > > VARCHAR2(100 byte), "CLIENT_NONMANAGEMENT" VARCHAR2(100 byte), > > > > > "CLIENT_OPERATIONS" VARCHAR2(100 byte), "CLIENT_OST" > > > > > VARCHAR2(100 byte), "CLIENT_PRODUCTIONCONTR0L" VARCHAR2(100 > > > > > byte), "CLIENT_REMOVEACCESS" VARCHAR2(100 byte), > > > > > "CLIENT_SYSADMIN" VARCHAR2(100 byte), > > > > > CONSTRAINT "PK_SBCUID_1" PRIMARY KEY("CLIENT_SBCUID") > > > > > USING INDEX > > > > > TABLESPACE "USERS" > > > > > STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS > > > > > 2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255) > > > > > > > > > > TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS > > > > > 255 > > > > > STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS > > > > > 2147483645 PCTINCREASE 0) > > > > > LOGGING > > > > > > > > > > TABLE - UNIX-VMS > > > > > CREATE TABLE "CIS"."UNIX_VMS" ("SBCUID" VARCHAR2(100 byte) NOT > > > > > NULL, "CREATE" VARCHAR2(10 byte), "MODIFY" VARCHAR2(10 byte), > > > > > "REMOVE_ACCESS" VARCHAR2(10 byte), "GRANT_SUDO_ACCESS" > > > > > VARCHAR2(10 byte), "EXPLAIN_SUDO_REQUIRNMENT" VARCHAR2(250 > > > > > byte), "LIST_SERVERS" VARCHAR2(250 byte), "VMS_REQUIRNMENT" > > > > > VARCHAR2(250 byte), > > > > > CONSTRAINT "FK_UNIX_VMS" FOREIGN KEY("SBCUID") > > > > > REFERENCES "CIS"."CLIENTDATA"("CLIENT_SBCUID"), > > > > > CONSTRAINT "PK_UNIX_VMS" PRIMARY KEY("SBCUID") > > > > > USING INDEX > > > > > TABLESPACE "USERS" > > > > > STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS > > > > > 2147483645 PCTINCREASE 0) PCTFREE 10 INITRANS 2 MAXTRANS 255) > > > > > > > > > > TABLESPACE "USERS" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS > > > > > 255 > > > > > STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS > > > > > 2147483645 PCTINCREASE 0) > > > > > LOGGING > > > > > > > > > > PLUM GENERATED PAGE - UNIX_VMSAddAction.cfm > > > > > <cfparam name="Form.CREATE" default="N"> > > > > > <cfparam name="Form.MODIFY" default="N"> > > > > > <cfparam name="Form.REMOVE_ACCESS" default="N"> > > > > > <cfparam name="Form.GRANT_SUDO_ACCESS" default="N"> > > > > > > > > > > <cf_ValidateForm > > > > > > errorLocation="#Application.absoluteUrlRoot#/req/UNIX_VMSAddForm.cfm"> > > > > > <cf_ValidateInput variableName="Form.CREATE" label="CREATE" > > > > > validationType="varchar(10)" required="No"> > > > > > <cf_ValidateInput variableName="Form.MODIFY" label="MODIFY" > > > > > validationType="varchar(10)" required="No"> > > > > > <cf_ValidateInput variableName="Form.REMOVE_ACCESS" > > > label="REMOVE > > > > > ACCESS" validationType="varchar(10)" required="No"> > > > > > <cf_ValidateInput variableName="Form.GRANT_SUDO_ACCESS" > > > > label="GRANT > > > > > SUDO ACCESS" validationType="varchar(10)" required="No"> > > > > > <cf_ValidateInput > variableName="Form.EXPLAIN_SUDO_REQUIRNMENT" > > > > > label="EXPLAIN SUDO REQUIRNMENT" validationType="varchar(250)" > > > > > required="No"> > > > > > <cf_ValidateInput variableName="Form.LIST_SERVERS" > label="LIST > > > > > SERVERS" validationType="varchar(250)" required="No"> > > > > > <cf_ValidateInput variableName="Form.VMS_REQUIRNMENT" > label="VMS > > > > > REQUIRNMENT" validationType="varchar(250)" required="No"> > > > > > </cf_ValidateForm> > > > > > > > > > > <cf_InsertRecord table="UNIX_VMS" > > > > > > > > > > > > > redirectTo="#Application.absoluteUrlRoot#/req/UNIX_VMSList.cfm?FromAction=1" > > > > > > > > > > <cf_PassColumnToAction column="SBCUID" type="varchar(100)" > > > > > value="#Form.SBCUID#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="CREATE" type="varchar(10)" > > > > > value="#Form.CREATE#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="MODIFY" type="varchar(10)" > > > > > value="#Form.MODIFY#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="REMOVE_ACCESS" > type="varchar(10)" > > > > > value="#Form.REMOVE_ACCESS#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="GRANT_SUDO_ACCESS" > > > > type="varchar(10)" > > > > > value="#Form.GRANT_SUDO_ACCESS#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="EXPLAIN_SUDO_REQUIRNMENT" > > > > > type="varchar(250)" value="#Form.EXPLAIN_SUDO_REQUIRNMENT#" > > > > > valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="LIST_SERVERS" > type="varchar(250)" > > > > > value="#Form.LIST_SERVERS#" valueIfEmpty="NULL"> > > > > > <cf_PassColumnToAction column="VMS_REQUIRNMENT" > > > > type="varchar(250)" > > > > > value="#Form.VMS_REQUIRNMENT#" valueIfEmpty="NULL"> > > > > > </cf_InsertRecord> > > > > > > > > > > PERSONAL TESTS > > > > > <CFQUERY NAME="TESTCOLUMN" datasource="#APPLICATION.DBDSN#"> > > > > > SELECT * > > > > > FROM UNIX_VMS > > > > > </CFQUERY> > > > > > <CFDUMP VAR="#TESTCOLUMN#"> > > > > > ----Result showed the SBCUID column > > > > > > > > > > <CFQUERY NAME="INSERTCOLUMN" datasource="#APPLICATION.DBDSN#"> > > > > > INSERT INTO UNIX_VMS (SBCUID, CREATE, MODIFY, REMOVE_ACCESS, > > > > > GRANT_SUDO_ACCESS, EXPLAIN_SUDO_REQUIRNMENT, LIST_SERVERS, > > > > > VMS_REQUIRNMENT) > > > > > VALUES ('#Form.SBCUID#', '#Form.CREATE#', '#Form.MODIFY#', > > > > > '#Form.REMOVE_ACCESS#', '#Form.GRANT_SUDO_ACCESS#', > > > > > '#Form.EXPLAIN_SUDO_REQUIRNMENT#', '#Form.LIST_SERVERS#, > > > > > '#Form.VMS_REQUIRNMENT#' ) > > > > > </CFQUERY> > > > > > > > > > > ----Result - > > > > > Error: > > > > > ORA-01747: invalid user.table.column, table.column, or column > > > > specification > > > > > > > > > > So either way, PLUM, no PLUM I get the error. I assume it's a DB > issue > > > > > but not sure what's gong on. Oh and 1 hour till I demo the > app---isn't > > > > > that nice. > > > > > > > > > > > > > > > On 4/5/06, David Churvis <[EMAIL PROTECTED]> wrote: > > > > > > Tim, > > > > > > > > > > > > What is the error message you're getting? > > > > > > > > > > > > David > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "Tim Blankenship" <[EMAIL PROTECTED]> > > > > > > To: "Plum Email List" <[email protected]> > > > > > > Sent: Tuesday, April 04, 2006 12:25 PM > > > > > > Subject: [plum] Column not found using cf_insertrecord > > > > > > > > > > > > > > > > > > Column SBCUID is the only required field. This field is populated > by a > > > > > > session variable. I was able to dump the session and the variable > > > > > > displays correctely on the processing form. > > > > > > > > > > > > Alright here is the code: Action page of form. Generated by PLUM > and I > > > > > > manually added th eSBCUID field. > > > > > > > > > > > > <cf_InsertRecord table="UNIX_VMS" > > > > > > redirectTo="#Application.absoluteUrlRoot#/request/index.cfm"> > > > > > > <cf_PassColumnToAction column="SBCUID" type="varchar(10)" > > > > > > value="#SESSION.REQUESTS.CLIENTID#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="CREATE" type="varchar(10)" > > > > > > value="#Form.CREATE#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="MODIFY" type="varchar(10)" > > > > > > value="#Form.MODIFY#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="REMOVE_ACCESS" type="varchar(10)" > > > > > > value="#Form.REMOVE_ACCESS#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="GRANT_SUDO_ACCESS" > type="varchar(10)" > > > > > > value="#Form.GRANT_SUDO_ACCESS#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="EXPLAIN_SUDO_REQUIRNMENT" > type="text" > > > > > > value="#Form.EXPLAIN_SUDO_REQUIRNMENT#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="LIST_SERVERS" type="text" > > > > > > value="#Form.LIST_SERVERS#" valueIfEmpty="NULL"> > > > > > > <cf_PassColumnToAction column="VMS_REQUIRNMENT" > type="varchar(250)" > > > > > > value="#Form.VMS_REQUIRNMENT#" valueIfEmpty="NULL"> > > > > > > </cf_InsertRecord> > > > > > > > > > > > > > > > > > > -- > > > > > > Tim Blankenship > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > ********************************************************************** > > > > > > You can subscribe to and unsubscribe from lists, and you can > change > > > > > > your subscriptions between normal and digest modes here: > > > > > > > > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > > > > > ********************************************************************** > > > > > > > > > > > > > > > > > > > ********************************************************************** > > > > > > You can subscribe to and unsubscribe from lists, and you can > change > > > > > > your subscriptions between normal and digest modes here: > > > > > > > > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > > > > > ********************************************************************** > > > > > > > > > > > > > > > > > > > > > -- > > > > > Tim Blankenship > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -- > > > > Tim Blankenship > > > > [EMAIL PROTECTED] > > > > > > > > ********************************************************************** > > > > You can subscribe to and unsubscribe from lists, and you can change > > > > your subscriptions between normal and digest modes here: > > > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > > ********************************************************************** > > > > > > > > > > > > ********************************************************************** > > > > You can subscribe to and unsubscribe from lists, and you can change > > > > your subscriptions between normal and digest modes here: > > > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > > ********************************************************************** > > > > > > > > > > > > > -- > > > Tim Blankenship > > > [EMAIL PROTECTED] > > > > > > ********************************************************************** > > > You can subscribe to and unsubscribe from lists, and you can change > > > your subscriptions between normal and digest modes here: > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > ********************************************************************** > > > > > > > > > ********************************************************************** > > > You can subscribe to and unsubscribe from lists, and you can change > > > your subscriptions between normal and digest modes here: > > > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > > ********************************************************************** > > > > > > > > > -- > > Tim Blankenship > > [EMAIL PROTECTED] > > > > > -- > Tim Blankenship > [EMAIL PROTECTED] > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
