Rachel,
While this is helpful, can you add a <cfdump var="#form#"> to the top of
userform.cfm? Then submit your form with multiple entries, and copy and
paste the cfdump results into a message for us to examine.
Thanks,
Carl
Rachel B wrote:
> Here is the form i am working with.
>
> <!--- Adds Multiple Ticket fields --->
> <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 divIdName = 'dynamic'+count+'Input';
> newdiv.setAttribute('id',divIdName);
>
> <!--- Adds Extra fields for Model No, Product Type, and Type of Hardware
> Failure --->
> newdiv.innerHTML =
> "<table class='zpExpandedTable' id='modeltable'>" +
> "<th class='sectiontitletick' colspan='7'>Serial Information "+ count +"
> </th>" +
> "<tr>" +
> "<td id='paddingformultitop'>Model No: </td>" +
> "</td>" +
> "<td>" +
> "<select name='modelno' >" +
> "<option value=''>Make A Selection</option>" +
> "<option value='Test'>Test</option>"+
> "</select>" +
> "</td>" +
> "<td>" +
> " Product Type:" +
> "</td>" +
> "<td>" +
> "<select name='producttype'>" +
> "<option value='' selected>No Choice</option>" +
> "<cfoutput query='getProdType'>" +
> "<option value='#pk_productType#'>#pk_productType#</option>" +
> "</cfoutput>" +
> "</select>" +
> "</td>" +
> "<td class='red'>" +
> " Type
> Of Hardware Failure*:" +
> "</td>" +
> "<td>" +
> "<select name='hardwarefailure'>" +
> "<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'>" +
> " Software/Hardware: " +
> "<input type='text' name='softhardware'>" +
> "</td>" +
> "</tr>" +
> "</table>";
>
> <!--- Adds Extra fields for Description --->
> newdiv.innerHTML = newdiv.innerHTML +
> "<table class='zpExpandedTable' id='resoltable' cellpadding='3'
> cellspacing='0'>" +
> "<tr>" +
> "<td id='paddingformutli'>" +
> "Description: " +
> "</td>" +
> "<td class='descriptionmoveinmulti'>" +
> "( You may enter up to 500 characters. )"+
> "<br>" +
> "<textarea maxlength='500' onkeyup='return ismaxlength(this)'
> onkeydown='return ismaxlength(this)'rows='4' cols='60'
> name='description'></textarea>" +
> "</td>" +
> "</tr>" +
> "</table>";
>
> <!--- Adds Extra fields for Resolution --->
> newdiv.innerHTML = newdiv.innerHTML +
> "<table class='zpExpandedTable' id='resoltable' cellpadding='1'
> cellspacing='0'>" +
> "<tr>" +
> "<td id='paddingformutli'>" +
> "Resolution: " +
> "</td>" +
> "<td class='resolutionmoveinmulti'>" +
> "( You may enter up to 500 characters. )"+
> "<br>" +
> "<textarea maxlength='500' onkeyup='return ismaxlength(this)'
> onkeydown='return ismaxlength(this)' rows='4' cols='60'
> name='resolution'></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' value='' > " +
>
> " Current Date: " +
> "<input type='checkbox' name='currentdateresol' id='currentresdate'
> onClick=resdate.value=fill_date()>" +
> "</td>" +
> "<td>" +
> "Resolution Verified as effective by: " +
> "</td>" +
> "<td>" +
> "<select name='resvertified'>" +
> "<option value=''>Make A Selection</option>" +
> "</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'> " +
> " Current Date: " +
> "<input type='checkbox' name='currentdatevert'
> onClick=vertifidate.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'>" +
> "<option value='' selected>Make A Selection</option>" +
> "<cfoutput query='getDeptVendor'>" +
> "<option value='#pk_deptVendor#'>#pk_deptVendor#</option>" +
> " </cfoutput>" +
> "</select>" +
> "</td>" +
> "</tr>" +
> "</table>";
>
> <!--- Adds Extra fields for RMA Data Only --->
> newdiv.innerHTML = newdiv.innerHTML +
> "<table class='zpExpandedTable' id='resoltable' cellpadding='1'
> cellspacing='0'>" +
> "<tr>" +
> "<td id='paddingformultitop'>" +
> "RMA Data Only: " +
> "</td>" +
> "<td class='rmanmoveinmulti'>" +
> "( You may enter up to 500 characters. )"+
> "<br/>" +
> "<textarea maxlength='500' onkeyup='return ismaxlength(this)'
> onkeydown='return ismaxlength(this)' rows='4' cols='60'
> name='rma'></textarea> " +
> "</td>" +
> "</tr>" +
> "</table>";
>
> <!--- Adds Delete to every ticket --->
> newdiv.innerHTML = newdiv.innerHTML +
> "<table class='zpExpandedTable' id='resoltable' cellpadding='1'
> cellspacing='0'>" +
> "<tr>" +
> "<td>" +
> "<input type='button' class='removeticket' value='Remove Serial ""+count
> +""' onclick=\"removeElement(\'"+divIdName+"\')\"></a>" +
> "</td>" +
> "</td>" +
> "</tr>" +
> "</table>";
>
> document.getElementById(divName).appendChild(newdiv);
> }
>
> <!---Allows us to remove multiple fields --->
> function removeElement(divNum) {
> var d = document.getElementById('dynamicInput');
> var olddiv = document.getElementById(divNum);
> d.removeChild(olddiv);
> }
>
> </script>
>
> <form action="userform.cfm" id="userForm" name="userForm" method="POST" >
> <div action="javascript:get(document.getElementById('updateform1'));"
> name="updateform1" id="updateform1" onButton="return formvalidate()" >
> <input type="hidden" name="ID" id="ID" value="#insertticketmaster.ID#" />
> <input type="hidden" value="0" id="theValue" />
> <div id="dynamicInput">
> <!--- All Ticket Information thats in javascript Appears Here--->
> </div>
> <input type="button" class="addticket" value="Add Serial"
> onClick="addInput('dynamicInput');">
> <input type="submit" class="officalsubmit" value="Submit" onClick="return
> validate_form();">
> </form>
>
> Alrighty well here is my form. I know its a lot an its messy. which sorry its
> a mess, just only way i was able to accomplish what i am doing.
>
> But let me explain it. All the javascript does is add the remove multiple
> fields.As you will see all of my fields that go into the form are in the
> javascript. Basically what i am doing is when i click add serial i am able to
> add multiple forms to fill in. In this case if a customer calls an they are
> having problems with multiple computers they need to be able to fill out
> multiple serials an it all go under one ticket (they will adventually be able
> to go back an look at all the information to make updates on how the
> customers product is doing an such), which that part works great an no
> problem. When you get to the form part you will see it posts to another file
> which is all my database stuff that i posted earlyer.
>
> Basically the problem i am having is once i click submit an all that
> information goes into the database is when i have the problem. i have no
> problems if i add only one serial, but if i try to add 2 or more is when i
> run into the problem. With the counter, it seems whatever i write to the
> first serial ends up being applied to the second serial instead of what i
> original put in the second serial.
> An i also know i am going to eventually run into another problem. If i fill
> in 3 serials an lets say i did it this way where i have
> serial no: 123 ticket no: 5 model_no: test
> serial no: 456 ticket no: 5 model_no:
> serial no: 789 ticket no: 5 model_no; test 2
>
> if i don't have a value in model_no for serial 456. the model no for 789 will
> go into serial 456 and the serial no 789 model no will have no value. I am
> still trying to figure out this problem as well. i have thought about putting
> a default value in my database, by modifying my table an setting a default
> value, but when i tried that for some reason it is not putting it into my
> table, i probably did something wrong. An i have also thought about putting a
> default value in my stored procedure an well when i did that it put the value
> i assigned an the default value, which is no good.
>
> But sorry this is so long an thank you for all your help i really do
> appreciate it.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309144
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
