469,280 Members | 1,818 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,280 developers. It's quick & easy.

Insert Multiple Parts Problem

769 512MB
Hey Everyone,

Well recently i been inserting multiple fields for a section in my form called "serial". Well now i am trying to insert multiple fields for the not only the serial section but also the parts section an i seem to be having trouble.

When i try to insert into the parts section i get the error Invalid character value for cast specification. But not sure what i am doing wrong. Here is what i am using to insert. All the sections below work except the.Inserts parts information into parts table section.

Expand|Select|Wrap|Line Numbers
  1. <!---Inserts information into serial table.--->
  2. <CFIF REQUEST_METHOD EQ "POST">
  3. <CFSET machineListLen = listLen(Form.serialcount)>
  4. <CFLOOP from="1" to="#machineListLen#" index="machineCount">
  5.  <CFSET serialnum       = Form["serialnum_" & machineCount]>
  6.  <CFSET modelno         = Form["modelno_" & machineCount]>
  7.  <CFSET producttype     = Form["producttype_" & machineCount]>
  8.  <CFSET softhardware    = Form["softhardware_" & machineCount]>
  9.  <CFSET resolution      = Form["resolution_" & machineCount]>
  10.  <CFSET resdate         = Form["resdate_" & machineCount]>
  11.  <CFSET resvertified    = Form["resvertified_" & machineCount]>
  12.  <CFSET vertifidate     = Form["vertifidate_" & machineCount]>
  13.  <CFSET deptvendor      = Form["deptvendor_" & machinecount]>
  14.  <CFSET hardwarefailure = Form["hardwarefailure_" & machineCount]>
  15.  <CFSET rma             = Form["rma_" & machineCount]>
  16.  <CFSET thedescription  = Form["thedescription_" & machineCount]>
  17.  <CFSET hcpn            = Form["hcpn_" & machineCount]>
  18.  <CFSET partsreturn     = Form["partsreturn_" & machineCount]>
  19.  <CFSET defective       = Form["defective_" & machineCount]>
  20. <!--- <CFSET followdate      = Form["followdate_" & machineCount]>
  21.  <CFSET onsite          = Form["onsite_" & machineCount]>
  22.  <CFSET numonsite       = Form["numonsite_" & machineCount]>--->
  23.  
  24. <cfquery name="serial" datasource="CustomerSupport">
  25.    exec usp_CS_Insertserial 
  26.      <cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
  27.      '#Form.ID#',
  28.      <cfqueryparam value="#modelno#" CFSQLType = "CF_SQL_VARCHAR">,
  29.      <cfqueryparam value="#producttype#" CFSQLType = "CF_SQL_VARCHAR">,
  30.      <cfqueryparam value="#softhardware#" CFSQLType = "CF_SQL_VARCHAR">,
  31.      <cfqueryparam value="#resolution#" CFSQLType = "CF_SQL_VARCHAR">,
  32.      <cfqueryparam value="#resdate#">,
  33.      <cfqueryparam value="#resvertified#" CFSQLType = "CF_SQL_VARCHAR">,
  34.      <cfqueryparam value="#vertifidate#">,
  35.      <cfqueryparam value="#deptvendor#" CFSQLType = "CF_SQL_VARCHAR">,
  36.      <cfqueryparam value="#hardwarefailure#" CFSQLType = "CF_SQL_VARCHAR">,
  37.      <cfqueryparam value="#rma#" CFSQLType = "CF_SQL_VARCHAR">
  38.    </cfquery>
  39.  
  40. <!---Inserts information into notes_descr table.--->
  41. <cfquery name="description" datasource="CustomerSupport">
  42.     exec usp_CS_Insertdescription
  43.    <cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
  44.    '#Form.ID#',
  45.    <cfqueryparam value="#thedescription#" CFSQLType = "CF_SQL_VARCHAR">,
  46.    '#Form.fk_addedBy#'
  47. </cfquery>
  48.  
  49. <!---Inserts parts information into parts table.--->
  50. <!---because it is a bit we don't use 'ticks' around defective for parts table--->
  51. <cfquery name="parts" datasource="CustomerSupport">
  52.     exec usp_CS_Insertparts
  53.     <cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
  54.     '#Form.ID#',
  55.     <cfqueryparam value="#hcpn#" CFSQLType = "CF_SQL_VARCHAR">,
  56.     <cfqueryparam value="#partsreturn#" CFSQLType = "CF_SQL_VARCHAR">,
  57.     <cfqueryparam value="#defective#" CFSQLType = "CF_SQL_BIT">
  58. <!---    <cfquery param value="#submission#" CFSQLType = "CF_SQL_VARCHAR">--->
  59. </cfquery>
  60.  
  61. </CFLOOP>
  62. </CFIF>
  63.  

here is the multiple fields section in my form for the serial section.

Expand|Select|Wrap|Line Numbers
  1. <!---Allows us to add serial information multiple times --->
  2. <script type="text/javascript">
  3. <!---Allows us to add multiple fields --->
  4. function addInput(divName){
  5. var dynamic = document.getElementById('dynamicInput');
  6. var thevalue = document.getElementById('theValue');
  7. var count = (document.getElementById('theValue').value -1)+ 2;
  8. thevalue.value = count;
  9. var newdiv = document.createElement('div');
  10. var getparts = document.createElement('div');
  11. var divIdName = 'dynamic'+count+'Input';
  12. var partc = 'partscount'+count;
  13.  
  14. newdiv.setAttribute('id',divIdName);
  15.  
  16. <!--- Adds Extra fields for Model No, Product Type, and Type of Hardware Failure  --->
  17. newdiv.innerHTML =
  18. "<table class='zpExpandedTable' id='modeltable'>" +
  19. "<th class='sectiontitletick' colspan='7'>Serial Information "+ count +" </th>" +
  20. "<tr>" +
  21. "<td id='paddingformultitop'>Model No:&nbsp;&nbsp;&nbsp;&nbsp;</td>" +
  22. "</td>" +
  23. "<td>" +
  24.  "<select name='modelno_" + count + "' >" +
  25.  "<option value=''>Make A Selection</option>" +
  26. "<cfoutput query='models'>" + 
  27. "<option value='#model#'>#model#</option>" + 
  28. "</cfoutput>" + 
  29.  "</select>" +
  30.  "</td>" +
  31.  "<td>" +
  32. "&nbsp;&nbsp;&nbsp;&nbsp;Product Type:"  +
  33. "</td>" +
  34. "<td>" +
  35. "<select name='producttype_" + count + "'>" +
  36. "<option value='' selected>No Choice</option>" +
  37. "<cfoutput query='getProdType'>" + 
  38. "<option value='#pk_productType#'>#pk_productType#</option>" + 
  39. "</cfoutput>" + 
  40. "</select>" +
  41. "</td>" +
  42. "<td class='red'>" +
  43. "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Type Of Hardware Failure*:" +
  44. "</td>" +
  45. "<td>" +
  46. "<select name='hardwarefailure_" + count + "'>" +
  47. "<option value='' selected>Make A Selection</option>" +
  48. "<cfoutput query='getHardwareFail'>" +
  49. "<option value='#pk_hardwareFailure#'>#pk_hardwareFailure#</option>" +
  50. "</cfoutput>" +
  51. "</select>" +
  52. "</td>" +
  53. "</tr>" +
  54. "<table>";
  55.  
  56. <!--- Adds Extra fields for Serial Number and Software/Hardware  --->
  57. newdiv.innerHTML = newdiv.innerHTML +
  58. "<table class='zpExpandedTable' id='modeltable'>" +
  59. "<tr>" +
  60. "<td id='paddingformultitop'>" +
  61. "Serial Number:&nbsp;&nbsp;" +
  62. "<input type='text' name='serialnum_" + count + "'>" +
  63. "&nbsp;&nbsp;&nbsp;&nbsp;Software/Hardware:&nbsp;&nbsp;" +
  64. "<select name='softhardware_" + count + "'>" +
  65. "<option value='' selected>No Choice</option>" +
  66. "<cfoutput query='getSoftHard'>" + 
  67. "<option value='#pk_softwareHardware#'>#pk_softwareHardware#</option>" + 
  68. "</cfoutput>" + 
  69. "</select>" +
  70. "</td>" +
  71. "</tr>" +
  72. "</table>";
  73.  
  74. <!--- Adds Extra fields for Description  --->
  75. newdiv.innerHTML = newdiv.innerHTML + 
  76. "<table class='zpExpandedTable' id='resoltable' cellpadding='3' cellspacing='0'>" +
  77. "<tr>" +
  78. "<td id='paddingformutli'>" +
  79. "Description:&nbsp;&nbsp;" + 
  80. "</td>" +
  81. "<td class='descriptionmoveinmulti'>" +
  82. "( You may enter up to 1000 characters. )"+
  83. "<br>" +
  84. "<textarea maxlength='1000' onkeyup='return descriptionmaxlength(this)' onkeydown='return descriptionmaxlength(this)'rows='4' cols='60' name='thedescription_" + count + "'></textarea>" +
  85. "</td>" +
  86. "</tr>" +
  87. "</table>";
  88.  
  89. <!--- Adds Extra fields for Resolution  --->
  90. newdiv.innerHTML = newdiv.innerHTML +
  91. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  92. "<tr>" +
  93. "<td id='paddingformutli'>" +
  94. "Resolution:&nbsp;&nbsp;" +
  95. "</td>" +
  96. "<td class='resolutionmoveinmulti'>" +
  97. "( You may enter up to 1500 characters. )"+
  98. "<br>" +
  99. "<textarea maxlength='1500' onkeyup='return resolutionmaxlength(this)' onkeydown='return resolutionmaxlength(this)' rows='4' cols='60' name='resolution_" + count + "'></textarea>" +
  100. "</td>" +
  101. "</tr>" +
  102. "</table>";
  103.  
  104. <!--- Adds Extra fields for Resolution Date, Current Date (for resolution date) and resolution vertified as effective by  --->
  105. newdiv.innerHTML = newdiv.innerHTML +
  106. "<table class='zpExpandedTable' id='resoldatetab' cellpadding='1' cellspacing='0'>" +
  107. "<tr>" +
  108. "<td id='paddingformultitop'>" +
  109. "Resolution Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;" +
  110. "</td>" +
  111. "<td>" +
  112. "<input type='text' name='resdate_" + count + "' value=''  >&nbsp;&nbsp;" +
  113.  
  114. "&nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;" +
  115. "<input type='checkbox' name='currentdateresol_" + count + "' onClick=resdate_" + count + ".value=fill_date()>" +
  116. "</td>" +
  117. "<td>" +
  118. "Resolution Verified as effective by:&nbsp;&nbsp;"  +
  119. "</td>" +
  120. "<td>" +
  121. "<select name='resvertified_" + count + "'>" +
  122. "<option value='' selected>Make A Selection</option>" +
  123. "<cfoutput query='gettech'><option value='#fname# #lname#'>#fname# #lname#</option></cfoutput>" +
  124. "</select>" +
  125. "</td>" +
  126. "</tr>" +
  127. "</table>";
  128.  
  129. <!--- Adds Extra fields for Vertification Date, Current Date (for vertification date) and resolution vertified as effective by  --->
  130. newdiv.innerHTML = newdiv.innerHTML +
  131. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  132. "<tr>" +
  133. "<td id='paddingformultitop'>" +
  134. "Verification Date:&nbsp;(MM/DD/YYYY)&nbsp;&nbsp;" +
  135. "</td>" +
  136. "<td class='vertificationmoveinmulti'>" +
  137. "<input type='text' name='vertifidate_" + count + "'>&nbsp;&nbsp;" +
  138. "&nbsp;&nbsp;&nbsp;&nbsp;Current Date:&nbsp;&nbsp;" +
  139. "<input type='checkbox' name='currentdatevert_" + count + "' onClick=vertifidate_" + count + ".value=fill_date()>" +
  140. "</td>" +
  141. "</tr>" +
  142. "</table>";
  143.  
  144. <!--- Adds Extra fields for Dept/Vendor Responsibility  --->
  145. newdiv.innerHTML = newdiv.innerHTML +
  146. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  147. "<tr>" +
  148. "<td class='red' id='paddingformultitop'>" +
  149. "Dept/Vendor Responsibility*:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"  +
  150. "<select name='deptvendor_" + count + "'>" +
  151. "<option value='' selected>Make A Selection</option>" +
  152. "<cfoutput query='getDeptVendor'>" +
  153. "<option value='#pk_deptVendor#'>#pk_deptVendor#</option>" +
  154. " </cfoutput>" +
  155. "</select>" +
  156. "</td>" +
  157. "</tr>" +
  158. "</table>";
  159.  
  160. <!--- Adds Extra fields for RMA Data Only  --->
  161. newdiv.innerHTML = newdiv.innerHTML +
  162. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  163. "<tr>" +
  164. "<td id='paddingformultitop'>" +
  165. "RMA Data Only:&nbsp;&nbsp;&nbsp;&nbsp;" +
  166. "</td>" +
  167. "<td class='rmanmoveinmulti'>" +
  168. "( You may enter up to 1000 characters. )"+
  169. "<br/>" +
  170. "<textarea maxlength='1000' onkeyup='return rmamaxlength(this)' onkeydown='return rmamaxlength(this)' rows='4' cols='60' name='rma_" + count + "'></textarea> " +
  171. "</td>" +
  172. "</tr>" +
  173. "</table>" +
  174. "<input type='hidden' value='0' id='"+partc+"' \>" +
  175. "<input type='hidden' name='serialcount' value='" + count + "'>";
  176.  
  177. <!--- Adds Delete to every ticket  --->
  178. newdiv.innerHTML = newdiv.innerHTML +
  179. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  180. "<tr>" +
  181. "<td>" +
  182. "<input type='button' class='removeticket' value='Remove Serial &quot;"+ count +"&quot;' onclick=\"removeElement(\'"+divIdName+"\')\"></a>" +
  183. "</td>" +
  184. "</tr>" +
  185. "<tr>" +
  186. "<td>" + 
  187. "<input type='button' class='addticket' value='Add Parts' onclick=\"addpartInput(\'"+divIdName+"\')\">" +
  188. "</td>" +
  189. "</tr>" +
  190. "</table>";
  191.  
  192. document.getElementById(divName).appendChild(newdiv);
  193.  
  194. <!---Allows us to remove multiple fields --->
  195. function removeElement(divNum) {
  196.   var d = document.getElementById('dynamicInput');
  197.   var olddiv = document.getElementById(divNum);
  198.   d.removeChild(olddiv);
  199. }
  200. </script>
here is the multiple field section for the parts section

Expand|Select|Wrap|Line Numbers
  1. <!---Allows us to add PARTS information multiple times--->
  2. <script type="text/javascript">
  3. <!---Adds multiple fields for parts --->
  4. function addpartInput(partName){
  5. var parts = document.getElementById(partName);
  6. var getparts = document.getElementById('div');
  7. var serialno = partName.replace("dynamic","").replace("Input","");
  8. var avalue = document.getElementById("partscount"+serialno);
  9. var count = parseInt(avalue.value) + 1;
  10. avalue.value = count;
  11. var partdiv = document.createElement('div');
  12. var partIdName = 'part' + count + 'Name' + serialno;
  13.  
  14. partdiv.setAttribute('id',partIdName);
  15.  
  16. <!--- Adds Extra fields for parts table  --->
  17. partdiv.innerHTML =
  18. <!---what used originally for this tableclass='createticketables' id='spaceup'--->
  19. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0' >" +
  20. "<th class='sectiontitle' colspan='7'>Parts Information "+ count +" Serial Information "+serialno+"</th>" +
  21. "<tr>" +
  22. "<td class='indent' id='formfieldpadding'>HC P/N:&nbsp;&nbsp;&nbsp;<input type='text' name='hcpn_" + count + "' style='margin:0px'></td>" +
  23. "<td class='red'>" +
  24. "Parts been returned* " +
  25. "<input type='checkbox' name='partsreturn_" + count +"' value='1'/>" +
  26. "</td>" +
  27. "<td>" +
  28. "<td class='indent'>Defective<input type='checkbox' name='defective_" + count +"' value='1'/></td>" +
  29. "</td>" +
  30. "</tr>" +
  31. "</table>" +
  32. "<table table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'  >" +
  33. "<tr>" +
  34. "<td class='indent' id='formfieldpadding'>Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;"  +
  35. "<input type='text' name='followdate_" + count + "' value='' size='8'/>&nbsp;&nbsp;&nbsp;" +
  36. "Current Date<input type='checkbox' name='followcheck_"+ count +"' value='' onClick='followdate.value=fill_date()'/></td>" +
  37. "<td>On Site:</td>" +
  38. "<td><select name='onsite_" + count +"'>" +
  39. "<option value='No Choice' selected>No Choice</option>" +
  40. "<option value='Yes'>Yes</option>" +
  41. "<option value='No'>No</option>" +
  42. "</select><td>" +
  43. "<td># of Onsite:</td><td><select name='numonsite_" + count +"'>" +
  44. "<option value='' selected>No Choice</option>" +
  45. "<cfloop from='0' to='10' index='nonsite'><cfoutput>" +
  46. "<option value='#nonsite#'>#nonsite#</option></cfoutput></cfloop>" +
  47. "</select><td>" +
  48. "</tr>" +
  49. "</table>" +
  50. <!---"<input type='hidden' value='0' id='aValue' />" +--->
  51. "<input type='hidden' name='serialcount' value='" + count + "'>";
  52.  
  53.  
  54. <!--- Adds Delete to every ticket  --->
  55. partdiv.innerHTML = partdiv.innerHTML +
  56. "<table class='zpExpandedTable' id='resoltable' cellpadding='1' cellspacing='0'>" +
  57. "<tr>" +
  58. "<td>" +
  59. "<input type='button' class='removeticket' value='Remove Parts &quot;"+count +"&quot;' onclick=\"removetheElement(\'"+partIdName+"\')\"></a>" +
  60. "</td>" +
  61. "</td>" +
  62. "</tr>" +
  63. "</table>";
  64.  
  65. document.getElementById(partName).appendChild(partdiv);
  66.  
  67. <!---Allows us to remove multiple fields--->
  68. function removetheElement(divNum) {
  69.   var d = document.getElementById('partsInput');
  70.   var olddiv = document.getElementById(divNum);
  71.  olddiv.parentNode.removeChild(olddiv);
  72. }
  73.  
  74. </script>
Thank you in advance,

Rach
Oct 14 '08
58 7057
bonneylake
769 512MB
If you're going to put machinecount in the string, then wrap it in #s or take it out of the string like ps.
Hey Acoder,

I think i might have to do it the way you aid with the ps because i got this

Error Diagnostic Information

An error occurred while evaluating the expression:

partsreturn = Form["partsreturn_" & ps & "_#machinecount#"]

Error near line 94, column 8.

The member "PARTSRETURN_1_2" in dimension 1 of object "Form" cannot be found. Please, modify the member name.

an this is what i have
Expand|Select|Wrap|Line Numbers
  1. <cfloop from="1" to="#form['partscount' & machinecount]#" index="ps">
  2.  <CFSET hcpn            = Form["hcpn_" & ps & "_#machinecount#"]>
  3.  <CFSET partsreturn     = Form["partsreturn_" & ps & "_#machinecount#"]>
  4.  <CFSET defective       = Form["defective_" & ps & "_#machinecount#"]>
  5. <cfquery name="parts" datasource="CustomerSupport">
  6.     exec usp_CS_Insertparts
  7.     <cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
  8.     '#Form.ID#',
  9.     <cfqueryparam value="#hcpn#" CFSQLType = "CF_SQL_VARCHAR">,
  10.     <cfqueryparam value="#partsreturn#" CFSQLType = "CF_SQL_VARCHAR">,
  11.     <cfqueryparam value="#defective#" CFSQLType = "CF_SQL_BIT">,
  12.    '#Form.submission#'
  13. </cfquery>
  14. </cfloop>
  15.  
but if i was going to do it the other way would i create another cfloop or would i do something like a cfset?

Thank you,
Rach
Oct 16 '08 #51
acoder
16,027 Expert Mod 8TB
No, what you have is correct, though the alternative would be:
Expand|Select|Wrap|Line Numbers
  1. Form["partsreturn_" & ps & "_" & machinecount]
From the error message, it seems that hcpn is OK, but partsreturn isn't. Check again what the field names/values being passed are.
Oct 16 '08 #52
bonneylake
769 512MB
No, what you have is correct, though the alternative would be:
Expand|Select|Wrap|Line Numbers
  1. Form["partsreturn_" & ps & "_" & machinecount]
From the error message, it seems that hcpn is OK, but partsreturn isn't. Check again what the field names/values being passed are.
Hey Acoder,

Well checked the name for partsreturn an made sure they all match an they do. But i think i know what the problem is. Well when i been testing, for the part i add with the first serial i choose everything. But for the second serial and the first part for it i choose nothing for partsreturn and defective. An it says cant find the object so think its because i am leaving it blank. But thing is i have the following lines in there in case someone does leave it blank

Expand|Select|Wrap|Line Numbers
  1. <cfparam name="Form.defective" default="0">
  2. <cfparam name="Form.partsreturn" default="0">
an here is the line its having the problem with

Expand|Select|Wrap|Line Numbers
  1.  <CFSET partsreturn     = Form["partsreturn_" & ps & "_#machinecount#"]>
Any ideas?

Thank you,
Rach
Oct 16 '08 #53
acoder
16,027 Expert Mod 8TB
Well, the cfparam doesn't account for the new names. You need to use two cfloops and cfparam all possible part fields. What you could do is put the cfparam just before the cfsets in the second loop.
Oct 16 '08 #54
bonneylake
769 512MB
Well, the cfparam doesn't account for the new names. You need to use two cfloops and cfparam all possible part fields. What you could do is put the cfparam just before the cfsets in the second loop.
Hey Acoder,

i get the same error. i dont know if this help but it also says

The member "PARTSRETURN_1_2" in dimension 1 of object "Form" cannot be found. Please, modify the member name.

Expand|Select|Wrap|Line Numbers
  1. <cfloop from="1" to="#form['partscount' & machinecount]#" index="ps">
  2. <cfparam name="Form.defective" default="0">
  3. <cfparam name="Form.partsreturn" default="0">
  4.  <CFSET hcpn            = Form["hcpn_" & ps & "_#machinecount#"]>
  5.  <CFSET partsreturn     = Form["partsreturn_" & ps & "_#machinecount#"]>
  6.  <CFSET defective       = Form["defective_" & ps & "_#machinecount#"]>
  7. <cfquery name="parts" datasource="CustomerSupport">
  8.     exec usp_CS_Insertparts
  9.     <cfqueryparam value="#serialnum#" CFSQLType = "CF_SQL_VARCHAR">,
  10.     '#Form.ID#',
  11.     <cfqueryparam value="#hcpn#" CFSQLType = "CF_SQL_VARCHAR">,
  12.     <cfqueryparam value="#partsreturn#" CFSQLType = "CF_SQL_VARCHAR">,
  13.     <cfqueryparam value="#defective#" CFSQLType = "CF_SQL_BIT">,
  14.    '#Form.submission#'
  15. </cfquery>
  16. </cfloop>
Thank you,
Rach
Oct 16 '08 #55
acoder
16,027 Expert Mod 8TB
You can't set only form.partsreturn and form.defective. You need to set the correct name similar to what you have in the cfset: form.partsreturn_#ps#_#machinecount#
Oct 16 '08 #56
bonneylake
769 512MB
You can't set only form.partsreturn and form.defective. You need to set the correct name similar to what you have in the cfset: form.partsreturn_#ps#_#machinecount#
Hey Acoder,

It worked!!! Thank you, Thank you!!! But i have another question, if i have questions about printing the in formation, like viewing what was previously entered for parts do i need to create another thread for that? because having a hard time viewing what was previously entered.

Thank you so much for all the help!!!!!!!!! :)
Rach
Oct 16 '08 #57
acoder
16,027 Expert Mod 8TB
i have another question, if i have questions about printing the in formation, like viewing what was previously entered for parts do i need to create another thread for that? because having a hard time viewing what was previously entered.
Yes, you should create another thread for that problem.
Thank you so much for all the help!!!!!!!!! :)
You're very welcome! I'm glad it's now working.
Oct 16 '08 #58
bonneylake
769 512MB
Yes, you should create another thread for that problem.

You're very welcome! I'm glad it's now working.
Hey Acoder,

i created another thread and here is the thread i started in case anyone is interested.

http://bytes.com/forum/showthread.ph...83#post3390883

but thank you again for all the help :),
Rach
Oct 16 '08 #59

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Graham | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.