Hey Everyone,
What i am trying to do is show previously entered information. I know i need a loop for this , but i am not sure how to loop through this based on my form appears all in the javascript
here is my code - <cfquery name="serial" datasource="CustomerSupport">
-
SELECT pka_serialNo,pkb_fk_ticketNo,model_no,product_type,software_hardware,resolution,resolution_date,
-
verification_date,rma_data,type_hardware_failure,dept_responsibility,resolution_verified_by FROM dbo.tbl_CS_serial
-
</cfquery>
-
-
<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#>
-
</cfoutput>
-
-
<script type="text/javascript">
-
-
<!---Allows us to show previous fields --->
-
-
function showInput(divName){
-
var dynamic = document.getElementById('dynamicInput');
-
var thevalue = document.getElementById('theValue');
-
var count = (document.getElementById('theValue').value -1)+ 2;
-
thevalue.value = count;
-
var newdiv = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
newdiv.setAttribute('id',divIdName);
-
-
-
<!--- Adds Extra fields for Model No, Product Type, and Type of Hardware Failure --->
-
newdiv.innerHTML =
-
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>Model No: </td>" +
-
"</td>" +
-
"<td>" +
-
"<select name='modelno_" + count + "'>" +
-
"<option value=''>Make A Selection</option>" +
-
"<cfoutput query='models'>" +
-
"<option value='#model#'<cfif #model# is #evaluate(model_no)#>selected</cfif>>#model#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td>" +
-
" Product Type:" +
-
"</td>" +
-
"<td>" +
-
"<select name='producttype_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getProdType'>" +
-
"<option value='#pk_productType#'<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td class='red'>" +
-
" Type Of Hardware Failure*:" +
-
"</td>" +
-
"<td>" +
-
"<select name='hardwarefailure_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getHardwareFail'>" +
-
"<option value='#pk_hardwareFailure#'<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"<table>";
-
-
<!--- Adds Extra fields for Serial Number and Software/Hardware --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Serial Number: " +
-
"<cfoutput query="serial"><input type='text' name='serialnum_" + count + "' value='#pka_serialNo#' ></cfoutput>" +
-
" Software/Hardware: " +
-
"<select name='softhardware_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getSoftHard'>" +
-
"<option value='#pk_softwareHardware#'<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Description --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='3' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Description: " +
-
"</td>" +
-
"<td class='descriptionmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br>" +
-
"<cfoutput query="description"><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)'rows='4' cols='60' name='thedescription_" + count + "'>#description#</textarea></cfoutput>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Resolution: " +
-
"</td>" +
-
"<td class='resolutionmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br>" +
-
"<cfoutput query='serial'><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)' rows='4' cols='60' name='resolution_" + count + "'>#resolution#</textarea></cfoutput>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoldatetab' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Resolution Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td>" +
-
"<cfoutput query='serial'><input type='text' name='resdate_" + count + "' value='#resolution_date#'> </cfoutput>" +
-
-
" Current Date: " +
-
"<input type='checkbox' name='currentdateresol_" + count + "' onClick=resdate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"<td>" +
-
"Resolution Verified as effective by: " +
-
"</td>" +
-
"<td>" +
-
"<select name='resvertified_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='gettech'>" +
-
"<option value='#fname# #lname#'<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Extra fields for Vertification Date, Current Date (for vertification date) --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Verification Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td class='vertificationmoveinmulti'>" +
-
"<cfoutput query='serial'><input type='text' name='vertifidate_" + count + "' value='#verification_date#'> </cfoutput>" +
-
" Current Date: " +
-
"<input type='checkbox' name='currentdatevert_" + count + "' onClick=vertifidate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Dept/Vendor Responsibility --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td class='red' id='paddingformultitop'>" +
-
"Dept/Vendor Responsibility*: " +
-
"<select name='deptvendor_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getDeptVendor'>" +
-
"<option value='#pk_deptVendor#'<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"RMA Data Only: " +
-
"</td>" +
-
"<td class='rmanmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br/>" +
-
"<cfoutput query='serial'><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)' rows='4' cols='60' name='rma_" + count + "' >#rma_data#</textarea></cfoutput> " +
-
"</td>" +
-
"</tr>" +
-
"</table>" +
-
"<input type='hidden' name='serialcount' value='" + count + "'>";
-
-
<!--- Adds Delete to every ticket --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='removeticket' value='Remove Serial ""+count +""' onclick=\"removeElement(\'"+divIdName+"\')\"></a>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table><br>";
-
-
document.getElementById(divName).appendChild(newdiv);
-
-
}
-
</script>
i was using this after i submitted my form to loop through it. it was used to submit the form fields and also show a print screen on what was previously entered. - <CFSET machineListLen = listLen(Form.serialcount)>
-
<CFLOOP from="1" to="#machineListLen#" index="machineCount">
-
<CFSET serialnum = "Form.serialnum_" & machineCount>
-
<CFSET modelno = "Form.modelno_" & machineCount>
-
<CFSET producttype = "Form.producttype_" & machineCount>
-
<CFSET softhardware = "Form.softhardware_" & machineCount>
-
<CFSET resolution = "Form.resolution_" & machineCount>
-
<CFSET resdate = "Form.resdate_" & machineCount>
-
<CFSET resvertified = "Form.resvertified_" & machineCount>
-
<CFSET vertifidate = "Form.vertifidate_" & machineCount>
-
<CFSET deptvendor = "Form.deptvendor_" & machinecount>
-
<CFSET hardwarefailure = "Form.hardwarefailure_" & machineCount>
-
<CFSET rma = "Form.rma_" & machineCount>
-
<CFSET thedescription = "Form.thedescription_" & machineCount>
-
-
#evaluate(modelno)#....an so on.
but i am not sure if i can combine the above with what i have now because i am showing previously entered data an not entering the data.
Thank you for all the help,
Rach
60  5283  acoder 16,027
Recognized Expert Moderator MVP
Rather than using JavaScript to show the information onload, use Coldfusion directly in the HTML inside the "dynamicInp ut" div using a loop (cfoutput or cfloop) to loop over the query. Convert the JavaScript innerHTML statements into normal HTML code.
Rather than using JavaScript to show the information onload, use Coldfusion directly in the HTML inside the "dynamicInp ut" div using a loop (cfoutput or cfloop) to loop over the query. Convert the JavaScript innerHTML statements into normal HTML code.
Hey Acoder,
Ok so let me make sure i understand you correctly.So take all the form information inside the javascript copy it and turn it into just HTML an put it in my <div id="dynamicInpu t"> an then apply the cfloop to it. Then in the javscript part turn it in just HTML? Just want to make sure i understand before i go ahead.
Thank you,
Rach
acoder 16,027
Recognized Expert Moderator MVP
Almost. There's no need for any JavaScript here because you're calling it onload anyway. Convert all the JavaScript into Coldfusion instead so that the table/form appears whilst the page is loading and not after. To convert the JavaScript is not difficult. Take all the table and form code and put it directly in the div. The cfloop would be for each ticket, so there would be no repetition.
Almost. There's no need for any JavaScript here because you're calling it onload anyway. Convert all the JavaScript into Coldfusion instead so that the table/form appears whilst the page is loading and not after. To convert the JavaScript is not difficult. Take all the table and form code and put it directly in the div. The cfloop would be for each ticket, so there would be no repetition.
Hey Acoder,
I hate to say this but i am still very confused. This is what i have below. Do i need to remove the function showInput since i was using that one to show what was previously entered? an do i apply the cfloop i was using above or do i create a different one? a bit confused. - <script type="text/javascript">
-
-
<!---Allows us to show previous fields --->
-
-
function showInput(divName){
-
var dynamic = document.getElementById('dynamicInput');
-
var thevalue = document.getElementById('theValue');
-
var count = (document.getElementById('theValue').value -1)+ 2;
-
thevalue.value = count;
-
var newdiv = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
newdiv.setAttribute('id',divIdName);
-
-
-
<!--- Adds Extra fields for Model No, Product Type, and Type of Hardware Failure --->
-
newdiv.innerHTML =
-
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>Model No: </td>" +
-
"</td>" +
-
"<td>" +
-
"<select name='modelno_" + count + "'>" +
-
"<option value=''>Make A Selection</option>" +
-
"<cfoutput query='models'>" +
-
"<option value='#model#'<cfif #model# is #model_no#>selected</cfif>>#model#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td>" +
-
" Product Type:" +
-
"</td>" +
-
"<td>" +
-
"<select name='producttype_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getProdType'>" +
-
"<option value='#pk_productType#'<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td class='red'>" +
-
" Type Of Hardware Failure*:" +
-
"</td>" +
-
"<td>" +
-
"<select name='hardwarefailure_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getHardwareFail'>" +
-
"<option value='#pk_hardwareFailure#'<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"<table>";
-
-
<!--- Adds Extra fields for Serial Number and Software/Hardware --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Serial Number: " +
-
"<cfoutput query="serial"><input type='text' name='serialnum_" + count + "' value='#pka_serialNo#' ></cfoutput>" +
-
" Software/Hardware: " +
-
"<select name='softhardware_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getSoftHard'>" +
-
"<option value='#pk_softwareHardware#'<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Description --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='3' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Description: " +
-
"</td>" +
-
"<td class='descriptionmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br>" +
-
"<cfoutput query="description"><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)'rows='4' cols='60' name='thedescription_" + count + "'>#description#</textarea></cfoutput>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Resolution: " +
-
"</td>" +
-
"<td class='resolutionmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br>" +
-
"<cfoutput query='serial'><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)' rows='4' cols='60' name='resolution_" + count + "'>#resolution#</textarea></cfoutput>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoldatetab' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Resolution Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td>" +
-
"<cfoutput query='serial'><input type='text' name='resdate_" + count + "' value='#resolution_date#'> </cfoutput>" +
-
-
" Current Date: " +
-
"<input type='checkbox' name='currentdateresol_" + count + "' onClick=resdate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"<td>" +
-
"Resolution Verified as effective by: " +
-
"</td>" +
-
"<td>" +
-
"<select name='resvertified_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='gettech'>" +
-
"<option value='#fname# #lname#'<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Extra fields for Vertification Date, Current Date (for vertification date) --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Verification Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td class='vertificationmoveinmulti'>" +
-
"<cfoutput query='serial'><input type='text' name='vertifidate_" + count + "' value='#verification_date#'> </cfoutput>" +
-
" Current Date: " +
-
"<input type='checkbox' name='currentdatevert_" + count + "' onClick=vertifidate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Dept/Vendor Responsibility --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td class='red' id='paddingformultitop'>" +
-
"Dept/Vendor Responsibility*: " +
-
"<select name='deptvendor_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getDeptVendor'>" +
-
"<option value='#pk_deptVendor#'<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"RMA Data Only: " +
-
"</td>" +
-
"<td class='rmanmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br/>" +
-
"<cfoutput query='serial'><textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)' rows='4' cols='60' name='rma_" + count + "' >#rma_data#</textarea></cfoutput> " +
-
"</td>" +
-
"</tr>" +
-
"</table>" +
-
"<input type='hidden' name='serialcount' value='" + count + "'>";
-
-
<!--- Adds Delete to every ticket --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='removeticket' value='Remove Serial ""+count +""' onclick=\"removeElement(\'"+divIdName+"\')\"></a>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table><br>";
-
-
document.getElementById(divName).appendChild(newdiv);
-
-
}
-
-
-
-
-
-
<!---Allows us to add serial information multiple times --->
-
function addInput(divName){
-
var dynamic = document.getElementById('dynamicInput');
-
var thevalue = document.getElementById('theValue');
-
var count = (document.getElementById('theValue').value -1)+ 2;
-
thevalue.value = count;
-
var newdiv = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
newdiv.setAttribute('id',divIdName);
-
-
<!--- Adds Extra fields for Model No, Product Type, and Type of Hardware Failure --->
-
newdiv.innerHTML =
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>Model No: </td>" +
-
"</td>" +
-
"<td>" +
-
"<select name='modelno_" + count + "' >" +
-
"<option value=''>Make A Selection</option>" +
-
"<cfoutput query='models'>" +
-
"<option value='#model#'>#model#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td>" +
-
" Product Type:" +
-
"</td>" +
-
"<td>" +
-
"<select name='producttype_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getProdType'>" +
-
"<option value='#pk_productType#'>#pk_productType#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"<td class='red'>" +
-
" Type Of Hardware Failure*:" +
-
"</td>" +
-
"<td>" +
-
"<select name='hardwarefailure_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getHardwareFail'>" +
-
"<option value='#pk_hardwareFailure#'>#pk_hardwareFailure#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"<table>";
-
-
<!--- Adds Extra fields for Serial Number and Software/Hardware --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Serial Number: " +
-
"<input type='text' name='serialnum_" + count + "'>" +
-
" Software/Hardware: " +
-
"<select name='softhardware_" + count + "'>" +
-
"<option value='' selected>No Choice</option>" +
-
"<cfoutput query='getSoftHard'>" +
-
"<option value='#pk_softwareHardware#'>#pk_softwareHardware#</option>" +
-
"</cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Description --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='3' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Description: " +
-
"</td>" +
-
"<td class='descriptionmoveinmulti'>" +
-
"( You may enter up to 500 characters. )"+
-
"<br>" +
-
"<textarea maxlength='500' onkeyup='return ismaxlength(this)' onkeydown='return ismaxlength(this)'rows='4' cols='60' name='thedescription_" + count + "'></textarea>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformutli'>" +
-
"Resolution: " +
-
"</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 + "'></textarea>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoldatetab' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Resolution Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td>" +
-
"<input type='text' name='resdate_" + count + "' value='' > " +
-
-
" Current Date: " +
-
"<input type='checkbox' name='currentdateresol_" + count + "' onClick=resdate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"<td>" +
-
-
"Resolution Verified as effective by: " +
-
"</td>" +
-
"<td>" +
-
"<select name='resvertified_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='gettech'><option value='#fname# #lname#'>#fname# #lname#</option></cfoutput></select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Vertification Date, Current Date (for vertification date) and resolution vertified as effective by --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"Verification Date: (MM/DD/YYYY) " +
-
"</td>" +
-
"<td class='vertificationmoveinmulti'>" +
-
"<input type='text' name='vertifidate_" + count + "'> " +
-
" Current Date: " +
-
"<input type='checkbox' name='currentdatevert_" + count + "' onClick=vertifidate_" + count + ".value=fill_date()>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for Dept/Vendor Responsibility --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td class='red' id='paddingformultitop'>" +
-
"Dept/Vendor Responsibility*: " +
-
"<select name='deptvendor_" + count + "'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getDeptVendor'>" +
-
"<option value='#pk_deptVendor#'>#pk_deptVendor#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td id='paddingformultitop'>" +
-
"RMA Data Only: " +
-
"</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 + "'></textarea> " +
-
"</td>" +
-
"</tr>" +
-
"</table>" +
-
"<input type='hidden' name='serialcount' value='" + count + "'>";
-
-
<!--- Adds Delete to every ticket --->
-
newdiv.innerHTML = newdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='removeticket' value='Remove Serial ""+count +""' onclick=\"removeElement(\'"+divIdName+"\')\"></a>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
document.getElementById(divName).appendChild(newdiv);
-
}
-
-
-
<!---Allows us to remove multiple fields --->
-
function removeElement(divNum) {
-
var d = document.getElementById('dynamicInput');
-
var olddiv = document.getElementById(divNum);
-
d.removeChild(olddiv);
-
}
-
-
</script>
-
<body onload="showInput('dynamicInput');">
-
<!--- Ticket Information
-
This display the ticket Information--->
-
-
-
-
-
<input type="hidden" value="0" id="theValue" />
-
<div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
<!--- Adds Extra fields for Model No, Product Type, and Type of Hardware Failure --->
-
-
-
<table class="zpExpandedTable" id="modeltable">
-
<th class="sectiontitletick" colspan="7">Serial Information '+ count +' </th>
-
<tr>
-
<td id="paddingformultitop">Model No: </td>
-
</td>
-
<td>
-
<select name="modelno_' + count + '">
-
<option value="">Make A Selection</option>
-
<cfoutput query="models">
-
<option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
-
</cfoutput>
-
</select>
-
</td>
-
<td>
-
Product Type:
-
</td>
-
<td>
-
<select name="producttype_' + count + '">
-
<option value="" selected>No Choice</option>
-
<cfoutput query="getProdType">
-
<option value="#pk_productType#"<cfif #pk_productType# is #product_type#>selected</cfif>>#pk_productType#</option>
-
</cfoutput>
-
</select>
-
</td>
-
<td class="red'">
-
Type Of Hardware Failure*:
-
</td>
-
<td>
-
<select name="hardwarefailure_' + count + '">
-
<option value="" selected>Make A Selection</option>
-
<cfoutput query="getHardwareFail">
-
<option value="#pk_hardwareFailure#"<cfif #pk_hardwareFailure# is #type_hardware_failure#>selected</cfif>>#pk_hardwareFailure#</option>
-
</cfoutput>
-
</select>
-
</td>
-
</tr>
-
<table>
-
-
<!--- Adds Extra fields for Serial Number and Software/Hardware --->
-
<table class="zpExpandedTable" id="modeltable">
-
<tr>
-
<td id="paddingformultitop">
-
Serial Number:
-
<cfoutput query="serial"><input type="text" name="serialnum_' + count + '" value="#pka_serialNo#"></cfoutput>
-
Software/Hardware:
-
<select name="softhardware_' + count + '">
-
<option value="" selected>No Choice</option>
-
<cfoutput query="getSoftHard">
-
<option value="#pk_softwareHardware#"<cfif #pk_softwareHardware# is #software_hardware#>selected</cfif>>#pk_softwareHardware#</option>
-
</cfoutput>
-
</select>
-
</td>
-
</tr>
-
</table>
-
-
<!--- Adds Extra fields for Description --->
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
( You may enter up to 500 characters. )
-
<br>
-
<cfoutput query="description"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="thedescription_' + count + '">#description#</textarea></cfoutput>
-
</td>
-
</tr>
-
</table>
-
-
<!--- Adds Extra fields for Resolution --->
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td id="paddingformutli">
-
Resolution:
-
</td>
-
<td class="resolutionmoveinmulti">
-
( You may enter up to 500 characters. )
-
<br>
-
<cfoutput query="serial"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="resolution_' + count + '">#resolution#</textarea></cfoutput>
-
</td>
-
</tr>
-
</table>
-
-
<!--- Adds Extra fields 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: (MM/DD/YYYY)
-
</td>
-
<td>
-
<cfoutput query="serial"><input type="text" name="resdate_' + count + '" value="#resolution_date#"> </cfoutput>
-
-
Current Date:
-
<input type="checkbox" name="currentdateresol_' + count + '" onClick=resdate_" + count + ".value=fill_date()>
-
</td>
-
<td>
-
Resolution Verified as effective by:
-
</td>
-
<td>
-
<select name="resvertified_' + count + '">
-
<option value="" selected>Make A Selection</option>
-
<cfoutput query="gettech">
-
<option value="#fname# #lname#"<cfif "#fname# #lname#" is #resolution_verified_by#>selected</cfif>>#fname# #lname#</option>
-
</cfoutput>
-
</select>
-
</td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Extra fields for Vertification Date, Current Date (for vertification date) --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td id="paddingformultitop">
-
Verification Date: (MM/DD/YYYY)
-
</td>
-
<td class="vertificationmoveinmulti">
-
<cfoutput query="serial"><input type="text" name="vertifidate_' + count + '" value="#verification_date#"> </cfoutput>
-
Current Date:
-
<input type="checkbox" name="currentdatevert_' + count + '" onClick=vertifidate_" + count + ".value=fill_date()>
-
</td>
-
</tr>
-
</table>
-
-
<!--- Adds Extra fields for Dept/Vendor Responsibility --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td class="red" id="paddingformultitop">
-
Dept/Vendor Responsibility*:
-
<select name="deptvendor_' + count + '">
-
<option value="" selected>Make A Selection</option>
-
<cfoutput query="getDeptVendor">
-
<option value="#pk_deptVendor#"<cfif #pk_deptVendor# is #dept_responsibility#>selected</cfif>>#pk_deptVendor#</option>
-
</cfoutput>
-
</select>
-
</td>
-
</tr>
-
</table>
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td id="paddingformultitop">
-
RMA Data Only:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 500 characters. )
-
<br/>
-
<cfoutput query="serial"><textarea maxlength="500" onkeyup="return ismaxlength(this)" onkeydown="return ismaxlength(this)" rows="4" cols="60" name="rma_' + count + '" >#rma_data#</textarea></cfoutput>
-
</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 "'+count +'"" onclick=\"removeElement(\'"+divIdName+"\')\"></a>
-
</td>
-
</td>
-
</tr>
-
</table>
-
-
-
-
-
-
</div>
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
Thank you,
Rach
acoder 16,027
Recognized Expert Moderator MVP
Yes, there's no need for the showInput function any more. For example, you can replace: - newdiv.innerHTML =
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
-
"<tr>" +
with - <div ...>
-
<cfoutput query="...">
-
<table class='zpExpandedTable' id='modeltable'>
-
<th class='sectiontitletick' colspan='7'>Serial Information #count# </th>
-
<tr>
Yes, there's no need for the showInput function any more. For example, you can replace:
- newdiv.innerHTML =
-
"<table class='zpExpandedTable' id='modeltable'>" +
-
"<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
-
"<tr>" +
with
- <div ...>
-
<cfoutput query="...">
-
<table class='zpExpandedTable' id='modeltable'>
-
<th class='sectiontitletick' colspan='7'>Serial Information #count# </th>
-
<tr>
Hey Acoder,
Well i am having trouble doing the #count# part you did in your example i just get an error. An i am having trouble with my current date stuff. Basically from that point on it wont show any of the other parts in the table unless i take it out. Bolded the parts having trouble with
Thank you again for all the help :),
Rach
acoder 16,027
Recognized Expert Moderator MVP
That was only an example. #count# you'd have to set in your Coldfusion, e.g. on each loop iteration increase #count# by 1.
That was only an example. #count# you'd have to set in your Coldfusion, e.g. on each loop iteration increase #count# by 1.
Hey Acoder,
But how would i apply the cfloop to this? the reason i ask is because theres so many different cfoutput cfquery for the drop down boxes in the whole form that i can't just put a cfloop around the whole thing so just wondering how i could apply that.
Thank you :),
Rach
acoder 16,027
Recognized Expert Moderator MVP
You could use cfloop instead of cfoutput for the inner queries
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Charles Alexander |
last post by:
Hello
I am new to php & MySQL - I am trying to retrieve some records from a MySQL
table and redisplay them. The data in list form looks like this:
Sample_ID Marker_ID Variation
G23_NA17192.fsa rs7374540 A/C
I23_Control.fsa rs7374540 C/C
|
by: Ravi |
last post by:
Hi All,
I am trying to execute a select statement using the DBI module
of perl in a for loop. I am getting a strange behaviour, the select
statement is excuting correctly only for the last element in the for
loop.
I am including the portion of the code :
#Get the connection to the database
my $dbh = &getConnection();
my @acodes;
|
by: Gremlin |
last post by:
If you are not familiar with the halting problem, I will not go into
it in detail but it states that it is impossible to write a program
that can tell if a loop is infinite or not. This is a fallacy built
on the assumption of mythical infinite all powerfull machines. In
reality we deal with finite machines that are capable of two states in
a loop, they either terminate, or repeat themselves. In the mythical
halting problem scenario...
|
by: Roman Töngi |
last post by:
for (int i = 1; i <= 10; i++)
cout << i << endl;
I expected the following:
1
2
3
4
5
6
|
by: Alex |
last post by:
Compiler - Borland C++ 5.6.4 for Win32 Copyright (c) 1993, 2002 Borland
Linker - Turbo Incremental Link 5.65 Copyright (c) 1997-2002 Borland
Platform - Win32 (XP)
Quite by accident I stumbled across some wierd loop behavior. With the
pasted code I receive the output that follows.
I realize that the code is broken, because the inner loop fails to reset
j for each iteration of the outer loop (the fix is commented out). I
also know that...
| | |
by: Aaron Ackerman |
last post by:
What is the sytax for exiting a for loop in C#?
|
by: John Pass |
last post by:
What is the difference between a While and Do While/Loop repetition structure.
If they is no difference (as it seems) why do both exist?
|
by: Claudio Grondi |
last post by:
Sometimes it is known in advance, that the time spent in a loop will be
in order of minutes or even hours, so it makes sense to optimize each
element in the loop to make it run faster.
One of instructions which can sure be optimized away is the check for
the break condition, at least within the time where it is known that the
loop will not reach it.
Any idea how to write such a loop?
e.g.
|
by: ADezii |
last post by:
If you are executing a code segment for a fixed number of iterations, always use a For...Next Loop instead of a Do...Loop, since it is significantly faster. Each pass through a Do...Loop that iterates a specified number of times, requires you to also implement or decrement some sort of Loop Counter, while a For...Next Loop does that work for you. Both Loops will provide the same results, but the For...Next Loop is substantially faster. One...
|
by: numlock00 |
last post by:
I have a nested 'while' loop that won't repeat, no matter how many times the outer loop repeats. The outer loop reads through an array of elements; the inner loop Ithe 'while' loop) is supposed to apply each of these elements while reading an input file.
The outer loop is working fine. It will run through every element of the array. The inner loop, however, only runs once. Even though the outer loop finishes inormally, the inner loop does not...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
