URL Method for 3 tables?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bonneylake
    Contributor
    • Aug 2008
    • 769

    #16
    Originally posted by acoder
    You can remove those queries from page 1 and put them in page 2.
    Hey Acoder,

    Wow can't believe it was so simple! THANK YOU THANK YOU, YOUR AWESOME!!! If you don't mind me asking just one more question. Ok i been running into a problem where if someone does not fill out a field it doesn't show the field at all. It will show the name next to the field, but the field itself no an was wondering how would i make the field still show up even with a value applied to the field.

    Example
    Code:
    <input type="text" name="serialnum_' + count + '" value="#pka_serialNo#">
    I have tried
    Code:
    <cfparam name="Form.pka_serialNo" default="">
    but because i have a value applied to it, it don't work so was wondering if there was a work around.

    Thank you again,
    Rach

    Comment

    • acoder
      Recognized Expert MVP
      • Nov 2006
      • 16032

      #17
      The user wouldn't be entering the pk_serialno value, would they? Is pka_serialNo a query value or a form variable?

      Comment

      • bonneylake
        Contributor
        • Aug 2008
        • 769

        #18
        Originally posted by acoder
        The user wouldn't be entering the pk_serialno value, would they? Is pka_serialNo a query value or a form variable?
        Hey Acoder,

        the pka_serialNo is the query value. I tried to put the serialnum_ as the name but ran into trouble with that as well.

        Thank you,
        Rach

        Comment

        • acoder
          Recognized Expert MVP
          • Nov 2006
          • 16032

          #19
          Can you show the rest of the code that displays the query data?

          Comment

          • bonneylake
            Contributor
            • Aug 2008
            • 769

            #20
            Originally posted by acoder
            Can you show the rest of the code that displays the query data?
            Hey Acoder,

            Its the same code i been showing you in the how to loop through this post. What happens is basically i have one record where someone didn't enter anything in the serial table or parts table an basically the serial table don't show up and some parts of the parts table shows up. An although nothing was entered in either it still needs to show up the field as blank (like if you click on add serial it shows all the fields blank). However, it instead just shows nothing. Here is what i have

            Code:
            <input type="hidden" value="0" id="theValue" />
                 <div id="dynamicInput">
                 <!--- All Ticket Information Appears Here--->
                <!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure  --->
            
            <cfset count = 0>
            <cfoutput query="serial">
            
            <cfset model_no = #model_no#>
            <cfset product_type = #product_type#>
            <cfset type_hardware_failure = #type_hardware_failure#>
            <cfset software_hardware = #software_hardware#>
            <cfset resolution_verified_by = #resolution_verified_by#>
            <cfset dept_responsibility = #dept_responsibility#>
            <table class="zpExpandedTable" id="modeltable"> 
            <th class="sectiontitletick" colspan="7">
            <cfset count = count + 1>
            Serial Information #count# </th>
            <tr>
            <td id="paddingformultitop">Model No:&nbsp;&nbsp;&nbsp;&nbsp;</td>
            </td>
            <td>
            <select name="modelno_' + count + '">
            <option value="">Make A Selection</option>
            <cfloop query="models">
            <option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
            </cfloop> 
            </select>
            </td>
            <td>
            &nbsp;&nbsp;&nbsp;&nbsp;Product Type:
            </td>
            <td>
            <select name="producttype_' + count + '">
            <option value="" selected>No Choice</option>
            <cfloop query="getProdType">
            <option value="#pk_productType#"<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option> 
            </cfloop>
            </select>
            </td>
            <td class="red'">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type Of Hardware Failure*:
            </td>
            <td>
            <select name="hardwarefailure_' + count + '">
            <option value="" selected>Make A Selection</option>
            <cfloop query="getHardwareFail">
            <option value="#pk_hardwareFailure#"<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>
            </cfloop>
            </select>
            </td>
            </tr>
            <table>
             
            <!--- Shows what was previously entered for Serial Number and Software/Hardware  --->
            <table class="zpExpandedTable" id="modeltable">
            <tr>
            <td id="paddingformultitop">
            Serial Number:&nbsp;&nbsp;
            <input type="text" name="serialnum_' + count + '" value="#pka_serialNo#">
            &nbsp;&nbsp;&nbsp;&nbsp;Software/Hardware:&nbsp;&nbsp;
            <select name="softhardware_' + count + '">
            <option value="" selected>No Choice</option>
            <cfloop query="getSoftHard">
            <option value="#pk_softwareHardware#"<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>
            </cfloop>
            </select>
            </td>
            </tr>
            </table>
            
            <!--- Shows what was previously entered for Description ---> 
            
            <table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
            <tr>
            <td id="paddingformutli">
            Description:&nbsp;&nbsp;
            </td>
            <td class="descriptionmoveinmulti">
            ( You may enter up to 500 characters. )
            <br>
            <cfloop query="description"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="thedescription_' + count + '">#description#</textarea></cfloop> 
            </td>
            </tr>
            </table>
             
            <!---Shows what was previously entered for Resolution  --->
            
            <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
            <tr>
            <td id="paddingformutli">
            Resolution:&nbsp;&nbsp;
            </td>
            <td class="resolutionmoveinmulti">
            ( You may enter up to 500 characters. )
            <br>
            <textarea  maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="resolution_' + count + '">#resolution#</textarea>
            </td>
            </tr>
            </table>
             
            <!--- Shows what was previously entered for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by  --->
            
            <table class="zpExpandedTable" id="resoldatetab" cellpadding="1" cellspacing="0">
            <tr>
            <td id="paddingformultitop">
            Resolution Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
            </td>
            <td>
            <input type="text" name="resdate_' + count + '" value="#resolution_date#">&nbsp;&nbsp;
             
            &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
            <!---<input type="checkbox" name="currentdateresol_' + count + '" onClick=resdate_" + count + ".value=fill_date()>--->
            
            </td>
            <td>
            Resolution Verified as effective by:&nbsp;&nbsp;
            </td>
            <td>
            <select name="resvertified_' + count + '">
            <option value="" selected>Make A Selection</option>
            <cfloop query="gettech">
            <option value="#fname# #lname#"<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>
            </cfloop>
            </select>
            </td>
            </tr>
            </table>
            <!--- Shows what was previously entered for Vertification Date, Current Date (for vertification date)   --->
            <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
            <tr>
            <td id="paddingformultitop">
            Verification Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
            </td>
            <td class="vertificationmoveinmulti">
            <input type="text" name="vertifidate_' + count + '" value="#verification_date#">&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
            <!---<input type="checkbox" name="currentdatevert_' + count + '" onClick=vertifidate_" + count + ".value=fill_date()>--->
            </td>
            </tr>
            </table>
             
            <!--- Shows what was previously entered for Dept/Vendor Responsibility  --->
            <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
            <tr>
            <td class="red" id="paddingformultitop">
            Dept/Vendor Responsibility*:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <select name="deptvendor_' + count + '">
            <option value="" selected>Make A Selection</option>
            <cfloop query="getDeptVendor">
            <option value="#pk_deptVendor#"<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>
            </cfloop>
            </select>
            </td>
            </tr>
            </table>
             
            <!--- Shows what was previously entered for RMA Data Only  --->
            <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
            <tr>
            <td id="paddingformultitop">
            RMA Data Only:&nbsp;&nbsp;&nbsp;&nbsp;
            </td>
            <td class="rmanmoveinmulti">
            ( You may enter up to 500 characters. )
            <br/>
            <textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="rma_' + count + '" >#rma_data#</textarea>
            </td>
            </tr>
            </table>
            <input type="hidden" name="serialcount" value="' + count + '">
             
            <!--- Adds Delete to every ticket  --->
            <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
            <tr>
            <td>
            <!---<input type="button" class="removeticket" value="Remove Serial &quot;'+count +'&quot;" onclick=\"removeElement(\'"+divIdName+"\')\">--->
            </td>
            </tr>
            </table>
            
                 </div>
            </cfoutput>
                 <script type="text/javascript">
            var count = <cfoutput>#count#</cfoutput>
            </script>
                 <input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
            Thank you,
            Rach

            Comment

            • acoder
              Recognized Expert MVP
              • Nov 2006
              • 16032

              #21
              Although this may not solve the problem, I've noticed code that may be part of the problem and will no doubt cause problems in the future. Where you have code like:
              Code:
              name="serialnum_' + count + '"
              needs to be replaced with
              Code:
              name="serialnum_#count#"
              You forgot to translate some of the JavaScript when converting.

              Comment

              • bonneylake
                Contributor
                • Aug 2008
                • 769

                #22
                Originally posted by acoder
                Although this may not solve the problem, I've noticed code that may be part of the problem and will no doubt cause problems in the future. Where you have code like:
                Code:
                name="serialnum_' + count + '"
                needs to be replaced with
                Code:
                name="serialnum_#count#"
                You forgot to translate some of the JavaScript when converting.
                Hey Acoder,

                Yeah i was going to ask you about the count towards the end, but probably should of asked that earlier. But that still didn't solve the problem. here is what i have

                Code:
                <!--- Ticket Information 
                       This display the ticket Information--->
                    
                <input type="hidden" value="0" id="theValue" />
                     <div id="dynamicInput">
                     <!--- All Ticket Information Appears Here--->
                    <!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure  --->
                
                <cfset count = 0>
                <cfoutput query="serial">
                <cfset model_no = #model_no#>
                <cfset product_type = #product_type#>
                <cfset type_hardware_failure = #type_hardware_failure#>
                <cfset software_hardware = #software_hardware#>
                <cfset resolution_verified_by = #resolution_verified_by#>
                <cfset dept_responsibility = #dept_responsibility#>
                <table class="zpExpandedTable" id="modeltable"> 
                <th class="sectiontitletick" colspan="7">
                <cfset count = count + 1>
                Serial Information #count# </th>
                <tr>
                <td id="paddingformultitop">Model No:&nbsp;&nbsp;&nbsp;&nbsp;</td>
                </td>
                <td>
                <select name="modelno_#count#">
                <option value="">Make A Selection</option>
                <cfloop query="models">
                <option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
                </cfloop> 
                </select>
                </td>
                <td>
                &nbsp;&nbsp;&nbsp;&nbsp;Product Type:
                </td>
                <td>
                <select name="producttype_#count#">
                <option value="" selected>No Choice</option>
                <cfloop query="getProdType">
                <option value="#pk_productType#"<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option> 
                </cfloop>
                </select>
                </td>
                <td class="red'">
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type Of Hardware Failure*:
                </td>
                <td>
                <select name="hardwarefailure_#count#">
                <option value="" selected>Make A Selection</option>
                <cfloop query="getHardwareFail">
                <option value="#pk_hardwareFailure#"<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>
                </cfloop>
                </select>
                </td>
                </tr>
                <table>
                 
                <!--- Shows what was previously entered for Serial Number and Software/Hardware  --->
                <table class="zpExpandedTable" id="modeltable">
                <tr>
                <td id="paddingformultitop">
                Serial Number:&nbsp;&nbsp;
                <input type="text" name="serialnum_#count#" value="#pka_serialNo#">
                &nbsp;&nbsp;&nbsp;&nbsp;Software/Hardware:&nbsp;&nbsp;
                <select name="softhardware_#count#">
                <option value="" selected>No Choice</option>
                <cfloop query="getSoftHard">
                <option value="#pk_softwareHardware#"<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>
                </cfloop>
                </select>
                </td>
                </tr>
                </table>
                
                <!--- Shows what was previously entered for Description ---> 
                
                <table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
                <tr>
                <td id="paddingformutli">
                Description:&nbsp;&nbsp;
                </td>
                <td class="descriptionmoveinmulti">
                ( You may enter up to 500 characters. )
                <br>
                <cfloop query="description"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="thedescription_#count#">#description#</textarea></cfloop> 
                </td>
                </tr>
                </table>
                 
                <!---Shows what was previously entered for Resolution  --->
                
                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                <tr>
                <td id="paddingformutli">
                Resolution:&nbsp;&nbsp;
                </td>
                <td class="resolutionmoveinmulti">
                ( You may enter up to 500 characters. )
                <br>
                <textarea  maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="resolution_#count#">#resolution#</textarea>
                </td>
                </tr>
                </table>
                 
                <!--- Shows what was previously entered for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by  --->
                
                <table class="zpExpandedTable" id="resoldatetab" cellpadding="1" cellspacing="0">
                <tr>
                <td id="paddingformultitop">
                Resolution Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
                </td>
                <td>
                <input type="text" name="resdate_#count#" value="#resolution_date#">&nbsp;&nbsp;
                 
                &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
                <!---<input type="checkbox" name="currentdateresol_' + count + '" onClick=resdate_" + count + ".value=fill_date()>--->
                
                </td>
                <td>
                Resolution Verified as effective by:&nbsp;&nbsp;
                </td>
                <td>
                <select name="resvertified_#count#">
                <option value="" selected>Make A Selection</option>
                <cfloop query="gettech">
                <option value="#fname# #lname#"<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>
                </cfloop>
                </select>
                </td>
                </tr>
                </table>
                <!--- Shows what was previously entered for Vertification Date, Current Date (for vertification date)   --->
                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                <tr>
                <td id="paddingformultitop">
                Verification Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
                </td>
                <td class="vertificationmoveinmulti">
                <input type="text" name="vertifidate_#count#" value="#verification_date#">&nbsp;&nbsp;
                &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
                <!---<input type="checkbox" name="currentdatevert_' + count + '" onClick=vertifidate_" + count + ".value=fill_date()>--->
                </td>
                </tr>
                </table>
                 
                <!--- Shows what was previously entered for Dept/Vendor Responsibility  --->
                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                <tr>
                <td class="red" id="paddingformultitop">
                Dept/Vendor Responsibility*:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <select name="deptvendor_#count#">
                <option value="" selected>Make A Selection</option>
                <cfloop query="getDeptVendor">
                <option value="#pk_deptVendor#"<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>
                </cfloop>
                </select>
                </td>
                </tr>
                </table>
                 
                <!--- Shows what was previously entered for RMA Data Only  --->
                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                <tr>
                <td id="paddingformultitop">
                RMA Data Only:&nbsp;&nbsp;&nbsp;&nbsp;
                </td>
                <td class="rmanmoveinmulti">
                ( You may enter up to 500 characters. )
                <br/>
                <textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="rma_#count#" >#rma_data#</textarea>
                </td>
                </tr>
                </table><input type="hidden" value="#count#" id="theValue" />
                <input type="hidden" name="serialcount" value="' + count + '">
                 
                <!--- Adds Delete to every ticket  --->
                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                <tr>
                <td>
                <!---<input type="button" class="removeticket" value="Remove Serial &quot;'+count +'&quot;" onclick=\"removeElement(\'"+divIdName+"\')\">--->
                </td>
                </tr>
                </table>
                
                     </div>
                </cfoutput>
                     <input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
                Thank you,
                Rach

                Comment

                • acoder
                  Recognized Expert MVP
                  • Nov 2006
                  • 16032

                  #23
                  Oh right, if you have no data in the table, it's not going to show whatever code is in the loop. What you can do is add a check for the recordcount. If it's 0, show the blank fields.

                  Comment

                  • bonneylake
                    Contributor
                    • Aug 2008
                    • 769

                    #24
                    Originally posted by acoder
                    Oh right, if you have no data in the table, it's not going to show whatever code is in the loop. What you can do is add a check for the recordcount. If it's 0, show the blank fields.
                    Hey Acoder,

                    Bit confused on what you mean with the recordcount? are you meaning to do something like

                    Code:
                    <cfparam name="Form.recordcount" default="">
                    Thank you,
                    Rach

                    Comment

                    • acoder
                      Recognized Expert MVP
                      • Nov 2006
                      • 16032

                      #25
                      No, the recordcount of the serial query, i.e. check serial.recordco unt is 0.

                      Comment

                      • bonneylake
                        Contributor
                        • Aug 2008
                        • 769

                        #26
                        Originally posted by acoder
                        No, the recordcount of the serial query, i.e. check serial.recordco unt is 0.
                        Hey Acoder,

                        so like this
                        Code:
                        <cfparam name="serial.recordcount" default="0">
                        or does it need to be somewhere else?

                        Thank you,
                        Rach

                        Comment

                        • acoder
                          Recognized Expert MVP
                          • Nov 2006
                          • 16032

                          #27
                          You don't need to use cfparam. Use cfif to check the query recordcount.

                          Comment

                          • bonneylake
                            Contributor
                            • Aug 2008
                            • 769

                            #28
                            Originally posted by acoder
                            You don't need to use cfparam. Use cfif to check the query recordcount.
                            Hey Acoder,

                            so something like this
                            Code:
                            <cfif serial.recordcount is 0/>
                            an does it need to be up with the cfparam or does it need to be somewhere else?

                            Thank you,
                            Rach

                            Comment

                            • acoder
                              Recognized Expert MVP
                              • Nov 2006
                              • 16032

                              #29
                              Don't close it with / - close with a </cfif>

                              Put it wherever you want to display the empty fields (obviously including the HTML within the tags).

                              Comment

                              • bonneylake
                                Contributor
                                • Aug 2008
                                • 769

                                #30
                                Originally posted by acoder
                                Don't close it with / - close with a </cfif>

                                Put it wherever you want to display the empty fields (obviously including the HTML within the tags).
                                Hey Acoder,

                                its still not working. An i have also noticed that if i try to click add serial it gives me an error an it takes me to this line in the javascript

                                Code:
                                var count = (document.getElementById('theValue').value -1)+ 2;
                                an continues to basically lead me to anything that involves count. but here is the
                                div part of it again.
                                Code:
                                 <div id="dynamicInput">
                                     <!--- All Ticket Information Appears Here--->
                                    <!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure  --->
                                
                                
                                
                                
                                <cfif parts.recordcount is 0></cfif>
                                <cfset count = 0>
                                <cfoutput query="serial">
                                <cfset model_no = #model_no#>
                                <cfset product_type = #product_type#>
                                <cfset type_hardware_failure = #type_hardware_failure#>
                                <cfset software_hardware = #software_hardware#>
                                <cfset resolution_verified_by = #resolution_verified_by#>
                                <cfset dept_responsibility = #dept_responsibility#>
                                <cfif serial.recordcount is 0>
                                <table class="zpExpandedTable" id="modeltable"> 
                                <th class="sectiontitletick" colspan="7">
                                <cfset count = count + 1>
                                Serial Information #count# </th>
                                <tr>
                                <td id="paddingformultitop">Model No:&nbsp;&nbsp;&nbsp;&nbsp;</td>
                                </td>
                                <td>
                                <select name="modelno_#count#">
                                <option value="">Make A Selection</option>
                                <cfloop query="models">
                                <option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
                                </cfloop> 
                                </select>
                                
                                </td>
                                <td>
                                &nbsp;&nbsp;&nbsp;&nbsp;Product Type:
                                </td>
                                <td>
                                <select name="producttype_#count#">
                                <option value="" selected>No Choice</option>
                                <cfloop query="getProdType">
                                <option value="#pk_productType#"<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option> 
                                </cfloop>
                                </select>
                                </td>
                                <td class="red'">
                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type Of Hardware Failure*:
                                </td>
                                <td>
                                <select name="hardwarefailure_#count#">
                                <option value="" selected>Make A Selection</option>
                                <cfloop query="getHardwareFail">
                                <option value="#pk_hardwareFailure#"<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>
                                </cfloop>
                                </select>
                                </td>
                                </tr>
                                <table>
                                 
                                <!--- Shows what was previously entered for Serial Number and Software/Hardware  --->
                                <table class="zpExpandedTable" id="modeltable">
                                <tr>
                                <td id="paddingformultitop">
                                Serial Number:&nbsp;&nbsp;
                                <input type="text" name="serialnum_#count#" value="#pka_serialNo#">
                                &nbsp;&nbsp;&nbsp;&nbsp;Software/Hardware:&nbsp;&nbsp;
                                <select name="softhardware_#count#">
                                <option value="" selected>No Choice</option>
                                <cfloop query="getSoftHard">
                                <option value="#pk_softwareHardware#"<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>
                                </cfloop>
                                </select>
                                </td>
                                </tr>
                                </table>
                                
                                <!--- Shows what was previously entered for Description ---> 
                                
                                <table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
                                <tr>
                                <td id="paddingformutli">
                                Description:&nbsp;&nbsp;
                                </td>
                                <td class="descriptionmoveinmulti">
                                ( You may enter up to 500 characters. )
                                <br>
                                <cfloop query="description"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="thedescription_#count#">#description#</textarea></cfloop> 
                                </td>
                                </tr>
                                </table>
                                 
                                <!---Shows what was previously entered for Resolution  --->
                                
                                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                                <tr>
                                <td id="paddingformutli">
                                Resolution:&nbsp;&nbsp;
                                </td>
                                <td class="resolutionmoveinmulti">
                                ( You may enter up to 500 characters. )
                                <br>
                                <textarea  maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="resolution_#count#">#resolution#</textarea>
                                </td>
                                </tr>
                                </table>
                                 
                                <!--- Shows what was previously entered for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by  --->
                                
                                <table class="zpExpandedTable" id="resoldatetab" cellpadding="1" cellspacing="0">
                                <tr>
                                <td id="paddingformultitop">
                                Resolution Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
                                </td>
                                <td>
                                <input type="text" name="resdate_#count#" value="#resolution_date#">&nbsp;&nbsp;
                                 
                                &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
                                <!---<input type="checkbox" name="currentdateresol_' + count + '" onClick=resdate_" + count + ".value=fill_date()>--->
                                
                                </td>
                                <td>
                                Resolution Verified as effective by:&nbsp;&nbsp;
                                </td>
                                <td>
                                <select name="resvertified_#count#">
                                <option value="" selected>Make A Selection</option>
                                <cfloop query="gettech">
                                <option value="#fname# #lname#"<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>
                                </cfloop>
                                </select>
                                </td>
                                </tr>
                                </table>
                                <!--- Shows what was previously entered for Vertification Date, Current Date (for vertification date)   --->
                                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                                <tr>
                                <td id="paddingformultitop">
                                Verification Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;
                                </td>
                                <td class="vertificationmoveinmulti">
                                <input type="text" name="vertifidate_#count#" value="#verification_date#">&nbsp;&nbsp;
                                &nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;
                                <!---<input type="checkbox" name="currentdatevert_' + count + '" onClick=vertifidate_" + count + ".value=fill_date()>--->
                                </td>
                                </tr>
                                </table>
                                 
                                <!--- Shows what was previously entered for Dept/Vendor Responsibility  --->
                                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                                <tr>
                                <td class="red" id="paddingformultitop">
                                Dept/Vendor Responsibility*:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                <select name="deptvendor_#count#">
                                <option value="" selected>Make A Selection</option>
                                <cfloop query="getDeptVendor">
                                <option value="#pk_deptVendor#"<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>
                                </cfloop>
                                </select>
                                </td>
                                </tr>
                                </table>
                                 
                                <!--- Shows what was previously entered for RMA Data Only  --->
                                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                                <tr>
                                <td id="paddingformultitop">
                                RMA Data Only:&nbsp;&nbsp;&nbsp;&nbsp;
                                </td>
                                <td class="rmanmoveinmulti">
                                ( You may enter up to 500 characters. )
                                <br/>
                                <textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="rma_#count#" >#rma_data#</textarea>
                                </td>
                                </tr>
                                </table>
                                <input type="hidden" value="#count#" id="theValue" />
                                <input type="hidden" name="serialcount" value="#count#">
                                 
                                <!--- Adds Delete to every ticket  --->
                                <table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
                                <tr>
                                <td>
                                <!---<input type="button" class="removeticket" value="Remove Serial &quot;'+count +'&quot;" onclick=\"removeElement(\'"+divIdName+"\')\">--->
                                </td>
                                </tr>
                                </table>
                                </cfif>
                                </div>
                                </cfoutput>
                                     <input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
                                Thank you,
                                Rach

                                Comment

                                Working...