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  27224 
It depends on what version of SQL Server you're using. If it's 2000 and later it's very easy - just add a constraint. This article may help. If you need more help on this, I suggest you ask in the SQL Server forum. Once you have it working, you can come back to this thread.
It depends on what version of SQL Server you're using. If it's 2000 and later it's very easy - just add a constraint. This article may help. If you need more help on this, I suggest you ask in the SQL Server forum. Once you have it working, you can come back to this thread.
Hey Acoder,
I am using SQL server 2005. But i am still baffled by the example. The reason i am confused is my tables are not related, they are 2 different separate things so i am not sure how to do it if both tables are not related? but i posted a question on it here http://bytes.com/forum/showthread.ph...89#post3405289
Thank you,
Rach
Hey Acoder,
I wanted to ask if i went back to just looping the coldfusion what sort of performance issues could i run into? reason i am asking is because i am starting
to debate if the delete cascade is going to work on my 2 tables. Also, i thought about it over the weekend and a concern came up i wanted to ask you on. Although are internet is fast where i work most of the time, we do have issues that come up at least once a month where the internet will just die.No warning or anything. An i am wondering what could/would happen if someone was submitting the serials but as they went to submit an they where suppose to be took to the next page and instead of being took to the next page the internet cut out, would all the fields delete an no new ones be added, or would the delete never happen? been thinking about it over the weekend an wanted to ask because if there is the chance of loosing it i must admit that concerns me. Its ok if it remains old information an doesn't update (they can go back an update again later). But if theres no information to update then that could be a serious problem.
Thank you,
Rach
It depends on when it exactly happens, but there's an easy solution. Use cftransaction to make sure it all happens as one transaction.
It depends on when it exactly happens, but there's an easy solution. Use cftransaction to make sure it all happens as one transaction.
Hey Acoder,
Well everything gets inserted into the table after everything has been filled out in the entire form an the user clicks submit. So basically instead of <cfquery name = "" datasource="" i would do something like <cftransaction name="" datasource"" to prevent the problem ?
Thank you,
Rach
No, the cftransaction tag would encapsulate all the cfquerys. Read the docs on the tag.
No, the cftransaction tag would encapsulate all the cfquerys. Read the docs on the tag.
Hey Acoder,
I see what your saying so something like - <cftransaction>
-
<cfquery name="serialinsertupdate" datasource="CustomerSupport">
-
exec usp_CS_Updateserial
-
the fields
-
</cfquery>
-
</cftransaction>
an wanted to ask they had an option where you could add an action to the
cf transaction an was wondering if i needed to add one an if i do which one? an also if i have more the one cfquery on the page where it submits, should i wrap the cftransaction around all the cfquerys present or only the cfquerys i am worried about?
Thank you,
Rach
I think the default options should be OK. It should go around the queries you're worried about. In other words, if it were to crash/lose connection/break down during the running of the queries within cftransaction, there's nothing to worry about. It's either all of them or none.
I think the default options should be OK. It should go around the queries you're worried about. In other words, if it were to crash/lose connection/break down during the running of the queries within cftransaction, there's nothing to worry about. It's either all of them or none.
Hey Acoder,
Well i am glade my concern was only a small fix :). But alrighty so we got the stored procedure for the delete, so were do we go next?
this is the last thing i had on the user form page (before working on the stored procedure). where everything gets sent to the database after editing. - <cftransaction>
-
<!---Inserts information into serial table.--->
-
-
<CFIF REQUEST_METHOD EQ "POST">
-
<CFSET machineListLen = listLen(Form.serialcount)>
-
<CFLOOP from="1" to="#machineListLen#" index="machineCount">
-
<cfloop>
-
<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]>
-
-
-
<!--- inserts information into the serial table--->
-
<cfquery name="serialinsertupdate" datasource="CustomerSupport">
-
exec usp_CS_Updateserial
-
<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.--->
-
<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>
-
-
<!---Inserts parts information into parts table.--->
-
<!---because it is a bit we don't use 'ticks' around defective for parts table--->
-
<cfloop list="#form['part2count' & machinecount]#" index="ps">
-
<cfloop>
-
<cfparam name="Form.defective_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.partsreturn_#ps#_#machinecount#" default="0">
-
<CFSET hcpn = Form["hcpn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET partsreturn = Form["partsreturn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET defective = Form["defective_" & "#ps#" & "_#machinecount#"]>
-
<CFSET rma = Form["rma_" & "#ps#" & "_#machineCount#"]>
-
<cfquery name="parts" datasource="CustomerSupport">
-
exec usp_CS_Updateparts
-
<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="#defective#" CFSQLType = "CF_SQL_BIT">,
-
<cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">
-
</cfquery>
-
</cfloop>
-
</cfloop>
-
</cfloop>
-
</CFLOOP>
-
</CFIF>
-
</cftransaction>
-
Thank you,
Rach
You need to add a call to the delete stored procedure at the top within the cftransaction. I'm thinking that if this is the only place this stored procedure is used, you could modify it to delete by ticket, so you wouldn't have to call it repeatedly for all serials.
You need to add a call to the delete stored procedure at the top within the cftransaction. I'm thinking that if this is the only place this stored procedure is used, you could modify it to delete by ticket, so you wouldn't have to call it repeatedly for all serials.
Hey Acoder,
Are you saying call it by using a cfquery like so? or is there another way to call it for a delete? - <cftransaction>
-
<!---Inserts information into serial table.--->
-
<cfquery name="deleteserialparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteserialparts
-
</cfquery>
-
-
<CFIF REQUEST_METHOD EQ "POST">
Thank you,
Rach
The stored proc. requires two parameters, serial no and ticket no. I was suggesting that you modify the stored procedure to delete by ticket, so it gets all serials matching that ticket no. and deletes them (and the cascade would delete all parts too). Of course, you could do this via Coldfusion by using a select query first and then looping over the results to delete each serial one by one, but doing it all in one go via a single stored procedure call would be more efficient.
The stored proc. requires two parameters, serial no and ticket no. I was suggesting that you modify the stored procedure to delete by ticket, so it gets all serials matching that ticket no. and deletes them (and the cascade would delete all parts too). Of course, you could do this via Coldfusion by using a select query first and then looping over the results to delete each serial one by one, but doing it all in one go via a single stored procedure call would be more efficient.
Hey Acoder,
So your basically saying to do something like this in the stored procedure to delete just based on ticket number? - set ANSI_NULLS ON
-
set QUOTED_IDENTIFIER ON
-
go
-
-
-
-
-
-- =============================================
-
-- Author: <Author,,Name>
-
-- Create date: <Create Date,,>
-
-- Description: <Description,,>
-
-- =============================================
-
ALTER PROCEDURE [dbo].[usp_CS_Deleteserialparts]
-
-- Add the parameters for the stored procedure here
-
(@pkb_fk_ticketNo nvarchar(100)) AS
-
-
DELETE FROM dbo.tbl_CS_serial where pkb_fk_ticketNo = @pkb_fk_ticketNo
Thank you,
Rach
Well, if that works, then yes. Test it out with a few serials, i.e. add 3 serials for a particular ticket, say no. 3, with some parts too for those serials, then try this stored procedure with '3' supplied to it.
Hey Acoder,
Yep that worked perfectly :), So whats next?
Thank you,
Rach
In your code in #161, just add the ticket no. I can't recall now, but I think that it was passed via the URL.
In your code in #161, just add the ticket no. I can't recall now, but I think that it was passed via the URL.
Hey Acoder,
Here is what i have in full. An when the user opens up a ticket an when a user goes to the second page it gets passed via URL. but when they finally submit it (like we are doing) it don't get passed by URL it just submits. - <cftransaction>
-
<!---Inserts information into serial table.--->
-
<cfquery name="deleteserialparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteserialparts '#Form.pk_ticketID#'
-
</cfquery>
-
-
<CFIF REQUEST_METHOD EQ "POST">
-
<CFSET machineListLen = listLen(Form.serialcount)>
-
<CFLOOP from="1" to="#machineListLen#" index="machineCount">
-
<cfloop>
-
<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]>
-
-
-
<!--- inserts information into the serial table--->
-
<cfquery name="serialinsertupdate" datasource="CustomerSupport">
-
exec usp_CS_Updateserial
-
<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.--->
-
<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>
-
-
<!---Inserts parts information into parts table.--->
-
<!---because it is a bit we don't use 'ticks' around defective for parts table--->
-
<cfloop list="#form['part2count' & machinecount]#" index="ps">
-
<cfloop>
-
<cfparam name="Form.defective_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.partsreturn_#ps#_#machinecount#" default="0">
-
<CFSET hcpn = Form["hcpn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET partsreturn = Form["partsreturn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET defective = Form["defective_" & "#ps#" & "_#machinecount#"]>
-
<CFSET rma = Form["rma_" & "#ps#" & "_#machineCount#"]>
-
<cfquery name="parts" datasource="CustomerSupport">
-
exec usp_CS_Updateparts
-
<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="#defective#" CFSQLType = "CF_SQL_BIT">,
-
<cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">
-
</cfquery>
-
</cfloop>
-
</cfloop>
-
</cfloop>
-
</CFLOOP>
-
</CFIF>
-
Thank you,
Rach
That looks right. Did you test it?
That looks right. Did you test it?
Hey Acoder,
I tested it, an it deleted, but it did not reinsert the information into the table. I had to delete the 2 extra cfloops i had in there cause it was causing trouble beyond that i still have the same thing. - <cftransaction>
-
<!---Inserts information into serial table.--->
-
<cfquery name="deleteserialparts" datasource="CustomerSupport">
-
exec usp_CS_Deleteserialparts '#Form.pk_ticketID#'
-
</cfquery>
-
-
<CFIF REQUEST_METHOD EQ "POST">
-
<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 thedescription = Form["thedescription_" & machineCount]>
-
-
-
<!--- inserts information into the serial table--->
-
<cfquery name="serialinsertupdate" datasource="CustomerSupport">
-
exec usp_CS_Updateserial
-
<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.--->
-
<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>
-
-
<!---Inserts parts information into parts table.--->
-
<!---because it is a bit we don't use 'ticks' around defective for parts table--->
-
<cfloop list="#form['part2count' & machinecount]#" index="ps">
-
<cfparam name="Form.defective_#ps#_#machinecount#" default="0">
-
<cfparam name="Form.partsreturn_#ps#_#machinecount#" default="0">
-
<CFSET hcpn = Form["hcpn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET partsreturn = Form["partsreturn_" & "#ps#" & "_#machinecount#"]>
-
<CFSET defective = Form["defective_" & "#ps#" & "_#machinecount#"]>
-
<CFSET rma = Form["rma_" & "#ps#" & "_#machineCount#"]>
-
<cfquery name="parts" datasource="CustomerSupport">
-
exec usp_CS_Updateparts
-
<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="#defective#" CFSQLType = "CF_SQL_BIT">,
-
<cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">
-
</cfquery>
-
</cfloop>
-
</CFLOOP>
-
</CFIF>
Thank you,
Rach
Yeah, you had some extra cfloop tags.
Have you checked what's being passed from the client-side? Does it flag up any errors?
Yeah, you had some extra cfloop tags.
Have you checked what's being passed from the client-side? Does it flag up any errors?
Hey Acoder,
I figured it out, i needed to change the exec from updating to insert, so now its inserting it. But sadly i am still having the same trouble i had before. After i made the change an went to edit its still showing duplicate entries although in the table itself it only shows the serials i insert once. An like before its only putting duplicates of previously submitted serials. The new one i inserted (to try the change out) did not insert another one only the previous serial i had before.
But i think i know where the problem is. I started taking out things an well i been thinking the whole time it was the javascript doing it, an so i took out all the javascript at the top that allows users to add serials and parts. an well i went and made changes to one serial and resubmitted it an went back to edit it an it only showed that one serial! so i think the javascript is causing it, but i have no clue where it is causing it. Here is what i have for the javascript on this page. - <!---Allows us to add serial information multiple times --->
-
<script type="text/javascript">
-
<!---Allows us to add multiple fields --->
-
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 getparts = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
var partc = 'partscount'+count;
-
var part2c = 'part2count'+count;
-
-
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 id='hardwarefailure' 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 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>";
-
-
<!--- 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 1500 characters. )"+
-
"<br>" +
-
"<textarea maxlength='1500' onkeyup='return resolutionmaxlength(this)' onkeydown='return resolutionmaxlength(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 + "' id='deptvendor'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getDeptVendor'>" +
-
"<option value='#pk_deptVendor#'>#pk_deptVendor#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>" +
-
"<input type='hidden' name='"+partc+"' id='"+partc+"' value='0'>" +
-
"<input type='hidden' name='"+part2c+"' id='"+part2c+"' value=''>" +
-
"<input type='hidden' name='serialcount' id='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>" +
-
"</tr>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='addticket' value='Add Parts' onclick=\"addpartInput(\'"+divIdName+"\')\">" +
-
"</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>
-
-
-
-
-
-
<!---Allows us to add PARTS information multiple times--->
-
<script type="text/javascript">
-
<!---Adds multiple fields for parts --->
-
function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
<!---('partsInput')--->
-
-
<!---this works if only want to add a part under the serial you are working with, but if you have
-
serial information 1
-
and serial information 2 an want to add information to serial information 1 you cant because parts always appear under the last serial information added if you click add parts--->
-
var getparts = document.getElementById('div');
-
<!---var avalue = document.getElementById('aValue');--->
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partscount"+serialno);
-
<!---var count = (document.getElementById('avalue').value -1)+ 2;--->
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value += count + ",";
-
var partdiv = document.createElement('div');
-
<!---var partIdName = 'part'+count+'Name';--->
-
var partIdName = 'part' + count + 'Name' + serialno;
-
<!---'parts'+count+'Input'--->
-
-
partdiv.setAttribute('id',partIdName);
-
-
<!--- Adds Extra fields for parts table --->
-
partdiv.innerHTML =
-
<!---what used originally for this tableclass='createticketables' id='spaceup'--->
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0' >" +
-
"<th class='sectiontitle' colspan='7'>Parts Information "+ count +" Serial Information "+serialno+"</th>" +
-
"<tr>" +
-
"<td class='indent' id='formfieldpadding'>HC P/N: " +
-
"<input type='text' name='hcpn_" + count + "_"+serialno+"' style='margin:0px'></td>" +
-
"<td>" +
-
"Parts been returned* " +
-
"<input type='checkbox' name='partsreturn_" + count + "_"+serialno+"' value='1'>" +
-
"</td>" +
-
"<td>" +
-
"<td class='indent'>Defective<input type='checkbox' name='defective_" + count +"_"+serialno+"' value='1'>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
partdiv.innerHTML = partdiv.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 1000 characters. )"+
-
"<br/>" +
-
"<textarea maxlength='1000' onkeyup='return rmamaxlength(this)' onkeydown='return rmamaxlength(this)' rows='4' cols='60' name='rma_" + count + "_"+serialno+"'></textarea> " +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Delete to every ticket --->
-
partdiv.innerHTML = partdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='removeticket' value='Remove Parts ""+count +""' onclick=\"removetheElement('"+partIdName+"',"+serialno+","+count+")\"></a>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
document.getElementById(partName).appendChild(partdiv);
-
}
-
-
<!---Allows us to remove multiple fields--->
-
function removetheElement(divNum, serialno, partnum) {
-
<!---var d = document.getElementById('partsInput');--->
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value = partslist.value.replace(partnum+',',"");
-
var olddiv = document.getElementById(divNum);
-
olddiv.parentNode.removeChild(olddiv);
-
}
-
-
</script>
Thank you,
Rach
It won't be the JavaScript which is causing it because the JavaScript only adds when you call it unless you are calling addInput when the page loads.
At least the inserting is now working, so it's just the displaying which is causing problems. Look at the Coldfusion code which generates the HTML
It won't be the JavaScript which is causing it because the JavaScript only adds when you call it unless you are calling addInput when the page loads.
At least the inserting is now working, so it's just the displaying which is causing problems. Look at the Coldfusion code which generates the HTML
Hey Acoder,
The only way it can call addInput would be something like for example body onload="dynamicInput" correct? i did have that at one point but not anymore so i don't think i am calling it but it only happens when i go back an look at that page. Like it is not inserting duplicate records in the database (never was) it only redisplays duplicates when i get to the cticketpage2edit.cfm page where it shows the previously submitted records for serial and parts.
An i am confused on the coldfusion code which generates the html? are you talking about the coldfusion querys where it shows the results? or are you talking about the html code that appears inbetween the divs?
Thank you,
Rach
I mean the code which generates the HTML displaying the serials and parts.
When you say go back, do you mean pressing the back button or do you mean clicking a link to go back to another page? Can you show the relevant able displaying code from cticketpage2edit.cfm.
I mean the code which generates the HTML displaying the serials and parts.
When you say go back, do you mean pressing the back button or do you mean clicking a link to go back to another page? Can you show the relevant able displaying code from cticketpage2edit.cfm.
Hey Acoder,
I mean when i click the link to go to another page. However, the thing is it will only show the duplicate if i click the final submit. If i am on cticketpage2edit and close it out an go to relook at it, it doesn't insert the duplicate. Just when i click that final submit button. An like i said when i took out all the javascript at the top, it didn't show a duplicate when i clicked on that final submit button and viewed the information again. but here is what i have inbetween the div's that display the previously entered information - <!--- Ticket Information
-
This display the ticket Information--->
-
-
<!---<input type="hidden" value="0" id="theValue" />--->
-
<div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
<!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure --->
-
<cfset count = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfoutput query="serial">
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfset count = count + 1>
-
<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 --->
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
#description#
-
( 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--->
-
-
-
-
<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>
-
</cfloop>
-
</div>
-
</cfoutput>
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
-
-
<!---If have any blanks in serial table it will make field appear--->
-
<cfoutput query="serial">
-
<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 description = #description#>
-
<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#>
-
</cfoutput>
-
<cfif serial.recordcount is 0>
-
<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="serialdisplay.cfm">
-
</cfif>
-
-
<!---Parts Information, display parts if have or don't have a value--->
-
<cfoutput query="parts">
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfoutput>
-
<cfif parts.recordcount is 0>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfinclude template="partsdisplay.cfm">
-
</cfif>
-
-
</div>
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
Thank you,
Rach
I'm not sure what could be the exact cause of this strange behaviour, but I notice that you have serialdisplay.cfm and partsdisplay.cfm included at the bottom. I can't recall exactly (from a previous thread), but I remember those files containing the display for serials/parts which would mean a duplicate display. However, this should mean that it occurs every time and not only in certain circumstances. Can you remind me of the contents of serialdisplay.cfm.
Hey Acoder,
What serialdisplay.cfm and partsdisplay.cfm do is when a field or fields are not entered what it does is display those fields because before if a field was not enetered it would not display the field at all.This would happen if a serial or parts section was not filled out an then it happened only to certain fields, especially text input fields. But i know if this could be the problem considering i have commented out the lines that have anything to do with those 2 files an the problem still happened.. But Here is what i have in both files
serialdisplay.cfm
partsdisplay.cfm - <!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
-
-
<cfif parts.recordcount is 0>
-
<cfset count1 = 0>
-
<cfoutput>
-
<cfset count1 = count1 + 1>
-
<div id="part#count1#Name#count#">
-
<!---THIS IS THE PARTS SECTION--->
-
<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=""></td>
-
<td>
-
Parts been returned*
-
<input type="checkbox" name="partsreturn_#count1#_#count#" value=""<cfif #part_returned# eq "1">checked=yes</cfif>/>
-
</td>
-
<td>
-
<td class="indent">Defective<input type="checkbox" name="defective_#count1#_#count#" value=""<cfif #defective# eq "1">checked=yes</cfif>/></td>
-
</td>
-
</tr>
-
</table>
-
<input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">
-
-
<!--- 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#" ></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#')"></a>
-
</td>
-
</td>
-
</tr>
-
</table>
-
</div>
-
</cfoutput>
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
</cfif>
Thank you,
Rach
Hey Acoder,
After trying a few more tests. I think parts might be the problem.
what i did was submitted and entry where there was only a serial (no parts). When i went to look back at it i saw nothing for parts (i commented out partsdisplay.cfm).An i opened up firebug an i saw nothing associated with parts in there. However, when i click to add another serial and view it in firebug, it included these 2 lines. - <input id="partscount2" type="hidden" value="0" name="partscount2"/>
-
<input id="part2count2" type="hidden" value="" name="part2count2"/>
-
<input id="serialcount" type="hidden" value="2" name="serialcount"/>
the thing with it is i have not added a part to this new serial yet. An i never added a part to the old serial but yet its counting it like i did add a part. Also, i even tried just submitted the previously fill in serial with no extra serial or any parts an i got the error - An error occurred while evaluating the expression:
-
-
"#form['part2count' & machinecount]#"
-
-
Error near line 91, column 20.
-
-
The member "PART2COUNT1" in dimension 1 of object "form" cannot be found. Please, modify the member name.
-
i think parts could possible be adding something extra to it. The only way it can be adding extra to it. Is in the javascript under the serial function of the javascript there is these 3 lines - "<input type='hidden' name='"+partc+"' id='"+partc+"' value='0'>" +
-
"<input type='hidden' name='"+part2c+"' id='"+part2c+"' value=''>" +
-
"<input type='hidden' name='serialcount' id='serialcount' value='" + count + "'>";
the only thing i can think of to prevent it is to move the 2 part lines to the parts function of the javascript. However, i am not sure how to do this without running into problems.
Thank you,
Rach
You're right about the serial/parts displays.
However, the thing is it will only show the duplicate if i click the final submit. If i am on cticketpage2edit and close it out an go to relook at it, it doesn't insert the duplicate. Just when i click that final submit button. An like i said when i took out all the javascript at the top, it didn't show a duplicate when i clicked on that final submit button and viewed the information again.
Now, can you explain this again in more detail? Is the submit button on the cticketpage2edit page? When you say relook, do you mean this edit page or the page before? Also, by "insert duplicate", you mean display a duplicate entry because it's not physically creating a duplicate in the database, right?
How many pages are there in total in the whole process of creating/updating serials/parts and what's the purpose of each page?
You're right about the serial/parts displays.
Now, can you explain this again in more detail? Is the submit button on the cticketpage2edit page? When you say relook, do you mean this edit page or the page before? Also, by "insert duplicate", you mean display a duplicate entry because it's not physically creating a duplicate in the database, right?
How many pages are there in total in the whole process of creating/updating serials/parts and what's the purpose of each page?
Hey Acoder,
Alrighty here we go. Alrighty yes the submit button (final submit) button is on cticketpage2edit.cfm. When i say relook i mean once i make changes, submit the changes an then reopen cticketpage2edit to see the changes i made is when i notice it. It does not insert duplicate entrys into the table it only displays duplicate entrys when i go back an look at cticketpage2edit.
Alrighty there are 2 pages. Cticketpage1edit.cfm displays the general information and contact information. When i click submit on cticketpage1edit.cfm it takes me to cticketpage2edit.cfm where it redisplays the general information and contact information and it also allows the user to add/edit serials and parts (cticketpage1edit has nothing involving serial or parts). Because the form is long we split it into 2 pages to make it easier on the person filling out the information. On the second page is where the user edit/enters serial information and parts information an once the user is done then the user resubmits all the information from general information and contact information an also submits all the changes for serial and parts.
i don't know if this would help. But this is what i have in full on the cticketpage2edit.cfm page.
querys that display the information - <cfquery name="models" datasource="systems">
-
Select distinct Model
-
From models
-
</cfquery>
-
-
<!---Shows what was previously entered into serial and description table--->
-
<cfquery name="serial" datasource="CustomerSupport">
-
SELECT pka_serialNo,pkb_fk_ticketNo,model_no,product_type,software_hardware,
-
resolution,resolution_date,verification_date,type_hardware_failure,
-
dept_responsibility,resolution_verified_by,fk_serialNo,fk_ticketNo,description
-
FROM dbo.tbl_CS_serial
-
LEFT JOIN dbo.tbl_CS_notes_descr
-
ON dbo.tbl_CS_serial.pkb_fk_ticketNo=dbo.tbl_CS_notes_descr.fk_ticketNo and
-
dbo.tbl_CS_serial.pka_serialNo=dbo.tbl_CS_notes_descr.fk_serialNo
-
WHERE pkb_fk_ticketNo = #URL.pk_ticketID# and fk_ticketNo = #URL.pk_ticketID#
-
ORDER BY pkb_fk_ticketNo
-
</cfquery>
-
-
<!---Shows what was previously entered into parts table--->
-
<cfquery name="parts" datasource="CustomerSupport">
-
SELECT pk_partID,fk_serialNo,fk_ticketNo,hc_partNo,ltrim(rtrim(part_returned)) as part_returned,rma_number,defective
-
FROM dbo.tbl_CS_parts
-
WHERE fk_ticketNo = #URL.pk_ticketID#
-
</cfquery>
-
the javascript for serial and parts - <!---Allows us to add serial information multiple times --->
-
<script type="text/javascript">
-
<!---Allows us to add multiple fields --->
-
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 getparts = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
var partc = 'partscount'+count;
-
var part2c = 'part2count'+count;
-
-
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 id='hardwarefailure' 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 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>";
-
-
<!--- 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 1500 characters. )"+
-
"<br>" +
-
"<textarea maxlength='1500' onkeyup='return resolutionmaxlength(this)' onkeydown='return resolutionmaxlength(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 + "' id='deptvendor'>" +
-
"<option value='' selected>Make A Selection</option>" +
-
"<cfoutput query='getDeptVendor'>" +
-
"<option value='#pk_deptVendor#'>#pk_deptVendor#</option>" +
-
" </cfoutput>" +
-
"</select>" +
-
"</td>" +
-
"</tr>" +
-
"</table>" +
-
"<input type='hidden' name='"+partc+"' id='"+partc+"' value='0'>" +
-
"<input type='hidden' name='"+part2c+"' id='"+part2c+"' value=''>" +
-
"<input type='hidden' name='serialcount' id='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>" +
-
"</tr>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='addticket' value='Add Parts' onclick=\"addpartInput(\'"+divIdName+"\')\">" +
-
"</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>
-
-
-
-
-
-
<!---Allows us to add PARTS information multiple times--->
-
<script type="text/javascript">
-
<!---Adds multiple fields for parts --->
-
function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
<!---('partsInput')--->
-
-
<!---this works if only want to add a part under the serial you are working with, but if you have
-
serial information 1
-
and serial information 2 an want to add information to serial information 1 you cant because parts always appear under the last serial information added if you click add parts--->
-
var getparts = document.getElementById('div');
-
<!---var avalue = document.getElementById('aValue');--->
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partscount"+serialno);
-
<!---var count = (document.getElementById('avalue').value -1)+ 2;--->
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value += count + ",";
-
var partdiv = document.createElement('div');
-
<!---var partIdName = 'part'+count+'Name';--->
-
var partIdName = 'part' + count + 'Name' + serialno;
-
<!---'parts'+count+'Input'--->
-
-
partdiv.setAttribute('id',partIdName);
-
-
<!--- Adds Extra fields for parts table --->
-
partdiv.innerHTML =
-
<!---what used originally for this tableclass='createticketables' id='spaceup'--->
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0' >" +
-
"<th class='sectiontitle' colspan='7'>Parts Information "+ count +" Serial Information "+serialno+"</th>" +
-
"<tr>" +
-
"<td class='indent' id='formfieldpadding'>HC P/N: " +
-
"<input type='text' name='hcpn_" + count + "_"+serialno+"' style='margin:0px'></td>" +
-
"<td>" +
-
"Parts been returned* " +
-
"<input type='checkbox' name='partsreturn_" + count + "_"+serialno+"' value='1'>" +
-
"</td>" +
-
"<td>" +
-
"<td class='indent'>Defective<input type='checkbox' name='defective_" + count +"_"+serialno+"' value='1'>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Extra fields for RMA Data Only --->
-
partdiv.innerHTML = partdiv.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 1000 characters. )"+
-
"<br/>" +
-
"<textarea maxlength='1000' onkeyup='return rmamaxlength(this)' onkeydown='return rmamaxlength(this)' rows='4' cols='60' name='rma_" + count + "_"+serialno+"'></textarea> " +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
-
<!--- Adds Delete to every ticket --->
-
partdiv.innerHTML = partdiv.innerHTML +
-
"<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
-
"<tr>" +
-
"<td>" +
-
"<input type='button' class='removeticket' value='Remove Parts ""+count +""' onclick=\"removetheElement('"+partIdName+"',"+serialno+","+count+")\"></a>" +
-
"</td>" +
-
"</td>" +
-
"</tr>" +
-
"</table>";
-
-
document.getElementById(partName).appendChild(partdiv);
-
}
-
-
<!---Allows us to remove multiple fields--->
-
function removetheElement(divNum, serialno, partnum) {
-
<!---var d = document.getElementById('partsInput');--->
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value = partslist.value.replace(partnum+',',"");
-
var olddiv = document.getElementById(divNum);
-
olddiv.parentNode.removeChild(olddiv);
-
}
-
-
</script>
the html for serial and parts - <form action="userformedit.cfm" id="userForm" name="userForm" method="POST" enctype="multipart/form-data" onclick="multipleSelectOnSubmit();">
-
-
<!--- Ticket Information
-
This display the ticket Information--->
-
-
<!---<input type="hidden" value="0" id="theValue" />--->
-
<div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<cfset count = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfoutput query="serial">
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfset count = count + 1>
-
<!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure --->
-
<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 --->
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
#description#
-
( 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--->
-
-
-
-
<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>
-
</cfloop>
-
</div>
-
</cfoutput>
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
-
-
<!---If have any blanks in serial table it will make field appear--->
-
<cfoutput query="serial">
-
<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 description = #description#>
-
<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#>
-
</cfoutput>
-
<cfif serial.recordcount is 0>
-
<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="serialdisplay.cfm">
-
</cfif>
-
-
<!---Parts Information, display parts if have or don't have a value--->
-
<!---<cfoutput query="parts">
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfoutput>
-
<cfif parts.recordcount is 0>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfinclude template="partsdisplay.cfm">
-
</cfif>--->
-
-
</div>
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
-
<!--- Submit --->
-
<table>
-
<tr>
-
<td>
-
<input type="submit" class="officalsubmit" value="submit" name="submit" onClick="return validate_form();">
-
</td>
-
</tr>
-
</table>
-
</p>
-
-
</form>
Thank you,
Rach
Just one more quick question before I take a closer look at this: when you look at this page again, do you press the back key from the submit page ("usereditform.cfm) or do you click on a link/button to go to that page?
Just one more quick question before I take a closer look at this: when you look at this page again, do you press the back key from the submit page ("usereditform.cfm) or do you click on a link/button to go to that page?
Hey Acoder,
What i do is once i resubmit i completely close out the window. An i have another window open an its open to a page called index.cfm page which lists all the tickets that have been submitted and i click on the ticket that i edited an that takes me to cticketpage1edit.cfm an takes me back through the process of going to cticketpage2edit.cfm and then resubmitting again.
Thank you,
Rach
Hey Acoder,
I was just playing with it an i noticed something. I was on cticketpage2edit.cfm and i accidently hit back to cticketpage1edit.cfm an well then i decided to click submit on cticketpage1edit.cfm to take me back to cticketpage2edit.cfm an it added another serial and part with it! so far i have only been able to redo this once. Is there a possibility that the url method could be adding everytime i go to cticketpage2edit.cfm? or is strickly javascript causeing it?
Thank you,
Rach
I missed one of your earlier posts. I think you're along the right lines when you say the parts might be the problem. Note that the two input hidden fields relating to parts "partscount#count#" and "part2count#count#" should only appear once for each serial. What these do is count the number of parts for the serial and list the number of the parts, so obviously they should only appear once for each serial.
Having had a closer look at your code, I now see where the problem potentially lies. In your HTML code snippet (posted in #180), look at lines 202/203. You have these two hidden input lines, but they're in the parts display code rather than serials. You need to move them up to the serials display as well as the code which generates the values.
On hindsight, I realise that some of this could have been avoided if it was kept simple as is the case with the serialcount, but we play with what we've got.
Hey Acoder,
i am not sure if i did this correctly, but i am running into the same trouble as before. The part that has been confused is that. When we do the second count for parts we do - <cfset count1 = 0>
-
<cfloop query="getparts">
-
<div id="part#count1#Name#count#">
-
<cfset count1 = count1 + 1>
and the thing is this hidden field depends on that count - <input type="hidden" name="partscount#count#" id="partscount#count#" value="#count1#">
-
so i am not sure if i move everything for getparts to make it loop or what to make it get the correct value for the second hidden field.
This is what i have - <!--- Ticket Information
-
This display the ticket Information--->
-
-
<!---<input type="hidden" value="0" id="theValue" />--->
-
<div id="dynamicInput">
-
<!--- All Ticket Information Appears Here--->
-
-
<cfset count = 0>
-
<!---<cfif serial.recordcount is 0>--->
-
<cfoutput query="serial">
-
<cfset model_no = #model_no#>
-
<cfset product_type = #product_type#>
-
<cfset type_hardware_failure = #type_hardware_failure#>
-
<cfset software_hardware = #software_hardware#>
-
<cfset resolution_verified_by = #resolution_verified_by#>
-
<cfset dept_responsibility = #dept_responsibility#>
-
<cfset count = count + 1>
-
<!--- Shows what was previously entered for Model No, Product Type, and Type of Hardware Failure --->
-
<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 --->
-
-
<table class="zpExpandedTable" id="resoltable" cellpadding="3" cellspacing="0">
-
<tr>
-
<td id="paddingformutli">
-
Description:
-
</td>
-
<td class="descriptionmoveinmulti">
-
#description#
-
( 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#">
-
<cfset count1 = 0>
-
<cfset count1 = count1 + 1>
-
-
<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#">
-
<!--- 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>
-
-
<!---<cfif serial.recordcount is 0>--->
-
<cfloop query="getparts">
-
<div id="part#count1#Name#count#">
-
-
<!---THIS IS THE PARTS SECTION--->
-
-
-
-
<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>
-
</cfloop>
-
</div>
-
</cfoutput>
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
-
-
<!---If have any blanks in serial table it will make field appear--->
-
<cfoutput query="serial">
-
<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 description = #description#>
-
<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#>
-
</cfoutput>
-
<cfif serial.recordcount is 0>
-
<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="serialdisplay.cfm">
-
</cfif>
-
-
<!---Parts Information, display parts if have or don't have a value--->
-
<!---<cfoutput query="parts">
-
<cfset hc_partNo = #hc_partNo#>
-
<cfset part_returned = #part_returned#>
-
<cfset defective = #defective#>
-
<cfset rma_number = #rma_number#>
-
<cfinclude template="partsdisplay.cfm">
-
</cfoutput>
-
<cfif parts.recordcount is 0>
-
<cfset hc_partNo = "">
-
<cfset part_returned = "">
-
<cfset defective = "">
-
<cfset rma_number = "">
-
<cfinclude template="partsdisplay.cfm">
-
</cfif>--->
-
-
</div>
-
<input type="button" class="addticket" value="Add Serial" onClick="addInput('dynamicInput');" >
Thank you,
Rach
That wouldn't work properly because the parts count variable count1 needs to be incremented in a loop.
I think because of the possible problems trying to get this working smoothly, it might be an idea to move the parts count into parts as you were suggesting. This would remove the need to re-generate the parts numbers and the list would be generated for the next page when submitted by Coldfusion anyway.
That wouldn't work properly because the parts count variable count1 needs to be incremented in a loop.
I think because of the possible problems trying to get this working smoothly, it might be an idea to move the parts count into parts as you were suggesting. This would remove the need to re-generate the parts numbers and the list would be generated for the next page when submitted by Coldfusion anyway.
Hey Acoder,
are you saying in the javascript to move the 2 parts count lines from serial function to the parts function? an then leave the parts section in the html how i had it? or are you suggestion i just leave the count1 in the parts section of the html and put the other part count in the serial part of the html?
an if its the html way i just not sure what to take out in the parts function an what needs to stay to make the new changes work.
heres the serial and parts functions -
<!---Allows us to add serial information multiple times --->
-
<script type="text/javascript">
-
<!---Allows us to add multiple fields --->
-
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 getparts = document.createElement('div');
-
var divIdName = 'dynamic'+count+'Input';
-
var partc = 'partscount'+count;
-
var part2c = 'part2count'+count;
-
-
newdiv.setAttribute('id',divIdName);
-
-
-
<!---Allows us to add PARTS information multiple times--->
-
<script type="text/javascript">
-
<!---Adds multiple fields for parts --->
-
function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
var getparts = document.getElementById('div');
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partscount"+serialno);
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value += count + ",";
-
var partdiv = document.createElement('div');
-
var partIdName = 'part' + count + 'Name' + serialno;
-
-
-
partdiv.setAttribute('id',partIdName);
Thank you,
Rach
Look at how the serialcount is done. There's one per serial. If you have three serials 1, 2 and 4, then the counts would be 1, 2, and 4. If you now add one more, it'd be 5. When submitted, this would be sent as "1,2,4,5" - exactly what you need.
You need something similar for part counts. The only difference is that you have one per part, so they will need to be named different for each serial, e.g. partscount1 for serial 1, partscount2 for serial 2 and so on.
If you do this, then there's no need for two hidden fields for part counts, just one will do, because this new way will do both jobs at once. So, all parts-counts for serial 1 would be submitted in partscount1 and available in the submitted page as form.partscount1.
This would need to change in both the HTML and the JavaScript. It will also mean that there's no need for the loop to generate the values - just add an input field for each part with the count in the getparts loop. You will also no longer need to remove values when removing parts in removetheElement().
Hey Acoder,
So your saying to remove to 2 parts in the serial function i have which is - "<input type='hidden' name='"+partc+"' id='"+partc+"' value='0'>" +
-
"<input type='hidden' name='"+part2c+"' id='"+part2c+"' value=''>" +
Then in the parts section add a hidden field like so - "<input type='hidden' name='partscount' id='partscount' value='" + count + "_"+serialno+"'>";
an then in the html i would remove the following - <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#">
an just put - <input type="hidden" name="partscount" id="partscount" value="#count1#">
would this be right?
Thank you,
Rach
Not quite. You can't call it partscount only. You'd have to name each one with the serial number, e.g. for serial 2, it'd be named partscount2. The HTML looks right, but in the JavaScript, the value should be set to the current part number.
Not quite. You can't call it partscount only. You'd have to name each one with the serial number, e.g. for serial 2, it'd be named partscount2. The HTML looks right, but in the JavaScript, the value should be set to the current part number.
Hey Acoder,
Ok i am sorta lost. Are you saying for parts count that the value can't just be - "<input type='hidden' name='partscount' id='partscount' value='" + count + "_"+serialno+"'>";
it has to be something like - "<input type='hidden' name='partscount" + count + "' id='partscount' value='+ count +'>";
Thank you,
Rach
The name should be "partscount" + the serial no. and, yes, the value should be count.
The name should be "partscount" + the serial no. and, yes, the value should be count.
Hey Acoder,
So the hidden input field in the javascript part should be the following? - "<input type='hidden' name='"partscount" + serialno + ' id='partscount' value='" + count + "'>";
an then in the parts function what needs to be removed? in the serial function i got rid of along with the 2 hidden fields. - var partc = 'partscount'+count;
-
var part2c = 'part2count'+count;
-
but i have no clue what in parts needs to stay or go. - <!---Allows us to add PARTS information multiple times--->
-
<script type="text/javascript">
-
<!---Adds multiple fields for parts --->
-
function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
var getparts = document.getElementById('div');
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partscount"+serialno);
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value += count + ",";
-
var partdiv = document.createElement('div');
-
var partIdName = 'part' + count + 'Name' + serialno;
-
partdiv.setAttribute('id',partIdName);
-
-
-
<!---Allows us to remove multiple fields--->
-
function removetheElement(divNum, serialno, partnum) {
-
<!---var d = document.getElementById('partsInput');--->
-
var partslist = document.getElementById("part2count"+serialno);
-
partslist.value = partslist.value.replace(partnum+',',"");
-
var olddiv = document.getElementById(divNum);
-
olddiv.parentNode.removeChild(olddiv);
-
}
Thank you,
Rach
So the hidden input field in the javascript part should be the following?
- "<input type='hidden' name='"partscount" + serialno + ' id='partscount' value='" + count + "'>";
The quotes are a bit mixed up and you no longer need the ID as it won't be referenced in JavaScript. Something like: - "<input type='hidden' name='partscount" + serialno + "' value='" + count + "'>";
an then in the parts function what needs to be removed?
Any reference to partslist, so in that code snippet, lines 11/12 and 21/22.
The quotes are a bit mixed up and you no longer need the ID as it won't be referenced in JavaScript. Something like:
- "<input type='hidden' name='partscount" + serialno + "' value='" + count + "'>";
Any reference to partslist, so in that code snippet, lines 11/12 and 21/22.
Hey Acoder,
Alrighty i did everything you said. i am not sure if there is anything else to it, but for now i am still stuck on the same problem an i can not add parts right now.
Thank you,
Rach
If you can't add parts, that means there must be some error in the addpartInput function. Have you had a look at the error console?
If you can't add parts, that means there must be some error in the addpartInput function. Have you had a look at the error console?
Hey Acoder,
The error it gives me is it says avalue has no properties An i know it has to do with partscount but not sure what to replace it with. - <script type="text/javascript">
-
<!---Adds multiple fields for parts --->
-
function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
var getparts = document.getElementById('div');
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partscount"+serialno);
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partdiv = document.createElement('div');
-
var partIdName = 'part' + count + 'Name' + serialno;
-
-
partdiv.setAttribute('id',partIdName);
Thank you,
Rach
I see. You will need to add an input field for each serial that holds the part count. You have one "theValue" for serial count. For parts counts, add one in the HTML for each serial. You could call it "partcounter"+serial no. Then replace "partscount" on line 7 with "partcounter".
I see. You will need to add an input field for each serial that holds the part count. You have one "theValue" for serial count. For parts counts, add one in the HTML for each serial. You could call it "partcounter"+serial no. Then replace "partscount" on line 7 with "partcounter".
Hey Acoder,
Ok i replaced the one part in the javascript with partcounter. an then i created this for the hidden field but i am pretty sure i did something wrong because still not right. -
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="theValue" id="theValue" />
-
<input type="hidden" value="<cfoutput>#count#</cfoutput>" name="partcounter" id="partcounter" />
parts function - function addpartInput(partName){
-
var parts = document.getElementById(partName);
-
var getparts = document.getElementById('div');
-
var serialno = partName.replace("dynamic","").replace("Input","");
-
var avalue = document.getElementById("partcounter"+serialno);
-
var count = parseInt(avalue.value) + 1;
-
avalue.value = count;
-
var partdiv = document.createElement('div');
-
var partIdName = 'part' + count + 'Name' + serialno;
Thank you,
Rach
It wouldn't go there. It would have to go in the serial div - one for each serial. Also, it would have to be named "partcounter1", "partcounter2", etc. depending on the number of the serial. You would also need to add this field to the addInput function.
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: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
| |
