All fixed. I was a dumbass and had column names that where reserved
words. IE Create & Modify.
PLUM is flying now!
On 4/8/06, David Churvis <[EMAIL PROTECTED]> wrote:
> Tim,
>
> That's strange - I can't see anything wrong with that statement, so there
> must be some really weird Oracle issue here.  You might ask your DBA or
> another Oracle person if he can see what's problematic.
>
> David
> ----- Original Message -----
> From: "Tim Blankenship" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Friday, April 07, 2006 2:42 PM
> Subject: Re: [plum] Column not found using cf_insertrecord
>
>
> This is from SQL*PLUS - So it looks like a SQL/Oracle issue.
>
>
> Connected to:
> Personal Oracle9i Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL> INSERT INTO UNIXVMS( SBCUID, CREATE, MODIFY, REMOVE_ACCESS,
> GRANT_SUDO_ACCESS, EXPLAIN_SUDO_REQ
> UIRNMENT, LIST_SERVERS, VMS_REQUIRNMENT ) VALUES ( 'TB6859', 'y', 'y',
> 'y', 'y', 'y', 'y', 'y' );
> INSERT INTO UNIXVMS( SBCUID, CREATE, MODIFY, REMOVE_ACCESS,
> GRANT_SUDO_ACCESS, EXPLAIN_SUDO_REQUIRNM
>                              *
> ERROR at line 1:
> ORA-01747: invalid user.table.column, table.column, or column specification
>
>
>
> On 4/7/06, Tim Blankenship <[EMAIL PROTECTED]> wrote:
> > Alright this is so freaking weird!
> > I went into databaseblocks.cfc and went to the error section ---
> > VALUES (#PreserveSingleQuotes(Arguments.values)#)       ---- Line 148
> > So I delete some white space on the page moving it line 147, 146, and
> > multiple other locations. No matter what happens on the CF page line
> > 148 errors! Even if there is nothing on line 148.
> >
> > EX1 - error 148
> > 146 :           </cfquery>
> > 147 :   </cffunction>
> > 148 :
> > 149 :
> > 150 :   <!--- Insert and return key --->
> >
> > EX2 - erro 148
> > 146 :
> > 147 :
> > 148 :           </cfquery>
> > 149 :   </cffunction>
> > 150 :
> >
> > Now thats AFU!
> >
> > On 4/7/06, Tim Blankenship <[EMAIL PROTECTED]> wrote:
> > > I did the following SQL earlier in a CF page and it works.
> > > INSERT INTO "CIS"."UNIX_VMS" ("SBCUID" ,"CREATE" ,"MODIFY" ,
> > >
> > >    "REMOVE_ACCESS" ,"GRANT_SUDO_ACCESS" ,
> > >    "EXPLAIN_SUDO_REQUIRNMENT" ,"LIST_SERVERS" ,"VMS_REQUIRNMENT"
> > >    )
> > >
> > >    VALUES ('TB6859' ,'' ,'' ,'' ,'' ,'' ,'' ,''  )
> > >
> > >
> > >
> > >
> > > On 4/6/06, Tim Blankenship <[EMAIL PROTECTED]> wrote:
> > > > I'll check in the AM, I need to get some rest.
> > > > ---keep your pimp hand strong!
> > > > On 4/6/06, David Churvis <[EMAIL PROTECTED]> wrote:
> > > > > 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
> > > > >
> **********************************************************************
> > > > >
> > > >
> > > >
> > > > --
> > > > Tim Blankenship
> > > > [EMAIL PROTECTED]
> > > >
> > >
> > >
> > > --
> > > Tim Blankenship
> > > [EMAIL PROTECTED]
> > >
> >
> >
> > --
> > 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
**********************************************************************

Reply via email to