Release Initials on edit action page

hi,

    have edit page i'm trying update info. in database. have multiple tables info. , having problem getting release approval initials approvals table display on action page.

        able figure out how to  release approval initials display on edit_all_ec_number_action.cfm page, i’m having problem getting them display on docs_to_be_removed_all_action.cfm page. 1 page further past original action page.

      basically, on edit page, if “i” chosen docs removed p drive drop down menu, go action page , display info. entered, have code intercepts first, enter docs removed. then, once click update on page, goes docs_to_be_removed_all_action.cfm page. page i’m having problem getting release approval initials display.  how supposed pass them edit_all_ec_number_action.cfm page action page? have on edit page:

 

<cfquery name="displayapprovalitem" datasource="#application.datasource#">

        select *

        approval

         approval.apv_itemid = #url.itemid#

    </cfquery>

 

<cfquery name="showitem" datasource="#application.datasource#">

select ecid, requested_by_initials, ec_completion_initials, ec_completion_date, flag_comments, comments, itemid, ecid_spec, eco_start_date, date_requested, requested_by_initials, part_number, description, cn_entry, p_drive_docs, dismiss_part_number, release_status, validation_itemid, validation_ecid, validation_qty, docs_to_remove, sw_model_only, pnr_bom_change_only, doc_changes_only, doc_removal_date,

 

approval_release.approval_initials release_initials

 

from eco_master left join eco_items on eco_master.ecid = eco_items.ecid_spec

left join validation_records on eco_items.itemid = validation_records.validation_itemid

left join approval on eco_items.itemid = approval.apv_itemid

 

left join approval approval_release on eco_items.itemid = approval_release.apv_itemid , approval_release.document_type = 'release'

 

where    itemid=#url.itemid#

 

order itemid

</cfquery>

 

 

<tr>

<td class="edit" align="right">release initials:</td>

<td colspan="2">

<cfif displayapprovalitem.recordcount>

<cfset releaseinitials = showitem.release_initials>

 

            <select name="release_approval_initials#itemid#" id="release_approval_initials#itemid#">

                <option value=""></option>

                <cfloop query="showdataentryinitials">

                    <option value="#initials#"

                    <cfif initials eq releaseinitials>selected

                    </cfif>>#initials#</option>

                </cfloop>

            </select>

           

<cfelse>

<font color = "red">the approval has not been filled out.</font>

</cfif>

</td>

</tr>

 

 

 

this have on edit_all_ec_number_action.cfm page initials pass next action page:

 

<cfif isdefined ("form.release_approval_initials")>

<input type="hidden" name="release_approval_initials" value="#release_approval_initials#">

</cfif>

 

<input type="hidden" name="listofids" id="listofids" value="#valuelist(showitem.itemid)#">

 

 

 

then on docs_to_be_removed_all_action.cfm page, have output initials, doesn’t display anything. says variable id undefined.

 

<cfif isdefined ("form.release_approval_initials#id#") and

"form.release_approval_initials#id#" neq "">

#evaluate("form.release_approval_initials#id#")#

<cfelse>

 

</cfif>

 

    have ideas can try? thanks.

 

  andy

i think fixed edit pages having problem with. needed remove #itemid# edit page on release_approval_initials drop down menu name.

 

andy

More discussions in ColdFusion

adobe