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