469,366 Members | 2,251 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

URL Method for 3 tables?

769 512MB
Hey Everyone,

i been working on trying to understand the URL method of retrieving information for the last week, but i am stuck. I been able to get one table of information, but now i need to get 3 tables of information at the same time an i am running into trouble. Each table has a number in common with the other, each has a field that holds the number (but fields have different name). For example ticketMaster table has the field pk_ticketID which holds the number 1, serial has the field pkb_fk_ticketNo which holds the number 1, and parts has the field fk_ticketNo which holds the number 1. Right now i can get the correct table information for ticketMaster but for the serial an parts i get all the records that are in those tables instead of just the one record needed, which in this case is the one record that holds the number 1.

Right now here is what i have


Expand|Select|Wrap|Line Numbers
  1.  <!---Shows what was previously entered into table ticketmaster--->
  2. <cfquery name="ticket" datasource="CustomerSupport">
  3.  SELECT pk_ticketID,title,priority,status,
  4. cost_center,fk_customer_number,
  5. customer_company,customer_Fname,customer_Lname,
  6. customer_add1,customer_city,customer_state,
  7. customer_zip,customer_email,customer_pri_phone,
  8. customer_sec_phone,customer_notes,htpp FROM dbo.tbl_CS_ticketMaster
  9. WHERE pk_ticketID = #URL.pk_ticketID#
  10. </cfquery>
  11.  
  12. <cfquery name="serial" datasource="CustomerSupport">
  13. SELECT pka_serialNo,pkb_fk_ticketNo,model_no,product_type ,
  14. software_hardware,resolution,resolution_date,
  15. verification_date,rma_data,
  16. type_hardware_failure,dept_responsibility,resoluti on_verified_by FROM dbo.tbl_CS_serial
  17. </cfquery>
  18.  
  19. <cfquery name="parts" datasource="CustomerSupport">
  20. SELECT pk_partID,fk_serialNo,fk_ticketNo,hc_partNo,
  21. part_returned,defective,submission
  22. FROM dbo.tbl_CS_parts
  23. </cfquery>
  24.  
  25. <form name="page1" id="page1" action="saveticket1edit.cfm?<cfoutput query="ticket">pk_ticketID=#pk_ticketID#</cfoutput><cfoutput query="serial">&pkb_fk_ticketNo=#pkb_fk_ticketNo#</cfoutput><cfoutput query="parts">&fk_ticketNo=#fk_ticketNo#</cfoutput>"
  26.  method="POST" onSubmit="return validate_form();">
  27. </form>
if anyone could explain to me how to get the url method to work with 3 fields in 3 different tables i would really appreciate it.

Thank you in advance,
Rach
Sep 22 '08
107 7614
acoder
16,027 Expert Mod 8TB
I meant the exact same call, i.e.
Expand|Select|Wrap|Line Numbers
  1. <cfinclude template="serialdisplay.cfm">
Sep 29 '08 #51
bonneylake
769 512MB
I meant the exact same call, i.e.
Expand|Select|Wrap|Line Numbers
  1. <cfinclude template="serialdisplay.cfm">
Hey Acoder,

i am lost by what you mean. do you mean copy what i have above into the serialdisplay.cfm?

Thank you,
Rach
Sep 29 '08 #52
acoder
16,027 Expert Mod 8TB
I mean here:
Expand|Select|Wrap|Line Numbers
  1. <cfif serial.recordcount is 0>
  2. <cfset model_no = "">
  3. <cfset product_type = "">
  4. <cfset type_hardware_failure = "">
  5. <cfset pka_serialNo = "">
  6. <cfset software_hardware = "">
  7. <cfset description = "">
  8. <cfset resolution = "">
  9. <cfset resolution_date = "">
  10. <cfset resolution_verified_by = "">
  11. <cfset verification_date = "">
  12. <cfset dept_responsibility = "">
  13. <cfset rma_data = "">
  14. <cfinclude template="serialdisplay.cfm">
  15. </cfif>
  16.  
Sep 29 '08 #53
bonneylake
769 512MB
Hey Acoder,

ok here is what i got.what needs to happen next?

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="serial">
  2. <cfset model_no = #model_no#>
  3. <cfset product_type = #product_type#>
  4. <cfset type_hardware_failure = #type_hardware_failure#>
  5. <cfset pka_serialNo = #pka_serialNo#>
  6. <cfset software_hardware = #software_hardware#>
  7. <cfset description = #description#>
  8. <cfset resolution = #resolution#>
  9. <cfset resolution_date = #resolution_date#>
  10. <cfset resolution_verified_by = #resolution_verified_by#>
  11. <cfset verification_date = #verification_date#>
  12. <cfset dept_responsibility = #dept_responsibility#>
  13. <cfset rma_data = #rma_data#>
  14. </cfoutput>
  15. <cfif serial.recordcount is 0>
  16. <cfset model_no = "">
  17. <cfset product_type = "">
  18. <cfset type_hardware_failure = "">
  19. <cfset pka_serialNo = "">
  20. <cfset software_hardware = "">
  21. <cfset description = "">
  22. <cfset resolution = "">
  23. <cfset resolution_date = "">
  24. <cfset resolution_verified_by = "">
  25. <cfset verification_date = "">
  26. <cfset dept_responsibility = "">
  27. <cfset rma_data = "">
  28. <cfinclude template="serialdisplay.cfm">
  29. </cfif>
  30.  
  31. <cfoutput query="parts">
  32. <cfset hc_partNo = #hc_partNo#>
  33. <cfset defective = #defective#>
  34. <cfset submission = #submission#>
  35. </cfoutput>
  36. <cfif parts.recordcount is 0>
  37. <cfset hc_partNo = "">
  38. <cfset defective = "">
  39. <cfset submission = "">
  40. <cfinclude template="partsdisplay.cfm">
  41. </cfif>
Thank you,
Rach
Sep 29 '08 #54
acoder
16,027 Expert Mod 8TB
Well, does it work? What happens?
Sep 29 '08 #55
bonneylake
769 512MB
Well, does it work? What happens?
Hey Acoder,

Well when i try it, it says that theres nothing in the template. Am i suppose to make a copy of what i have now an put it in the template?

Thank you,
Rach
Sep 29 '08 #56
acoder
16,027 Expert Mod 8TB
Yes, put the div "dynamic#count#Input" code in the include template.
Sep 29 '08 #57
bonneylake
769 512MB
Yes, put the div "dynamic#count#Input" code in the include template.
Hey Acoder,

The serial part works correctly (yay). But i can't get the parts page to. The parts uses 2 tables for it to display. The thing is everything from the first (ticket) table displays correctly, but everything in the parts table won't display correctly. I don't know if i need to combine them or really do what but it still wont display right. Here is what i have

here is what i have for the original parts table
Expand|Select|Wrap|Line Numbers
  1. <!--- Parts Information --->
  2. <cfoutput query="parts">
  3. <table class="createticketables" id="spaceup" >
  4. <th class="sectiontitle" colspan="7">Parts Information</th>
  5. <tr>
  6. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  7. <td class="red">
  8. Have all parts been returned*
  9. <cfset part_returned = #part_returned#>
  10. <select name="partsreturn" id="partsreturn">
  11. <option value="" selected>Make A Selection</option>
  12. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  13. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  14. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  15. </select>
  16. </td>
  17. <td>
  18. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  19. </td>
  20. </tr>
  21. </table>
  22. <table class="createticketables" >
  23. <tr>
  24. </cfoutput>
  25. <cfoutput query="ticket">
  26. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  27. <td>On Site:</td><td>
  28. <select name="onsite" id="onsite">
  29. <option value="" selected>No Choice</option>
  30.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  31.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  32. </select>
  33. <td>
  34. <td>Number of Onsite:</td><td>
  35. <select name="numonsite">
  36. <option value="" selected>No Choice</option>
  37.   <cfloop from="0" to="10" index="nonsite"><option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#</option></cfloop>
  38. </select></cfoutput><td>
  39. </tr>
  40. </table>
  41. <table class="createticketables" id="space">
  42. <tr>
  43. <td class="indent" id="formfieldpadding">Submission:
  44. <cfoutput query="parts">
  45. <select class="submissionticketbox" name="submission">
  46. <option value="" selected>Make a Selection</option>
  47.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  48.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  49.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  50. </select>
  51. </cfoutput>
  52. </td>
  53. </tr>
  54. </table>
  55. <cfoutput query="parts">
  56. <cfset hc_partNo = #hc_partNo#>
  57. <cfset defective = #defective#>
  58. <cfset submission = #submission#>
  59. </cfoutput>
  60. <cfif parts.recordcount is 0>
  61. <cfset hc_partNo = "">
  62. <cfset defective = "">
  63. <cfset submission = "">
  64. <cfinclude template="partsdisplay.cfm">
  65. </cfif>
  66.  
and here is what i have on the parts template

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <table class="createticketables" id="spaceup" >
  3. <th class="sectiontitle" colspan="7">Parts Information</th>
  4. <tr>
  5. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  6. <td class="red">
  7. Have all parts been returned*
  8. <cfset part_returned = #part_returned#>
  9. <select name="partsreturn" id="partsreturn">
  10. <option value="" selected>Make A Selection</option>
  11. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  12. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  13. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  14. </select>
  15. </td>
  16. <td>
  17. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  18. </td>
  19. </tr>
  20. </table>
  21. <table class="createticketables" >
  22. <tr>
  23. </cfoutput>
  24. <cfoutput query="parts">
  25. <select class="submissionticketbox" name="submission">
  26. <option value="" selected>Make a Selection</option>
  27.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  28.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  29.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  30. </select>
  31. </cfoutput>
Thank you,
Rach
Sep 29 '08 #58
acoder
16,027 Expert Mod 8TB
Was the parts part working before because it does look a bit of a mess with a mixture of cfoutputs?

What you should have is something similar in shape to the serials, i.e. cfset settings before the calls to cfinclude in the main file. In partsdisplay.cfm, show the table(s), but remove any cfset settings in the code (otherwise they will override what you've set in the parent file).
Sep 29 '08 #59
bonneylake
769 512MB
Hey Acoder,

For some reason i just got that part working (almost). The problem i am having now is that everything from the other table is not displaying in the entire table. Like the 3 from the ticket table is just floating around while the other 4 fields is in a table and looking nice. i tried to copy all the fields from the original file to the partsdisplay.cfm but when i do that it makes those 3 other fields appear twice. any ideas?

appears in partsdisplay.cfm
Expand|Select|Wrap|Line Numbers
  1. <!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
  2.  
  3. <cfif parts.recordcount is 0>  
  4. <cfoutput>
  5. <table class="createticketables" id="spaceup" >
  6. <th class="sectiontitle" colspan="7">Parts Information</th>
  7. <tr>
  8. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  9. <td class="red">
  10. Have all parts been returned*
  11. <select name="partsreturn" id="partsreturn">
  12. <option value="" selected>Make A Selection</option>
  13. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  14. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  15. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  16. </select>
  17. </td>
  18. <td>
  19. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  20. </td>
  21. </tr>
  22. </table>
  23. <table class="createticketables" id="space">
  24. <tr>
  25. <td class="indent" id="formfieldpadding">Submission:
  26. <select class="submissionticketbox" name="submission">
  27. <option value="" selected>Make a Selection</option>
  28.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  29.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  30.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  31. </select>
  32. </td>
  33. </tr>
  34. </table>
  35. </cfoutput>
  36. </cfif>
appears in original form
Expand|Select|Wrap|Line Numbers
  1. <!--- Parts Information --->
  2. <cfoutput query="parts">
  3. <table class="createticketables" id="spaceup" >
  4. <th class="sectiontitle" colspan="7">Parts Information</th>
  5. <tr>
  6. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  7. <td class="red">
  8. Have all parts been returned*
  9. <cfset part_returned = #part_returned#>
  10. <select name="partsreturn" id="partsreturn">
  11. <option value="" selected>Make A Selection</option>
  12. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  13. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  14. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  15. </select>
  16. </td>
  17. <td>
  18. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  19. </tr>
  20. </table>
  21. </cfoutput>
  22. <cfoutput query="ticket">
  23. <table class="createticketables" >
  24. <tr>
  25. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  26. <td>On Site:</td>
  27. <td>
  28. <select name="onsite" id="onsite">
  29. <option value="" selected>No Choice</option>
  30.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  31.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  32. </select>
  33. </td>
  34. <td>Number of Onsite:</td>
  35. <td>
  36. <select name="numonsite">
  37. <option value="" selected>No Choice</option>
  38. <cfloop from="0" to="10" index="nonsite">
  39. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  40. </option></cfloop>
  41. </select>
  42. </td>
  43. </tr>
  44. </table>
  45. </cfoutput>
  46. <cfoutput query="parts">
  47. <table class="createticketables" id="space">
  48. <tr>
  49. <td class="indent" id="formfieldpadding">Submission:
  50. <select class="submissionticketbox" name="submission">
  51. <option value="" selected>Make a Selection</option>
  52.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  53.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  54.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  55. </select>
  56. </td>
  57. </tr>
  58. </table>
  59. </cfoutput>
  60.  
  61. <cfoutput query="parts">
  62. <cfset hc_partNo = #hc_partNo#>
  63. <cfset part_returned = #part_returned#>
  64. <cfset defective = #defective#>
  65. <cfset submission = #submission#>
  66. </cfoutput>
  67. <cfif parts.recordcount is 0>
  68. <cfset hc_partNo = "">
  69. <cfset part_returned = "">
  70. <cfset defective = "">
  71. <cfset submission = "">
  72. <cfinclude template="partsdisplay.cfm">
  73. </cfif>
Thank you,
Rach
Sep 29 '08 #60
acoder
16,027 Expert Mod 8TB
You shouldn't have the cfif line (checking record count) in partsdisplay.cfm.

I'm not sure why you have multiple <cfoutput query="parts"> or why you have <cfoutput query="ticket"> in the parts display.

The parts table is no longer required in the original form page. It should be replaced by the cfinclude template. See how you've got it working for serials.
Sep 29 '08 #61
bonneylake
769 512MB
You shouldn't have the cfif line (checking record count) in partsdisplay.cfm.

I'm not sure why you have multiple <cfoutput query="parts"> or why you have <cfoutput query="ticket"> in the parts display.

The parts table is no longer required in the original form page. It should be replaced by the cfinclude template. See how you've got it working for serials.
Hey Acoder,

Well the reason i have multiple parts is because of the way it is arranged. The fields in the first row go to the parts table. the second row of fields goes to the tickets table and the third row of fields goes to the parts table.so thats the reason for all the cfouput querys.

i am a bit confused by no longer needing the parts table in the original form? in my serial table i still have a copy of the tables for serial in the div. when we originally did it we took the javascript and made a copy of it an changed it to html an put it between the first div.however, the second div we copied where i made all the values="" i put that div in the serialdisplay.cfm.Also, if i take out the parts then i am afraid the 3 rows that appear in the middle of all the parts will not appear in the correct spot.

but here is what i have, any way to put the tickets part in between the parts table?

Expand|Select|Wrap|Line Numbers
  1. <!--- Parts Information --->
  2. <cfoutput query="parts">
  3. <table class="createticketables" id="spaceup" >
  4. <th class="sectiontitle" colspan="7">Parts Information</th>
  5. <tr>
  6. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  7. <td class="red">
  8. Have all parts been returned*
  9. <cfset part_returned = #part_returned#>
  10. <select name="partsreturn" id="partsreturn">
  11. <option value="" selected>Make A Selection</option>
  12. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  13. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  14. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  15. </select>
  16. </td>
  17. <td>
  18. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  19. </tr>
  20. </table>
  21. </cfoutput>
  22. <cfoutput query="ticket">
  23. <table class="createticketables" >
  24. <tr>
  25. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  26. <td>On Site:</td>
  27. <td>
  28. <select name="onsite" id="onsite">
  29. <option value="" selected>No Choice</option>
  30.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  31.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  32. </select>
  33. </td>
  34. <td>Number of Onsite:</td>
  35. <td>
  36. <select name="numonsite">
  37. <option value="" selected>No Choice</option>
  38. <cfloop from="0" to="10" index="nonsite">
  39. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  40. </option></cfloop>
  41. </select>
  42. </td>
  43. </tr>
  44. </table>
  45. </cfoutput>
  46. <cfoutput query="parts">
  47. <table class="createticketables" id="space">
  48. <tr>
  49. <td class="indent" id="formfieldpadding">Submission:
  50. <select class="submissionticketbox" name="submission">
  51. <option value="" selected>Make a Selection</option>
  52.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  53.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  54.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  55. </select>
  56. </td>
  57. </tr>
  58. </table>
  59. </cfoutput>
  60.  
  61. <cfoutput query="parts">
  62. <cfset hc_partNo = #hc_partNo#>
  63. <cfset part_returned = #part_returned#>
  64. <cfset defective = #defective#>
  65. <cfset submission = #submission#>
  66. </cfoutput>
  67. <cfset hc_partNo = "">
  68. <cfset part_returned = "">
  69. <cfset defective = "">
  70. <cfset submission = "">
  71. <cfinclude template="partsdisplay.cfm">

heres what i have in partsdisplay.cfm
Expand|Select|Wrap|Line Numbers
  1. <!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
  2.  
  3.  
  4. <cfoutput>
  5. <table class="createticketables" id="spaceup" >
  6. <th class="sectiontitle" colspan="7">Parts Information</th>
  7. <tr>
  8. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  9. <td class="red">
  10. Have all parts been returned*
  11. <select name="partsreturn" id="partsreturn">
  12. <option value="" selected>Make A Selection</option>
  13. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  14. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  15. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  16. </select>
  17. </td>
  18. <td>
  19. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  20. </td>
  21. </tr>
  22. </table>
  23.  
  24.  
  25.  
  26.  
  27.  
  28. <table class="createticketables" id="space">
  29. <tr>
  30. <td class="indent" id="formfieldpadding">Submission:
  31. <select class="submissionticketbox" name="submission">
  32. <option value="" selected>Make a Selection</option>
  33.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  34.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  35.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  36. </select>
  37. </td>
  38. </tr>
  39. </table>
  40. </cfoutput>
Thank you,
Rach
Sep 29 '08 #62
acoder
16,027 Expert Mod 8TB
Is there any way you could show how it's arranged, e.g. an attachment, or perhaps the HTML code.
Sep 29 '08 #63
bonneylake
769 512MB
Is there any way you could show how it's arranged, e.g. an attachment, or perhaps the HTML code.
Hey Acoder,

Ok here is what the parts information is suppose to look like

http://img394.imageshack.us/my.php?i...ooklikeyj5.jpg

an here is what it looks like

http://img296.imageshack.us/my.php?i...okslikeaa2.jpg

an here is the html for all the parts section
Expand|Select|Wrap|Line Numbers
  1. <!--- Parts Information --->
  2. <cfoutput query="parts">
  3. <table class="createticketables" id="spaceup" >
  4. <th class="sectiontitle" colspan="7">Parts Information</th>
  5. <tr>
  6. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  7. <td class="red">
  8. Have all parts been returned*
  9. <cfset part_returned = #part_returned#>
  10. <select name="partsreturn" id="partsreturn">
  11. <option value="" selected>Make A Selection</option>
  12. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  13. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  14. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  15. </select>
  16. </td>
  17. <td>
  18. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  19. </tr>
  20. </table>
  21. </cfoutput>
  22. <cfoutput query="ticket">
  23. <table class="createticketables" >
  24. <tr>
  25. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  26. <td>On Site:</td>
  27. <td>
  28. <select name="onsite" id="onsite">
  29. <option value="" selected>No Choice</option>
  30.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  31.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  32. </select>
  33. </td>
  34. <td>Number of Onsite:</td>
  35. <td>
  36. <select name="numonsite">
  37. <option value="" selected>No Choice</option>
  38. <cfloop from="0" to="10" index="nonsite">
  39. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  40. </option></cfloop>
  41. </select>
  42. </td>
  43. </tr>
  44. </table>
  45. </cfoutput>
  46. <cfoutput query="parts">
  47. <table class="createticketables" id="space">
  48. <tr>
  49. <td class="indent" id="formfieldpadding">Submission:
  50. <select class="submissionticketbox" name="submission">
  51. <option value="" selected>Make a Selection</option>
  52.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  53.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  54.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  55. </select>
  56. </td>
  57. </tr>
  58. </table>
  59. </cfoutput>
Thank you,
Rach
Sep 29 '08 #64
acoder
16,027 Expert Mod 8TB
So it's the ticket part which is causing the problem. Is it always one ticket that is output in this cfoutput? If so, you can just set some variables using cfset and then use them instead of using a cfoutput loop.
Sep 29 '08 #65
bonneylake
769 512MB
So it's the ticket part which is causing the problem. Is it always one ticket that is output in this cfoutput? If so, you can just set some variables using cfset and then use them instead of using a cfoutput loop.
Hey Acoder,

well the ticket part is working just fine. It outputs with or without values applied to it, its the parts that is the problem. Since the parts is wrapped around the ticket section, the way we been trying to do it, it makes the ticket fields which are follow up date, onsite and number of onsite appear at the top of the table parts information instead of inbetween. because on the first row its hcpn,have all parts been returned and defective. on the second row is the ticket fields. an on the third row is parts again and its for the field submission. both the parts and the ticket only output one ticket.But anyway i tried to just cfset the parts fields but that didn't seem to work at all.

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. </cfoutput>
but it seems to work correctly with doing it your way,but its mostly just where the tickets fields are position that is causing the trouble. any ideas?

Thank you,
Rach
Sep 30 '08 #66
acoder
16,027 Expert Mod 8TB
Two things I notice. Why do you not have the tickets query output in partdisplay.cfm? Secondly, the whole point of this exercise is to replace the redundant code, so you would remove the cfoutput parts code in the main file and have just:
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>
Sep 30 '08 #67
bonneylake
769 512MB
Two things I notice. Why do you not have the tickets query output in partdisplay.cfm? Secondly, the whole point of this exercise is to replace the redundant code, so you would remove the cfoutput parts code in the main file and have just:
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>
Hey Acoder,

Well reason i didn't put the tickets part in the partdisplay.cfm was because it would make it appear twice instead of once. But anyway i took out everything on the main page and put what you have but nothing is appearing, now nothing for parts table or ticket is appearing

here is whats on my main page
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>



an here is whats on partdisplay.cfm
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <table class="createticketables" id="spaceup" >
  3. <th class="sectiontitle" colspan="7">Parts Information</th>
  4. <tr>
  5. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  6. <td class="red">
  7. Have all parts been returned*
  8. <select name="partsreturn" id="partsreturn">
  9. <option value="" selected>Make A Selection</option>
  10. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  11. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  12. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  13. </select>
  14. </td>
  15. <td>
  16. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  17. </td>
  18. </tr>
  19. </table>
  20. </cfoutput>
  21. <cfoutput query="ticket">
  22. <table class="createticketables" >
  23. <tr>
  24. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  25. <td>On Site:</td>
  26. <td>
  27. <select name="onsite" id="onsite">
  28. <option value="" selected>No Choice</option>
  29.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  30.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  31. </select>
  32. </td>
  33. <td>Number of Onsite:</td>
  34. <td>
  35. <select name="numonsite">
  36. <option value="" selected>No Choice</option>
  37. <cfloop from="0" to="10" index="nonsite">
  38. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  39. </option></cfloop>
  40. </select>
  41. </td>
  42. </tr>
  43. </table>
  44. </cfoutput>
  45.  
  46. <cfoutput query="parts">
  47. <table class="createticketables" id="space">
  48. <tr>
  49. <td class="indent" id="formfieldpadding">Submission:
  50. <select class="submissionticketbox" name="submission">
  51. <option value="" selected>Make a Selection</option>
  52.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  53.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  54.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  55. </select>
  56. </td>
  57. </tr>
  58. </table>
  59. </cfoutput>
Thank you,
Rach
Oct 1 '08 #68
acoder
16,027 Expert Mod 8TB
You don't need any cfoutputs in partsdisplay.cfm because it's already within a cfoutput. What you would need, however, is to set the variables for the ticket query outside partsdisplay.cfm, so you can access them within the file.
Oct 1 '08 #69
bonneylake
769 512MB
You don't need any cfoutputs in partsdisplay.cfm because it's already within a cfoutput. What you would need, however, is to set the variables for the ticket query outside partsdisplay.cfm, so you can access them within the

file.
Hey Acoder,

alrighty i took out all the cfoutputs in the partsdisplay.cfm but still nothing appears. But how do i set the variables for the ticket query outside partsdisplay? would i do it like i did the parts

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
here is what the partsdisplay.cfm looks like

Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
Thank you,
Rach
Oct 1 '08 #70
acoder
16,027 Expert Mod 8TB
Yes, that's the idea. That first piece of code would go before the <cfoutput query="parts"> part which would mean that when partsdisplay is called, it has the correct values set.

When you say nothing displays, is this for 1 or more parts or for no parts?
Oct 1 '08 #71
bonneylake
769 512MB
Yes, that's the idea. That first piece of code would go before the <cfoutput query="parts"> part which would mean that when partsdisplay is called, it has the correct values set.

When you say nothing displays, is this for 1 or more parts or for no parts?
Hey Acoder,

I am meaning nothing for parts display. No fields, not even the table displays! But i added the ticket part

here is all i have on the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. <cfinclude template="partsdisplay.cfm">
  14. </cfoutput>
an here is what i have on partsdisplay.cfm

Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
Thank you,
Rach
Oct 1 '08 #72
acoder
16,027 Expert Mod 8TB
Hmm, check the source code in the browser. Does the HTML show up?
Oct 1 '08 #73
bonneylake
769 512MB
Hmm, check the source code in the browser. Does the HTML show up?
Hey Acoder,

Nope it doesn't show up in the source. But i know i got the name right to the file.
I did try one thing when i did it like this on the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. </cfoutput>
  14. <cfset hc_partNo = "">
  15. <cfset part_returned = "">
  16. <cfset defective = "">
  17. <cfset submission = "">
  18. <cfinclude template="partsdisplay.cfm">
when did the cfset = "" it made it appear, thing is in now the value is being written inside the field so if the value is #hc_partNo# it writes it for the field. Any suggestion?

here is what i have on partsdisplay.cfm

Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
  57.  
Thank you,
Rach
Oct 1 '08 #74
acoder
16,027 Expert Mod 8TB
That part of the code should be in cfif tags:
Expand|Select|Wrap|Line Numbers
  1. <cfif parts.recordcount is 0>
  2. <cfset hc_partNo = "">
  3. <cfset part_returned = "">
  4. <cfset defective = "">
  5. <cfset submission = "">
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfif>
Oct 1 '08 #75
bonneylake
769 512MB
That part of the code should be in cfif tags:
Expand|Select|Wrap|Line Numbers
  1. <cfif parts.recordcount is 0>
  2. <cfset hc_partNo = "">
  3. <cfset part_returned = "">
  4. <cfset defective = "">
  5. <cfset submission = "">
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfif>
Hey Acoder,

I did that but still getting the same results. here is what i got on the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. </cfoutput>
  14. <cfif parts.recordcount is 0>
  15. <cfset hc_partNo = "">
  16. <cfset part_returned = "">
  17. <cfset defective = "">
  18. <cfset submission = "">
  19. <cfinclude template="partsdisplay.cfm">
  20. </cfif>
  21.  
Thank you,
Rach
Oct 1 '08 #76
acoder
16,027 Expert Mod 8TB
Ah, you will need cfoutput around the call, e.g.
Expand|Select|Wrap|Line Numbers
  1. <cfoutput>
  2. <cfinclude template="partsdisplay.cfm">
  3. </cfoutput>
Oct 1 '08 #77
bonneylake
769 512MB
Ah, you will need cfoutput around the call, e.g.
Expand|Select|Wrap|Line Numbers
  1. <cfoutput>
  2. <cfinclude template="partsdisplay.cfm">
  3. </cfoutput>
Hey Acoder,

It still don't like me.

main page
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. </cfoutput>
  14. <cfif parts.recordcount is 0>
  15. <cfset hc_partNo = "">
  16. <cfset part_returned = "">
  17. <cfset defective = "">
  18. <cfset submission = "">
  19. <cfoutput>
  20. <cfinclude template="partsdisplay.cfm">
  21. </cfoutput>
  22. </cfif>

here whats on the partsdisplay.cfm
Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
Thank you,
Rach
Oct 1 '08 #78
acoder
16,027 Expert Mod 8TB
You will also need an include in the first part:
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>
  8. <cfif parts.recordcount is 0>
  9. <cfset hc_partNo = "">
  10. <cfset part_returned = "">
  11. <cfset defective = "">
  12. <cfset submission = "">
  13. <cfoutput>
  14. <cfinclude template="partsdisplay.cfm">
  15. </cfoutput>
  16. </cfif>
Oct 1 '08 #79
bonneylake
769 512MB
Hey Acoder,

I am still getting the same results. Do i need to take the values out of my partsdisplay.cfm page? i know it would show them empty if i did that. But then if i take the values out if the fields do actually have values it wont show up. But here is what i have on the main page.


Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. <cfinclude template="partsdisplay.cfm">
  14. </cfoutput>
  15. <cfif parts.recordcount is 0>
  16. <cfset hc_partNo = "">
  17. <cfset part_returned = "">
  18. <cfset defective = "">
  19. <cfset submission = "">
  20. <cfoutput>
  21. <cfinclude template="partsdisplay.cfm">
  22. </cfoutput>
  23. </cfif>
  24.  
Thank you :),
Rach
Oct 2 '08 #80
acoder
16,027 Expert Mod 8TB
Let's try and get one part working at least.

Find a ticket where you have no parts, i.e. the parts.recordcount is 0, and test that first. Forget about displaying parts values for now. Does it still show nothing?
Oct 2 '08 #81
bonneylake
769 512MB
Hey Acoder,

oh i forgot to tell you that the table IS showing up an the fields are in the correct spot. Forgot to tell you (sorry about that).The only thing is the value part. Right now instead of the value for the fields being blank its putting the values i have assigned to the field like for example the value for hc p/c is #hc_partsNo#.If i go an look an an entry where i put a value for that field it will show what the value was. but when i try to look at once where i put it blank it instead puts the value which is the #hc_partsNo#.

Thank you,
Rach
Oct 2 '08 #82
acoder
16,027 Expert Mod 8TB
Make sure the variable names match up. For example, is it hc_partNo or hc_partsNo?
Oct 2 '08 #83
bonneylake
769 512MB
Hey Acoder,

It looks like everything matches up. But Still acting weird. Here is what i have on the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7.  
  8. <cfoutput query="parts">
  9. <cfset hc_partNo = #hc_partNo#>
  10. <cfset part_returned = #part_returned#>
  11. <cfset defective = #defective#>
  12. <cfset submission = #submission#>
  13. <cfinclude template="partsdisplay.cfm">
  14. </cfoutput>
  15. <cfif parts.recordcount is 0>
  16. <cfset hc_partNo = "">
  17. <cfset part_returned = "">
  18. <cfset defective = "">
  19. <cfset submission = "">
  20. <cfoutput>
  21. <cfinclude template="partsdisplay.cfm">
  22. </cfoutput>
  23. </cfif>
and here is whats on partsdisplay.cfm
Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
Thank you,
Rach
Oct 2 '08 #84
acoder
16,027 Expert Mod 8TB
So this problem occurs where you have some parts? Are you sure the hc_partNo should be blank? Which value is it taking instead? When you have no parts, the code works fine. Is that correct?
Oct 2 '08 #85
bonneylake
769 512MB
So this problem occurs where you have some parts? Are you sure the hc_partNo should be blank? Which value is it taking instead? When you have no parts, the code works fine. Is that correct?
Hey Acoder,

If i have something previously written into hc_partNo it will appear perfectly fine with no problems. However, when i go to view one that doesn't have anything previously written into hc_partNo it will appear with the value. Like here is the line

Expand|Select|Wrap|Line Numbers
  1. <input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#">
instead of when you view it the field remains blank it puts the value which is #hc_partNo#

Thank you,
Rach
Oct 2 '08 #86
acoder
16,027 Expert Mod 8TB
Check the output from the query. If you put something like (for a test) :
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. #hc_partNo#;#part_returned#;#defective#;#submission#<br>
  3. <cfset hc_partNo = #hc_partNo#>
  4. <cfset part_returned = #part_returned#>
  5. <cfset defective = #defective#>
  6. <cfset submission = #submission#>
  7. <cfinclude template="partsdisplay.cfm">
  8. </cfoutput>
what does it output?
Oct 2 '08 #87
bonneylake
769 512MB
Check the output from the query. If you put something like (for a test) :
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. #hc_partNo#;#part_returned#;#defective#;#submission#<br>
  3. <cfset hc_partNo = #hc_partNo#>
  4. <cfset part_returned = #part_returned#>
  5. <cfset defective = #defective#>
  6. <cfset submission = #submission#>
  7. <cfinclude template="partsdisplay.cfm">
  8. </cfoutput>
what does it output?
Hey Acoder,

with your test, if i looked at a ticket with previous entrys it showed what the values are suppose to be, but it didn't put it the fields it just put it above all the fields.But if i looked at a entry where there were no values applied then nothing would appear at all.

Thank you,
Rach
Oct 2 '08 #88
acoder
16,027 Expert Mod 8TB
Ah, so now we've established, the problem is with the recordcount 0 part. Remove the test line because it's not needed any more.

Is it just hc_partNo or all 4 fields where you have this problem?
Oct 2 '08 #89
bonneylake
769 512MB
Ah, so now we've established, the problem is with the recordcount 0 part. Remove the test line because it's not needed any more.

Is it just hc_partNo or all 4 fields where you have this problem?
Hey Acoder,

I am having the problem with all the fields for the parts table and all the fields for the ticket table as well. so basically all the fields present.

Thank you,
Rach
Oct 2 '08 #90
acoder
16,027 Expert Mod 8TB
OK, remove the <cfoutput> from around <cfinclude> and see if that makes a difference.
Oct 2 '08 #91
bonneylake
769 512MB
Hey Acoder,

Alrighty this is kinda weird to explain. When i look at a record that has no values its having a problem with the first drop down box (part_returned) that appears saying it cant determine value of parameter.

If i look at a record that has values applied to it, all the fields work except
the #hc_partNo#, #followup_date#, and #number_onsite#.

Here is what i have on the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7. <cfoutput query="parts">
  8. <cfset hc_partNo = #hc_partNo#>
  9. <cfset part_returned = #part_returned#>
  10. <cfset defective = #defective#>
  11. <cfset submission = #submission#>
  12. </cfoutput>
  13. <cfinclude template="partsdisplay.cfm">
here is what on partsdisplay.cfm

Expand|Select|Wrap|Line Numbers
  1. <table class="createticketables" id="spaceup" >
  2. <th class="sectiontitle" colspan="7">Parts Information</th>
  3. <tr>
  4. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  5. <td class="red">
  6. Have all parts been returned*
  7. <select name="partsreturn" id="partsreturn">
  8. <option value="" selected>Make A Selection</option>
  9. <option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
  10. <option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
  11. <option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
  12. </select>
  13. </td>
  14. <td>
  15. <td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
  16. </td>
  17. </tr>
  18. </table>
  19.  
  20. <table class="createticketables" >
  21. <tr>
  22. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  23. <td>On Site:</td>
  24. <td>
  25. <select name="onsite" id="onsite">
  26. <option value="" selected>No Choice</option>
  27.   <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  28.   <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
  29. </select>
  30. </td>
  31. <td>Number of Onsite:</td>
  32. <td>
  33. <select name="numonsite">
  34. <option value="" selected>No Choice</option>
  35. <cfloop from="0" to="10" index="nonsite">
  36. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  37. </option></cfloop>
  38. </select>
  39. </td>
  40. </tr>
  41. </table>
  42.  
  43.  
  44.  
  45. <table class="createticketables" id="space">
  46. <tr>
  47. <td class="indent" id="formfieldpadding">Submission:
  48. <select class="submissionticketbox" name="submission">
  49. <option value="" selected>Make a Selection</option>
  50.   <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  51.   <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  52.   <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
  53. </select>
  54. </td>
  55. </tr>
  56. </table>
Thank you,
Rach
Oct 2 '08 #92
acoder
16,027 Expert Mod 8TB
I didn't mean that you should remove the whole cfif part, just the cfoutput tags, i.e.
Expand|Select|Wrap|Line Numbers
  1. <cfif parts.recordcount is 0>
  2. <cfset hc_partNo = "">
  3. <cfset part_returned = "">
  4. <cfset defective = "">
  5. <cfset submission = "">
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfif>
Oct 2 '08 #93
bonneylake
769 512MB
I didn't mean that you should remove the whole cfif part, just the cfoutput tags, i.e.
Expand|Select|Wrap|Line Numbers
  1. <cfif parts.recordcount is 0>
  2. <cfset hc_partNo = "">
  3. <cfset part_returned = "">
  4. <cfset defective = "">
  5. <cfset submission = "">
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfif>
Hey Acoder,

I am confused am i only suppose to have

Expand|Select|Wrap|Line Numbers
  1. <cfif parts.recordcount is 0>
  2. <cfset hc_partNo = "">
  3. <cfset part_returned = "">
  4. <cfset defective = "">
  5. <cfset submission = "">
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfif>
  8.  
or

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. </cfoutput>
  7. <cfinclude template="partsdisplay.cfm">
having it the way you have the example above. if i look at a blank record it shows the table an it shows none of the fields having a value. except in hc p/n, followup_date.

if i looked at a record with values the table don't appear.

Thank you,
Rach
Oct 2 '08 #94
acoder
16,027 Expert Mod 8TB
Actually a combination of the two rather similar to serials:
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>
  8. <cfif parts.recordcount is 0>
  9. <cfset hc_partNo = "">
  10. <cfset part_returned = "">
  11. <cfset defective = "">
  12. <cfset submission = "">
  13. <cfinclude template="partsdisplay.cfm">
  14. </cfif>
  15.  
Oct 2 '08 #95
bonneylake
769 512MB
Hey Acoder,

it looks like its "almost" there. It shows the table it gives the correct value for most of the fields except 3 of them. the 3 fields are

#hc_partNo#
#followup_date#
#number_onsite#

but i got no clue what is causing it the names match up unless i somehow did it wrong in the partsdisplay.cfm

heres everything in the main page

Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="ticket">
  2. <cfset followup_date = #followup_date#>
  3. <cfset onsite_flag = #onsite_flag#>
  4. <cfset number_onsite = #number_onsite#>
  5. </cfoutput>
  6.  
  7. <cfoutput query="parts">
  8. <cfset hc_partNo = #hc_partNo#>
  9. <cfset part_returned = #part_returned#>
  10. <cfset defective = #defective#>
  11. <cfset submission = #submission#>
  12. <cfinclude template="partsdisplay.cfm">
  13. </cfoutput>
  14. <cfif parts.recordcount is 0>
  15. <cfset hc_partNo = "">
  16. <cfset part_returned = "">
  17. <cfset defective = "">
  18. <cfset submission = "">
  19. <cfinclude template="partsdisplay.cfm">
  20. </cfif>
an here is what those 3 fields look like in partsdisplay.cfm



Expand|Select|Wrap|Line Numbers
  1. <td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
  2.  
  3. <td class="indent"  id="formfieldpadding">Follow up Date:(MM/DD/YYYY)&nbsp;&nbsp;&nbsp;<input type="text" name="followdate" value="#followup_date#" size="8"/>&nbsp;&nbsp;&nbsp;Current Date<input type="checkbox" name="followcheck" value="" onClick="followdate.value=fill_date()"/></td>
  4.  
  5.  
  6. <td>Number of Onsite:</td>
  7. <td>
  8. <select name="numonsite">
  9. <option value="" selected>No Choice</option>
  10. <cfloop from="0" to="10" index="nonsite">
  11. <option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
  12. </option></cfloop>
  13. </select>
  14. </td>
Thank you,
Rach
Oct 2 '08 #96
acoder
16,027 Expert Mod 8TB
I think you will need the <cfoutput> tags around those variables, but then that wouldn't work for the first part, so try this:
Expand|Select|Wrap|Line Numbers
  1. <cfoutput query="parts">
  2. <cfset hc_partNo = #hc_partNo#>
  3. <cfset part_returned = #part_returned#>
  4. <cfset defective = #defective#>
  5. <cfset submission = #submission#>
  6. <cfinclude template="partsdisplay.cfm">
  7. </cfoutput>
  8. <cfif parts.recordcount is 0>
  9. <cfset hc_partNo = "">
  10. <cfset part_returned = "">
  11. <cfset defective = "">
  12. <cfset submission = "">
  13. <cfoutput><cfinclude template="partsdisplay.cfm"></cfoutput>
  14. </cfif>
Oct 2 '08 #97
bonneylake
769 512MB
Hey Acoder,

Well tried that an it didn't work. But i did figure it out. In the partsdisplay.cfm i wrapped it all in just a simple <cfoutput> </cfoutput> and used the code you had in your last post on my main page an now its working :)

Thank you,
Rach
Oct 2 '08 #98
acoder
16,027 Expert Mod 8TB
Great to see that you finally managed the parts problem. I think it could be improved further in terms of efficiency/performance if you avoid using cfoutput around the whole file and use it only where you have Coldfusion variables output.
Oct 2 '08 #99
bonneylake
769 512MB
Hey Acoder,

Yeah i probably will end up changing the cfouput so its only around what is needed.But THANK YOU SO MUCH FOR ALL THE HELP!!!
Rach
Oct 2 '08 #100

Post your reply

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

Similar topics

3 posts views Thread by Michael | last post: by
2 posts views Thread by Fred Flintstone | last post: by
5 posts views Thread by rn5a | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.