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]
**********************************************************************
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
**********************************************************************
