Hey Everyone,
Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place.
what i am trying to display previously entered multiple fields. I am able to get my serial fields to display correctly, but i can not display my parts fields correctly.
Currently this is what it does
serial information 1
parts 1
parts 2
serial information 2
parts 1
parts 2
and what it needs to do
serial information 1
parts 1
serial information 2
parts 1
the problem is instead of the part going with the correct serial. it basically puts the information for both parts i added under both of the 2 serials I am also having trouble deleting fields an adding fields for the parts fields.
if someone could explain what i am doing wrong with the parts i would really appreciate it. I know it has to do with the count, just not sure what i am doing wrong
here is the javascript for serial and parts that allows me to add serials and parts
here is the html/coldfusion that displays what was previously entered for serials and parts.
Thank you in advance,
Rach
Oct 16 '08
482  27225 
Hey Acoder,
Here is what i got in full would this be correct?
but what i am confused on is how would i do the parts? i got serial working but parts i don't. would i just start another cfif below the serial like i have below or how we had done it before ? -
<cfoutput query="parts">
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<!---<cfinclude template="serialpartsdisplaytest.cfm">--->
-
</cfoutput>
-
<cfif parts.recordcount is 0>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<!---<cfinclude template="serialpartsdisplaytest.cfm">--->
-
</cfif>
-
-
-
Thank you,
Rach
The template should only contain the table for display. Things like setting of variables and counts, etc. should be in the main page, so that the template can be reused. This may seem like overkill now, but will save you a headache later when you have to change something.
For parts, yes, you could use a template if you're going to display an empty part table when there are no parts.
Hey Acoder,
Everything that i displayed in #401 (or above) is on the main page. Including the cfset. The only thing that is on the template is the following - <!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
-
-
<!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure --->
-
<cfset count = 1>
-
<cfoutput>
-
<div id="dynamic#count#Input">
-
<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>
-
<cfloop query="models">
-
<option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
-
</cfloop>
-
</select></td>
-
<td>
-
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">
-
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:
-
<input type="text" name="serialnum_#count#" value="#pka_serialNo#">
-
Software/Hardware:
-
<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 --->
-
-
<cfquery name="getnotes" dbtype="query" >
-
SELECT *
-
FROM notes
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfloop query="getnotes">
-
-
<input type="hidden" name="pk_num_#count#" id="pk_num" value="" /></cfloop>
-
<!---<div style="width: 150px; height: 150px; overflow-y: scroll; scrollbar-arrow-color:blue;
-
scrollbar-face-color: #e7e7e7; scrollbar-3dlight-color: #a0a0a0; scrollbar-darkshadow-color:#888888;">--->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr><td id="paddingformutli">
-
Previously Submitted Descriptions:</td><td id="paddingformutli">
-
<div id="descriptionbox" style="HEIGHT:100px; WIDTH:500px; OVERFLOW:auto;" >
-
<cfloop query="getnotes">
-
Added By: #fk_addedBy# <br/>
-
Dated Added: #DateFormat(date_stamp,'mm/dd/yyyy')#<br/><br/>
-
#description#
-
<div id="line"></div>
-
</cfloop></div></td>
-
-
</tr>
-
</table>
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<!---<input type="hidden" name="thedescriptoin_#count#" id="thedescriptoin" value="#description#" />--->
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
-
( You may enter up to 1000 characters. )
-
<br>
-
<textarea maxlength='1000' onkeyup='return descriptionmaxlength(this)' onkeydown='return descriptionmaxlength(this)'rows='4' cols='60' name="thedescription_#count#"></textarea>
-
-
</td>
-
</tr>
-
</table>
-
<!---Shows what was previously entered 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 1500 characters. )
-
<br>
-
<textarea maxlength="1500" onkeyup="return resolutionismaxlength(this)" onkeydown="return resolutionismaxlength(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: (MM/DD/YYYY)
-
</td>
-
<td>
-
<input type="text" name="resdate_#count#" value="#DateFormat(resolution_date,'mm/dd/yyyy')#">
-
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>
-
<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: (MM/DD/YYYY)
-
</td>
-
<td class="vertificationmoveinmulti">
-
<input type="text" name="vertifidate_#count#" value="#DateFormat(verification_date,'mm/dd/yyyy')#">
-
Current Date:
-
<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*:
-
<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>
-
<input type="hidden" name="serialcount" id="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('dynamic#count#Input')">
-
</td>
-
</tr>
-
<tr>
-
<td>
-
<input type="button" class="addticket" value="Add Parts" onClick="addpartInput('dynamic#count#Input')">
-
</td>
-
</tr>
-
</table>
-
-
-
<!---Shows what was previously entered into parts table--->
-
<!---dbtype="query"--->
-
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<div id="part#count1#Name#count#">
-
<!---<cfset partliststr = "">
-
<cfloop from="1" to="#count1#" index="pl">
-
<cfset partliststr = partliststr & #pl# & ",">
-
</cfloop>
-
-
<input type="hidden" name="part2count#count#" id="part2count#count#" value="#partliststr#">
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">--->
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<th class="sectiontitle" colspan="7">Parts Information #count1# Serial Information #count#</th>
-
<tr>
-
<td class='indent' id='formfieldpadding'>HC P/N: <input type='text' name="hcpn_#count1#_#count#" style="margin:0px" value="#hc_partNo#"></td>
-
<td>
-
Parts been returned*
-
<input type="checkbox" name="partsreturn_#count1#_#count#" value="#part_returned#"<cfif #part_returned# eq "1">checked=yes</cfif>/>
-
</td>
-
<td>
-
<td class="indent">Defective<input type="checkbox" name="defective_#count1#_#count#" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
-
</td>
-
</tr>
-
</table>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count#">--->
-
-
-
<!--- 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:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 1000 characters. )
-
<br/>
-
<textarea maxlength="1000" onkeyup="return rmaismaxlength(this)" onkeydown="return rmaismaxlength(this)" rows="4" cols="60" name="rma_#count1#_#count#" >#rma_number#</textarea></td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Delete to every ticket --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td>
-
<input type="button" class="removeticket" value="Remove Parts #count1#"
-
onclick="removetheElement('part#count1#Name#count#',#count#,#count#)"></a>
-
</td>
-
</td>
-
</tr>
-
</table>
-
</div>
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>
-
</cfloop>
-
</div>
-
<!---this one makes it so you can add a part to a previously submitted serial--->
-
<input type="hidden" name="partcounter#count#" id="partcounter#count#" value="#count1#" />
-
</cfoutput>
but with the parts, your saying to create another template for it right? i tried already to make a separate template for just parts an i ran into lots of trouble with it, it wouldn't count right, it wouldn't show up at some points, an sometimes i couldn't add parts. Is there a way i could use the same template since parts is already inbetween on the serialpartsdisplay.cfm template?
Thank you,
Rach
OK, I actually meant the div "dynamic#count#input" and all its contents should be in the template. The rest should be outside.
You have the serials working with the template, so we can work on that first and worry about parts later.
Hey Acoder,
Your saying to take the dynamiccount, put it in the template an then what about the main page? do i need to take dynamiccount and everything between it out of the main page?
Thank you,
Rach
Yes, that would be the idea, but of course, backup first so you can go back if things don't go quite as planned.
Hey Acoder,
Alright here is what i have on the main page in full. It is counting correctly for both serials that already had serials and ones that did not have serials. An there both counting correct when i add serials to both. But i can still not get parts to come up if a serial was not added. When i add parts it adds parts correctly it is just not showing the parts table if a part was not filled out. - <div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<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#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset description = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfif>
-
-
<!--- <cfoutput query="parts">
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>--->
-
<cfif getparts.recordcount is 0>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<!---<cfinclude template="serialpartsdisplay.cfm">--->
-
</cfif>
-
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
</div>
-
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
-
an here is what i have on the template page - <!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
-
-
<!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure --->
-
<cfoutput>
-
<div id="dynamic#count#Input">
-
<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>
-
<cfloop query="models">
-
<option value="#model#"<cfif #model# is #model_no#>selected</cfif>>#model#</option>
-
</cfloop>
-
</select></td>
-
<td>
-
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">
-
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:
-
<input type="text" name="serialnum_#count#" value="#pka_serialNo#">
-
Software/Hardware:
-
<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 --->
-
-
<cfquery name="getnotes" dbtype="query" >
-
SELECT *
-
FROM notes
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfloop query="getnotes">
-
-
<input type="hidden" name="pk_num_#count#" id="pk_num" value="" /></cfloop>
-
<!---<div style="width: 150px; height: 150px; overflow-y: scroll; scrollbar-arrow-color:blue;
-
scrollbar-face-color: #e7e7e7; scrollbar-3dlight-color: #a0a0a0; scrollbar-darkshadow-color:#888888;">--->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr><td id="paddingformutli">
-
Previously Submitted Descriptions:</td><td id="paddingformutli">
-
<div id="descriptionbox" style="HEIGHT:100px; WIDTH:500px; OVERFLOW:auto;" >
-
<cfloop query="getnotes">
-
Added By: #fk_addedBy# <br/>
-
Dated Added: #DateFormat(date_stamp,'mm/dd/yyyy')#<br/><br/>
-
#description#
-
<div id="line"></div>
-
</cfloop></div></td>
-
-
</tr>
-
</table>
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<!---<input type="hidden" name="thedescriptoin_#count#" id="thedescriptoin" value="#description#" />--->
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
-
( You may enter up to 1000 characters. )
-
<br>
-
<textarea maxlength='1000' onkeyup='return descriptionmaxlength(this)' onkeydown='return descriptionmaxlength(this)'rows='4' cols='60' name="thedescription_#count#"></textarea>
-
-
</td>
-
</tr>
-
</table>
-
<!---Shows what was previously entered 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 1500 characters. )
-
<br>
-
<textarea maxlength="1500" onkeyup="return resolutionismaxlength(this)" onkeydown="return resolutionismaxlength(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: (MM/DD/YYYY)
-
</td>
-
<td>
-
<input type="text" name="resdate_#count#" value="#DateFormat(resolution_date,'mm/dd/yyyy')#">
-
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>
-
<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: (MM/DD/YYYY)
-
</td>
-
<td class="vertificationmoveinmulti">
-
<input type="text" name="vertifidate_#count#" value="#DateFormat(verification_date,'mm/dd/yyyy')#">
-
Current Date:
-
<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*:
-
<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>
-
<input type="hidden" name="serialcount" id="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('dynamic#count#Input')">
-
</td>
-
</tr>
-
<tr>
-
<td>
-
<input type="button" class="addticket" value="Add Parts" onClick="addpartInput('dynamic#count#Input')">
-
</td>
-
</tr>
-
</table>
-
-
-
<!---Shows what was previously entered into parts table--->
-
<!---dbtype="query"--->
-
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<div id="part#count1#Name#count#">
-
<!---<cfset partliststr = "">
-
<cfloop from="1" to="#count1#" index="pl">
-
<cfset partliststr = partliststr & #pl# & ",">
-
</cfloop>
-
-
<input type="hidden" name="part2count#count#" id="part2count#count#" value="#partliststr#">
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">--->
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<th class="sectiontitle" colspan="7">Parts Information #count1# Serial Information #count#</th>
-
<tr>
-
<td class='indent' id='formfieldpadding'>HC P/N: <input type='text' name="hcpn_#count1#_#count#" style="margin:0px" value="#hc_partNo#"></td>
-
<td>
-
Parts been returned*
-
<input type="checkbox" name="partsreturn_#count1#_#count#" value="#part_returned#"<cfif #part_returned# eq "1">checked=yes</cfif>/>
-
</td>
-
<td>
-
<td class="indent">Defective<input type="checkbox" name="defective_#count1#_#count#" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
-
</td>
-
</tr>
-
</table>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count#">--->
-
-
-
<!--- 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:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 1000 characters. )
-
<br/>
-
<textarea maxlength="1000" onkeyup="return rmaismaxlength(this)" onkeydown="return rmaismaxlength(this)" rows="4" cols="60" name="rma_#count1#_#count#" >#rma_number#</textarea></td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Delete to every ticket --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td>
-
<input type="button" class="removeticket" value="Remove Parts #count1#"
-
onclick="removetheElement('part#count1#Name#count#',#count#,#count#)"></a>
-
</td>
-
</td>
-
</tr>
-
</table>
-
</div>
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>
-
</cfloop>
-
</div>
-
<!---this one makes it so you can add a part to a previously submitted serial--->
-
<input type="hidden" name="partcounter#count#" id="partcounter#count#" value="#count1#" />
-
</cfoutput>
Thank you,
Rach
That's good except that the cfoutput should be outside the template (in the cfif serial record count check where the template is called the second time).
For the parts, create another template with the parts div (div#count1#Name#count#) with counts and fields, etc. in the serial template.
You shouldn't need the parts in two places. If it's in the serial template (where it should be), it's not needed on the main page.
For the serials, the cfoutput loop should be complete before the cfif. Then in the cfif record count tag, put cfoutput tags.
Hey Acoder,
So your saying something like this correct? - <cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<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#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
<cfoutput>
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset description = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfif>
-
</cfoutput>
an well parts comes up if i added a part in a previous serial. But if i didn't add a serial, the empty serial table comes up but the empty parts table is still not coming up. Any ideas?
Thank you,
Rach
Almost - move the cfoutput tags on lines 12 and 28 to just around the template on line 26.
For the parts, you need to add a cfif similar to serials which checks the record count of the getparts query and includes parts.cfm a second time.
Hey Acoder,
So would this be correct for serial and parts? - <cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<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#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset description = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfoutput><cfinclude template="serialpartsdisplay.cfm"></cfoutput>
-
</cfif>
-
-
<cfset count1 = 0>
-
<cfoutput query="parts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="parts.cfm">
-
</cfoutput>
-
<cfif parts.recordcount is 0>
-
<cfset count = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfoutput><cfinclude template="parts.cfm"></cfoutput>
-
</cfif>
Thank you,
Rach
Yes, except that the parts code should be in the serial template (where you want the parts to appear).
Hey Acoder ,
would something like this work? - <cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<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#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
<cfset count1 = 0>
-
<cfoutput query="parts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="parts.cfm">
-
</cfoutput>
-
-
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset description = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfoutput><cfinclude template="serialpartsdisplay.cfm"></cfoutput>
-
</cfif>
-
<cfif parts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfoutput><cfinclude template="parts.cfm"></cfoutput>
-
</cfif>
Thank you,
Rach
Not quite. The parts code from lines 12-20 and 40-47 would go inside serialpartsdisplay.cfm, probably at the end of it.
Hey Acoder,
I tried putting it at the end an it didn't work. An i tried putting it in the following place below an it had a fit about the cfoutput. any ideas on where to put it? -
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
-
Tried to put it here
-
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>
-
</cfloop>
here is what i have on the serialpartsdisplay.cfm.
Thank you,
Rach
Since this would be inside a cfoutput query, change the cfoutput in parts to cfloop.
Hey Acoder,
I tried the following but it still didn't work.i changed the last cftemplate from cfoutput to cfloop because it has having problems being inside another cfoutput. But the thing is the parts section does not come up. Any ideas? - <cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<!---The template is where most of the parts section is held--->
-
<!---<cfinclude template="partsdisplay.cfm">--->
-
<cfset count1 = 0>
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfloop>
-
<cfif getparts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfloop query="getparts"><cfinclude template="partsdisplay.cfm"></cfloop>
-
</cfif>
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>
-
</cfloop>
Thank you,
Rach
You don't need the cfloop tag on line 9 and the cfset on line 10. Neither do you need the ending cfloop on line 31. You also don't need the cfloop tags on line 28. On line 30, the input hidden field will probably be in the partsdisplay.cfm template, so you can remove that line too.
Hey Acoder,
I don't have the hidden input field in the partsdisplay.cfm page because it comes after the parts div. Should i add it to partsdisplay.cfm? i tried the following below but it didn't work. Didn't tell me the pacific problem just didn't work. An i tried moving the hidden field from the serialpartsdisplay.cfm to partsdisplay.cfm an that didn't seem to make a difference no matter where it was.
here is what i got in full on serialpartsdisplay.cfm page is this correct? -
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfloop>
-
<cfif getparts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfinclude template="partsdisplay.cfm">
-
</cfif>
Thank you,
Rach
What have you got in partsdisplay.cfm now? Were you not using parts.cfm earlier?
Hey Acoder,
i changed the file name from parts.cfm to partsdisplay.cfm just so i would understand better what it does. But here is what i got in partsdisplay.cfm now. -
<cfoutput>
-
<div id="part#count1#Name#count#">
-
<!---<cfset partliststr = "">
-
<cfloop from="1" to="#count1#" index="pl">
-
<cfset partliststr = partliststr & #pl# & ",">
-
</cfloop>
-
-
<input type="hidden" name="part2count#count#" id="part2count#count#" value="#partliststr#">
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">--->
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<th class="sectiontitle" colspan="7">Parts Information #count1# Serial Information #count#</th>
-
<tr>
-
<td class='indent' id='formfieldpadding'>HC P/N: <input type='text' name="hcpn_#count1#_#count#" style="margin:0px" value="#hc_partNo#"></td>
-
<td>
-
Parts been returned*
-
<input type="checkbox" name="partsreturn_#count1#_#count#" value="#part_returned#"<cfif #part_returned# eq "1">checked=yes</cfif>/>
-
</td>
-
<td>
-
<td class="indent">Defective<input type="checkbox" name="defective_#count1#_#count#" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
-
</td>
-
</tr>
-
</table>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count#">--->
-
-
-
<!--- 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:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 1000 characters. )
-
<br/>
-
<textarea maxlength="1000" onkeyup="return rmaismaxlength(this)" onkeydown="return rmaismaxlength(this)" rows="4" cols="60" name="rma_#count1#_#count#" >#rma_number#</textarea></td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Delete to every ticket --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td>
-
<input type="button" class="removeticket" value="Remove Parts #count1#"
-
onclick="removetheElement('part#count1#Name#count#',#count#,#count#)"></a>
-
</td>
-
</td>
-
</tr>
-
</table>
-
</div>
-
-
</cfoutput>
Thank you :),
Rach
You don't need cfoutput in there because it's already contained within cfoutput tags where it's included.
Hey Acoder,
Taking out the cfoutput tags helped an didn't help. The parts section shows up now. But if a part was or was not filled out it does not display what is suppose to be in there it instead just displays the value for the field an for the count, it displays the value #count# instead of the number.Any ideas?
Thank you,
Rach
What could probably solve all this is to only put cfoutput where it's needed and not around a whole page of code. So remove the cfoutput at the beginning and end of serialpartsdisplay.cfm and put it around each Coldfusion variable not in a Coldfusion tag.
Hey Acoder,
are you meaning to do something like this? because i tried it an it wont allow me to add or remove parts. an also thought of a question. The way we are doing if, if there are serials with no parts applied to it will it add a blank part to them as well instead of just when there is a blank serial?
an if it will is there a way to make a blank parts come up only when a serial is not filled in?
Thank you,
Rach
@bonneylake
What happens? Do you get an error? The general idea is correct, though you could change where you put the cfoutput.
an also thought of a question. The way we are doing if, if there are serials with no parts applied to it will it add a blank part to them as well instead of just when there is a blank serial?
an if it will is there a way to make a blank parts come up only when a serial is not filled in?
Yes, add a check for when serial count is 0 too when displaying a blank part.
Hey Acoder,
Well i discovered something weird today. I had original made a copy of serialpartsdisplay.cfm to apply the new idea we had where we wrapped each seperate section in cfoutput. Anyway when i went to look this morning with the old serialpartdisplay.cfm I clicked on add part an it seemed to be counting right except for the first part displayed. So i I ended up wrapping only the required sections in parts and that seemed to work some what. however, for some reason i can not wrap the following 2 things in cfoutput or i get errors and i am not able to delete the first part. - <div id="part#count1#Name#count#">
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
this is what i tried in full on the partsdisplay.cfm page - <div id="part#count1#Name#count#">
-
<!---<cfset partliststr = "">
-
<cfloop from="1" to="#count1#" index="pl">
-
<cfset partliststr = partliststr & #pl# & ",">
-
</cfloop>
-
-
<input type="hidden" name="part2count#count#" id="part2count#count#" value="#partliststr#">
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">--->
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<th class="sectiontitle" colspan="7"><cfoutput>Parts Information #count1# Serial Information #count#</cfoutput></th>
-
<tr>
-
<td class='indent' id='formfieldpadding'>HC P/N: <cfoutput><input type='text' name="hcpn_#count1#_#count#" style="margin:0px" value="#hc_partNo#"></cfoutput></td>
-
<td>
-
Parts been returned*
-
<cfoutput><input type="checkbox" name="partsreturn_#count1#_#count#" value="#part_returned#"<cfif #part_returned# eq "1">checked=yes</cfif>/></cfoutput>
-
</td>
-
<td>
-
<td class="indent">Defective<cfoutput><input type="checkbox" name="defective_#count1#_#count#" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></cfoutput></td>
-
</td>
-
</tr>
-
</table>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count#">--->
-
-
-
<!--- 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:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 1000 characters. )
-
<br/>
-
<cfoutput>
-
<textarea maxlength="1000" onkeyup="return rmaismaxlength(this)" onkeydown="return rmaismaxlength(this)" rows="4" cols="60" name="rma_#count1#_#count#" >#rma_number#</textarea></cfoutput></td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Delete to every ticket --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td>
-
<cfoutput>
-
<input type="button" class="removeticket" value="Remove Parts #count1#"
-
onclick="removetheElement('part#count1#Name#count#',#count#,#count#)"></a></cfoutput>
-
</td>
-
</td>
-
</tr>
-
</table>
-
-
</div>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>--->
an how would i add a check for the serial count is 0?because i got on cticketpage2edit.cfm the following an it does the serial is 0 but i don't know how to make it where if a serial is empty is only when a part will appear. - <cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset pka_serialNo = #pka_serialNo#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution = #resolution#>
-
<cfset resolution_date = #resolution_date#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset verification_date = #verification_date#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfoutput><cfinclude template="serialpartsdisplay.cfm"></cfoutput>
-
</cfif>
-
Thank you,
Rach
Have you got the partsdisplay.cfm include file wrapped in cfoutput in serialpartsdisplay.cfm?
For the serial count, when checking parts count just add a check for serial count too, e.g. - <cfif serial.recordcount is 0 and parts.recordcount is 0>
Hey Acoder,
The checking parts count worked beautiful. But i can still not get the parts. I have the
parts wrapped as below - <cfoutput query="getparts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfoutput>
-
<cfif serial.recordcount is 0 and getparts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfoutput><cfinclude template="partsdisplay.cfm"></cfoutput>
-
</cfif>
-
an then inside the partsdisplay.cfm is in post 429.The problem is witht he div in partsdisplay.cfm. When i go an look using firebug it is not counting or doing anything. If i wrap the div itself in cfoutput it does not work an i get an error. Could it be possible that if i took the beginning div an the end div an put it in serialpartsdisplay.cfm but leave everything between the div on partsdisplay.cfm that it might work?
Thank you,
Rach
Hey Acoder,
i got the parts working sorta so ignore post 431. I was able to do the following in partsdisplay.cfm an this allowed me to remove the first part added - <cfoutput><div id="part#count1#Name#count#"></cfoutput>.
However, i am noticing another problems. for some reason if i do not add a part an i go an submit on the print ticket page it shows the following parts information 0 serial 1.. an it does it to every part i add as well. there is always a 0 at the beginning even if i only add part 2 and 4 it will display 0,2,4.
I am also noticing if i add 2 parts to one serial it will only display one part instead of all the parts added.i know its because of the line below. I tried to wrap the whole line in cfoutput but it wouldn't let me -
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
here is what i got on partsdisplay.cfm -
<cfoutput><div id="part#count1#Name#count#"></cfoutput>
-
<!---<cfset partliststr = "">
-
<cfloop from="1" to="#count1#" index="pl">
-
<cfset partliststr = partliststr & #pl# & ",">
-
</cfloop>
-
-
<input type="hidden" name="part2count#count#" id="part2count#count#" value="#partliststr#">
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">--->
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<th class="sectiontitle" colspan="7"><cfoutput>Parts Information #count1# Serial Information #count#</cfoutput></th>
-
<tr>
-
<td class='indent' id='formfieldpadding'>HC P/N: <cfoutput><input type='text' name="hcpn_#count1#_#count#" style="margin:0px" value="#hc_partNo#"></cfoutput></td>
-
<td>
-
Parts been returned*
-
<cfoutput><input type="checkbox" name="partsreturn_#count1#_#count#" value="#part_returned#"<cfif #part_returned# eq "1">checked=yes</cfif>/></cfoutput>
-
</td>
-
<td>
-
<td class="indent">Defective<cfoutput><input type="checkbox" name="defective_#count1#_#count#" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></cfoutput></td>
-
</td>
-
</tr>
-
</table>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count#">--->
-
-
-
<!--- 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:
-
</td>
-
<td class="rmanmoveinmulti">
-
( You may enter up to 1000 characters. )
-
<br/>
-
<cfoutput>
-
<textarea maxlength="1000" onkeyup="return rmaismaxlength(this)" onkeydown="return rmaismaxlength(this)" rows="4" cols="60" name="rma_#count1#_#count#" >#rma_number#</textarea></cfoutput></td>
-
</tr>
-
</table>
-
-
-
<!--- Adds Delete to every ticket --->
-
<table class="zpExpandedTable" id="resoltable" cellpadding="1" cellspacing="0">
-
<tr>
-
<td>
-
<cfoutput>
-
<input type="button" class="removeticket" value="Remove Parts #count1#"
-
onclick="removetheElement('part#count1#Name#count#',#count#,#count#)"></a></cfoutput>
-
</td>
-
</td>
-
</tr>
-
</table>
-
-
</div>
-
<!---<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>--->
-
Thank you,
Rach
You've got cfoutput outside partsdisplay.cfm, so you shouldn't require any cfoutput tags in the file.
Hey Acoder,
I tried to not having any cfoutput tags in partsdisplay.cfm. But when the first part loads (with no serial) it says parts information #count# an it does it for everything else in the file for some reason if i don't have cfoutput tags in there. With it, it does it correct except that one line mentioned above. but other wise for the first part that loads with no serial it wont work correctly.
here is what i got on serialpartsdisplay.cfm for the parts section in it -
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<!---<cfloop query="getparts">
-
<cfset count1 = count1 + 1>--->
-
-
-
-
<!---The template is where most of the parts section is held--->
-
<!---<cfinclude template="partsdisplay.cfm">--->
-
<!---<cfset count1 = 0>--->
-
<cfoutput query="getparts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfoutput>
-
<cfif serial.recordcount is 0 and getparts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfoutput><cfinclude template="partsdisplay.cfm"></cfoutput>
-
</cfif>
-
-
<cfoutput>
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#"/>
-
<!---</cfloop>
-
--->
-
</cfoutput>
Thank you,
Rach
Is serialpartsdisplay.cfm in cfoutput tags? If it is, change the cfoutput query to cfloop and remove the cfoutput tags.
Hey Acoder,
When i did that it now does not display serial at all unless click add button an then the count is messed up here is what i got on serialpartsdisplay.cfm. But i am wondering did i need to change cticketpage2edit.cfm to cflop instead of serialpartsdisplay.cfm?
here is what i got on serialpartsdisplay.cfm
here is what i got on cticketpage2edit.cfm - <div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<!---If there is a serial it will show it (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset pka_serialNo = #pka_serialNo#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution = #resolution#>
-
<cfset resolution_date = #resolution_date#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset verification_date = #verification_date#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfoutput><cfinclude template="serialpartsdisplay.cfm"></cfoutput>
-
</cfif>
-
-
-
-
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
</div>
-
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
Thank you,
Rach
If you look carefully, you'll notice that you have cfoutput within cfoutput. On the edit page, you've put cfoutput tags around serialpartsdisplay include, then within serialpartsdisplay you have the whole content in cfoutput. What I would suggest for an easy solution here is that you remove the cfoutput tags in serialpartsdisplay and change the cfloop query in the edit page to a cfoutput one.
Hey Acoder,
I tried that but it didn't work. All it does is the same problem i am having with parts which it displays #count# instead of the number an it does it for all fields an it does it with or without a serial filled out. The only way i been able to display serials is by having cfoutput in serialpartsdisplay.cfm. Here is what i tried
on cticketpage2edit.cfm - <div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<!---If there is a serial it will show it (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfset count = 0>
-
<cfoutput query="serial">
-
<cfset count = count + 1>
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset pka_serialNo = #pka_serialNo#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution = #resolution#>
-
<cfset resolution_date = #resolution_date#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset verification_date = #verification_date#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfoutput>
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfoutput><cfinclude template="serialpartsdisplay.cfm"></cfoutput>
-
</cfif>
-
-
-
-
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
</div>
-
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
serialpartsdisplay.cfm
Thank you,
Rach
Yes, you're right, it won't work that way.
<cfinclude> won't output variables if the cfoutput is outside. So ignore my previous advice and add cfoutput inside both templates. You can remove it from the edit page unless there's some variables on that page.
Hey Acoder,
So would it be like this for the cticketpage2edit.cfm page? - <div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<!---If there is a serial it will show it (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfset count = 0>
-
<cfloop query="serial"> <cfset count = count + 1>
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset pka_serialNo = #pka_serialNo#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution = #resolution#>
-
<cfset resolution_date = #resolution_date#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset verification_date = #verification_date#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfloop>
-
-
<!--- If fields in the serial was not added it shows the blank field/ or it will show the whole table if no serial was submitted (parts table works the same way). parts is in serialpartsdisplay.cfm--->
-
<cfif serial.recordcount is 0>
-
<cfset count = 1>
-
<cfset model_no = "">
-
<cfset product_type = "">
-
<cfset type_hardware_failure = "">
-
<cfset pka_serialNo = "">
-
<cfset software_hardware = "">
-
<cfset resolution = "">
-
<cfset resolution_date = "">
-
<cfset resolution_verified_by = "">
-
<cfset verification_date = "">
-
<cfset dept_responsibility = "">
-
<cfinclude template="serialpartsdisplay.cfm">
-
</cfif>
-
-
-
-
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
</div>
-
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
an then on serialpartsdisplay.cfm would this work - <cfoutput>
-
around all serials
-
-
<cfquery name="getparts" dbtype="query" >
-
SELECT *
-
FROM parts
-
WHERE fk_serialNo=<cfqueryparam value="#pka_serialNo#"
-
cfsqltype="cf_sql_char" maxLength="20">
-
</cfquery>
-
<cfset count1 = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<!---<cfloop query="getparts">
-
<cfset count1 = count1 + 1>--->
-
-
-
-
<!---The template is where most of the parts section is held--->
-
<!---<cfinclude template="partsdisplay.cfm">--->
-
-
<cfset count1 = 0>
-
<cfloop query="getparts">
-
<cfset count1 = count1 + 1>
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfloop>
-
-
<cfif serial.recordcount is 0 and getparts.recordcount is 0>
-
<cfset count1 = 1>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfinclude template="partsdisplay.cfm">
-
</cfif>
-
</cfoutput>
an then on partsdisplay.cfm all i did was add cfoutput around it all. The parts will work correctly if i filled out a part, except if you have more then one part. If you have more the one part it only displays one part. If you go to add a part to it an submit it, then it deletes the part before it an only show the one you added (for some reason).however, if i don't fill out a part it will not work an i get an error, an thats doing it the way i have explained it. However, i can get the empty part to display (an any part filled in) if i do the following. - <div id="part#count1#Name#count#">
-
-
<input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
<cfoutput>
-
</div>
-
</cfoutput>
but the problem with doing it this way is then the div is not being counted at all.An i know the hidden input line is whats causing it but no clue what to do
Any ideas?
Thank you,
Rach
OK, it seems as if you have a problem with the submit page or getting the right format for it. Since it's been a long thread, it's easy to forget what's been added and changed. What's the error message, and what's required for the adding of parts now?
Hey Acoder,
Well it wont tell me exactly what the problem is, it just says contact administrator. When i look at the full error using the bug it says its with pkpartID, which in the line below. But i know it has to be causing the problem because right now if i do not add a serial or part it brings up an error an it has problems with this line and i get an error and parts don't display. However, if i have a serial and part it does not bring up an error but it will not allow me to have 2 or more parts per serial an i believe this line controlled that. pk_partID makes each part have a unique number (in the table)an keep track of it. So i know this line is important, but it does not seem to act right where it is.I know this line was originally wrapped around the cfloop query="getparts" inside the div. but its not a submission problem because its submitting to the database correct. However, its not displaying right an it has to do with pk_partID - <input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
The only thing i can think of that made the cticketpage2edit.cfm and the serialpartsdisplay.cfm different (the original version we had before making the recent changes ). Was in cticketpage2edit.cfm i had the line pkpartID line, however, in serialpartsdisplay.cfm i didn't have the pkpartID. The pkpartID is only needed if you are displaying previously submitted parts and makes it so each part is unique so recently submitted parts are not deleted an the new ones wont over write the old ones.But i am not sure how to keep the pkpartId to display previously submitted parts an to take it out for parts not added.
Thank you,
Rach
Hey Acoder,
Ok to update from post 443. I have parts displaying now with or without a part added (with no problems). The main problem i am having now is it will only display one part per serial.If i update a ticket an add 2 parts to 1 serial instead of keeping the old one and adding the new one for some reason its deleteing the old one an inserting the new one. I believe the problem is with this - <input type="hidden" name="pkpartID_#count1#_#count#" id="pkpartID" value="#pk_partID#" />
-
the reason is because this makes it so each part is unique and its suppose to where if a user adds another part to a previously submitted part its suppose to say this part is here lets insert another instead of overwritting it or deleteing it.
Thank you,
Rach
Can you post your code for the actual insertion/update on the submit page?
I assume the serial code works absolutely fine?
Hey Acoder,
Yes serials works fine.An i think your right about the parts. I went an retested using the old cticketpage2edit.cfm an it ran into the same problem. But here is what i have on userformedit.cfm - <CFIF REQUEST_METHOD EQ "POST">
-
-
<!---counts how many serials are there--->
-
<cfquery name="countserials" datasource="CustomerSupport">
-
SELECT pka_serialNo from dbo.tbl_CS_serial where pkb_fk_ticketNo=<cfqueryparam value="#Form.pk_ticketID#">
-
</cfquery>
-
<cfset currSerialNo = 1>
-
-
<!--- the array gets serials that have been inserted and updated to avoid deleteing the ones that need to be inserted or updated--->
-
<cfset serialcheck = ArrayNew(1)>
-
<!--- first loop inserts/update serials--->
-
<CFLOOP list="#form.serialcount#" 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 thedescription = Form["thedescription_" & machineCount]>
-
<!---the array checks to see what serials are there--->
-
<CFSET ArrayAppend(serialcheck, "#Form["serialnum_" & machineCount]#")>
-
-
-
<!--- counts how many parts are available--->
-
<cfquery name="countparts" datasource="CustomerSupport">
-
SELECT pk_partID from dbo.tbl_CS_parts where fk_serialNo=<cfqueryparam value="#serialnum#"> and fk_ticketNo=<cfqueryparam value="#Form.pk_ticketID#">
-
</cfquery>
-
<!--- the array gets parts that have been inserted and updated to avoid deleteing the ones that need to be inserted or updated--->
-
<cfset partcheck = ArrayNew(1)>
-
-
-
<!--- inserts information into the serial table--->
-
<cfquery name="serialinsertupdate" datasource="CustomerSupport">
-
exec usp_CS_Updateinsertserial
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
"#Form.pk_ticketID#",
-
<cfqueryparam value="#modelno#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#producttype#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#softhardware#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#resolution#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#resdate#">,
-
<cfqueryparam value="#resvertified#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#vertifidate#">,
-
<cfqueryparam value="#deptvendor#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#hardwarefailure#" CFSQLType = "CF_SQL_VARCHAR">
-
</cfquery>
-
-
<!---Inserts information into notes_descr table.--->
-
-
<!--- the pk_num makes each description added unique, this allows us to delete one descriptoin instead of all description associated with a serial--->
-
<cfif thedescription neq "">
-
<cfquery name="description" datasource="CustomerSupport">
-
exec usp_CS_Insertdescription
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#',
-
<cfqueryparam value="#thedescription#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.fk_addedBy#'
-
</cfquery>
-
<cfelse>
-
</cfif>
-
-
-
<!---Inserts information into parts table.--->
-
<!---because it is a bit we don't use 'ticks' around defective for parts table--->
-
<cfparam name="form.partscount#machinecount#" default="">
-
<cfloop list="#form['partscount' & machinecount]#" index="ps">
-
<!--- the pkpartID makes each part added unique, this allows us to delete one part instead of all parts associated with a serial--->
-
<cfparam name="Form.pkpartID_#ps#_#machinecount#" default="">
-
<cfparam name="Form.hcpn_#ps#_#machinecount#" default="">
-
<cfparam name="Form.defective_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.partsreturn_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.rma_#ps#_#machinecount#" default="">
-
<!--- the pkpartID makes each part added unique, this allows us to delete one part instead of all parts associated with a serial--->
-
<CFSET pkpartID = Form["pkpartID_" & "#ps#" & "_#machinecount#"]>
-
<CFSET hcpn = Form["hcpn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET partsreturn = Form["partsreturn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET defective = Form["defective_" & "#ps#" & "_#machinecount#"]>
-
<CFSET rma = Form["rma_" & "#ps#" & "_#machineCount#"]>
-
<!---the array checks to see what parts are there--->
-
<CFSET ArrayAppend(partcheck, "#Form["pkpartID_" & "#ps#" & "_#machinecount#"]#")>
-
<!---if hcpn is not equal to blank (meaning if it doesn't have a value) it will not insert a part. However if hcpn
-
has a value it will insert the part into the table.--->
-
<cfif hcpn neq "">
-
<cfquery name="parts" datasource="CustomerSupport">
-
exec usp_CS_Updateinsertparts
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#',
-
<cfqueryparam value="#hcpn#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#partsreturn#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#defective#" CFSQLType = "CF_SQL_BIT">
-
</cfquery>
-
<cfelse>
-
</cfif>
-
</cfloop>
-
-
<!---THIS DELETES FOR THE PARTS TABLE--->
-
<!---setting a list for parts--->
-
<cfset partList = ArrayToList(partcheck, ",")>
-
<!---when inserting/updating for part's table is done it then delete parts not being updated/inserted or was to be deleted on purpose--->
-
<cfloop query="countparts">
-
<cfset pk_partID= #pk_partID#>
-
<!---if the part is not found in the list it begins deleteing--->
-
<cfif not listFind(partList,pk_partID)>
-
<cfquery name="deleteparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteparts
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#'
-
</cfquery>
-
</cfif>
-
</cfloop>
-
-
-
-
</CFLOOP>
-
-
<!---THIS DELETES FOR SERIAL TABLE AND ANY PARTS ASSOCIATED WITH THE SERIAL--->
-
<!---setting a list for serial--->
-
<cfset serialList = ArrayToList(serialcheck, ",")>
-
<!---when inserting/updating for serial's table is done it then delete serials not being updated/inserted or was to be deleted on purpose--->
-
<cfloop query="countserials">
-
<CFSET serialnum = #pka_serialNo#>
-
<!---if the serial is not found in the list it begins deleteing--->
-
<cfif not listFind(serialList,serialnum)>
-
<cfquery name="deleteserialparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteserialparts
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#'
-
</cfquery>
-
<!--- if a serial is deleted, then the description for that serial will be deleted as well.--->
-
<cfquery name="deletedescription" datasource="CustomerSupport">
-
exec usp_CS_Deletenotesdescription
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#'
-
</cfquery>
-
</cfif>
-
</cfloop>
-
-
</CFIF>
i am starting to think the problem might not be with are statement but with my stored procedure. If the pk_partId exists it will update, but if it doesn't it inserts. I think because the pk_partID already exists its updating instead of inserting.could this possible be the problem? because i have noticed it is only updating.
Thank you :),
Rach
hey acoder,
I figured it out.It was my stored procedure.basically no matter what the hcpn number was, even if it was different from the first one. For example i inserted 1 and 2 at the same time it would still update to the newest one so i added in my stored procedure - WHERE fk_serialNo=@fk_serialNo and fk_ticketNo=@fk_ticketNo and hc_partNo=@hc_partNo
but anyway this made it where if a hc_partNo and pk_part already exists it would update, if not it would insert. The part i am worried about is what if they have 2 hcpn_partNo for the same part? this doesnt seem a problem if for example i have a 2 with serial 1 and 2 with serial 2. It inserted fine with that. But if i try to insert 2 parts both with the same serial its a problem..Any suggestions or is this a problem all just have to deal with? The only solution i can think of is to add another field an count (like did serial) so that then i can do where the serial number, ticket number an whatever the new field i add is it makes it unique even if i add 1 twice in the same serial.
Thank you,
Rach
Well done on that part (no pun intended ;))! I think the solution should be quite straightforward now. Use the pk_partID (which is unique).
Hey Acoder,
ok i must admit i am confused. Are you saying in my where statement instead of using ticket,serial and the hcpn to use ticket, serial and pk_partid? because i tryed that an it inserted the same part twice perfectly! But i can not get the delete right. Instead of deleteing its adding. But here is what i did
stored procedure for update insert parts - set ANSI_NULLS ON
-
set QUOTED_IDENTIFIER ON
-
go
-
-
-
-
-- =============================================
-
-- Author: <Author,,Name>
-
-- Create date: <Create Date,,>
-
-- Description: <Description,,>
-
-- =============================================
-
ALTER PROCEDURE [dbo].[usp_CS_Updateinsertparts]
-
-- Add the parameters for the stored procedure here
-
(
-
@fk_serialNo nvarchar(100),
-
@fk_ticketNo nvarchar(100),
-
@hc_partNo nvarchar(50),
-
@part_returned char(10),
-
@rma_number nvarchar(1000),
-
@defective bit
-
)
-
AS
-
BEGIN
-
--- SET should be the first statement .. before everything else
-
-- SET NOCOUNT ON added to prevent extra result sets from
-
-- interfering with SELECT statements.
-
SET NOCOUNT ON;
-
-
DECLARE @pk_partID nvarchar(55)
-
-
-
-- If @fk_custNum already exists, get the pk_contactID
-
SELECT @pk_partID = ( SELECT MAX(pk_partID) FROM dbo.tbl_CS_parts WHERE fk_serialNo=@fk_serialNo and fk_ticketNo=@fk_ticketNo and pk_partID=@pk_partID)
-
-
-- If @fk_custNum already exists in the table, update it
-
IF @pk_partID IS NOT NULL
-
BEGIN
-
-
UPDATE dbo.tbl_CS_parts
-
SET
-
-
fk_ticketNo=@fk_ticketNo,
-
hc_partNo=@hc_partNo,
-
part_returned=@part_returned,
-
rma_number=@rma_number,
-
defective=@defective
-
-
-
WHERE (pk_partID=@pk_partID and fk_serialNo=@fk_serialNo and fk_ticketNo=@fk_ticketNo and pk_partID=@pk_partID )
-
-
END
-
-- the @fk_custNum does NOT exist. insert a new record
-
ELSE
-
BEGIN
-
-
-- insert a new record
-
SET @pk_partID = (SELECT max_num FROM tbl_CS_ID_HELPER WHERE table_name='tbl_CS_parts')
-
UPDATE tbl_CS_ID_helper SET max_num=max_num+1 WHERE table_name='tbl_CS_parts'
-
-
-- Insert statements for procedure here
-
INSERT INTO tbl_CS_parts
-
(
-
pk_partID,fk_serialNo,fk_ticketNo,hc_partNo,part_returned ,defective ,rma_number
-
)
-
VALUES
-
(
-
@pk_partID,@fk_serialNo,@fk_ticketNo,@hc_partNo,@part_returned,@defective ,@rma_number
-
)
-
END
-
-
--- return the @pk_contactID
-
SELECT @pk_partID AS partID
-
-
SET NOCOUNT OFF
-
END
-
-
delete for parts -
set ANSI_NULLS ON
-
set QUOTED_IDENTIFIER ON
-
go
-
-
-
-
-
-- =============================================
-
-- Author: <Author,,Name>
-
-- Create date: <Create Date,,>
-
-- Description: <Description,,>
-
-- =============================================
-
ALTER PROCEDURE [dbo].[usp_CS_Deleteparts]
-
-- Add the parameters for the stored procedure here
-
(@pk_partID nvarchar(55),
-
@fk_serialNo nvarchar(100),
-
@fk_ticketNo nvarchar(100))
-
AS
-
-
DELETE FROM tbl_CS_parts
-
-
-
WHERE (pk_partID = @pk_partID and fk_serialNo = @fk_serialNo and fk_ticketNo=@fk_ticketNo)
-
an then on the userformedit.cfm i did the following to the parts section -
<!--- counts how many parts are available--->
-
<cfquery name="countparts" datasource="CustomerSupport">
-
SELECT pk_partID from dbo.tbl_CS_parts where fk_serialNo=<cfqueryparam value="#serialnum#"> and fk_ticketNo=<cfqueryparam value="#Form.pk_ticketID#">
-
</cfquery>
-
<!--- the array gets parts that have been inserted and updated to avoid deleteing the ones that need to be inserted or updated--->
-
<cfset partcheck = ArrayNew(1)>
-
-
-
the above appears under the serial cfsets an the below is the main parts section
-
-
<!---Inserts information into parts table.--->
-
<!---because it is a bit we don't use 'ticks' around defective for parts table--->
-
<cfparam name="form.partscount#machinecount#" default="">
-
<cfloop list="#form['partscount' & machinecount]#" index="ps">
-
<!--- the pkpartID makes each part added unique, this allows us to delete one part instead of all parts associated with a serial--->
-
<cfparam name="Form.pkpartID_#ps#_#machinecount#" default="">
-
-
<cfparam name="Form.hcpn_#ps#_#machinecount#" default="">
-
<cfparam name="Form.defective_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.partsreturn_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.rma_#ps#_#machinecount#" default="">
-
<!--- the pkpartID makes each part added unique, this allows us to delete one part instead of all parts associated with a serial--->
-
-
<CFSET pkpartID = Form["pkpartID_" & "#ps#" & "_#machinecount#"]>
-
<CFSET hcpn = Form["hcpn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET partsreturn = Form["partsreturn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET defective = Form["defective_" & "#ps#" & "_#machinecount#"]>
-
<CFSET rma = Form["rma_" & "#ps#" & "_#machineCount#"]>
-
<!---the array checks to see what parts are there--->
-
<CFSET ArrayAppend(partcheck, "#Form["pkpartID_" & "#ps#" & "_#machinecount#"]#")>
-
<!---if hcpn is not equal to blank (meaning if it doesn't have a value) it will not insert a part. However if hcpn
-
has a value it will insert the part into the table.--->
-
<cfif hcpn neq "">
-
<cfquery name="parts" datasource="CustomerSupport">
-
exec usp_CS_Updateinsertparts
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#',
-
<cfqueryparam value="#hcpn#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#partsreturn#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#defective#" CFSQLType = "CF_SQL_BIT">
-
</cfquery>
-
<cfelse>
-
</cfif>
-
</cfloop>
-
-
<!---THIS DELETES FOR THE PARTS TABLE--->
-
<!---setting a list for parts--->
-
<cfset partList = ArrayToList(partcheck, ",")>
-
<!---when inserting/updating for part's table is done it then delete parts not being updated/inserted or was to be deleted on purpose--->
-
<cfloop query="countparts">
-
<cfset pk_partID= #pk_partID#>
-
<!---if the part is not found in the list it begins deleteing--->
-
<cfif not listFind(partList,pk_partID)>
-
<cfquery name="deleteparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteparts
-
<cfqueryparam value="#pkpartID#" CFSQLType = "CF_SQL_VARCHAR">,
-
<cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
-
'#Form.pk_ticketID#'
-
-
</cfquery>
-
</cfif>
-
</cfloop>
-
-
Thank you,
Rach
In your update/insert stored procedure, you have hcpn missing, and in your Coldfusion code, you've missed out the part ID, so the wrong data is being passed for the fields.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: euang |
last post by:
Hi,
I have been using access 2000 for two years on WINDOWS NT to display dynamic
aweb page using ASP
My ISP has now changed to Windows 2003, and I am having major problems
displaying...
|
by: Sue |
last post by:
As soon as a character is entered in the first field of a new record, the number
of records shown in the navigation buttons increases by 1 and the new record
button becomes enabled. In the...
|
by: Robin S. |
last post by:
I tried to ask this question several days ago, but I didn't explain my
application correctly.
Basically I want to have one record from table "A" and I want to display,
say, 5 records from table...
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
Hey,
Well, I have a Problem.
I have designed a table which has few fields which are being declared in
the database of type ....
char of length 10.
and other fields with varchar 50 and...
|
by: hbomb |
last post by:
I have a form which is used to both enter data for an application and to view a snapshot of previous data entered for students. The database’s initial point of entry is a form called INTERESTED...
|
by: NumberCruncher |
last post by:
Hi All,
I am struggling with setting up my first system of tables, forms,and reports, and could use your help!
I am setting up a database to keep track of the production of a produced item. The...
|
by: banderson |
last post by:
Hello,
I have a combo box in which I want to display multiple fields by concatenating the fields together. If one of those concatenated fields is Null, then the combo box does not show anything. To...
|
by: bonneylake |
last post by:
Hey Everyone,
Well this is probably a pretty easy question, but for some reason i just can not figure it out.
What i am trying to do is redisplay what was entered previously. I have figured...
|
by: chuck gregory |
last post by:
I'm using the 2002 (10.6771.6845) SP3 Access program.
I have a form that will not show previously entered data. It has about 45 fields. I will call it the "parent" form. The "parent" form was at...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |
