URL Method for 3 tables?

[bonneylake]

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

 <!---Shows what was previously entered into table ticketmaster--->
<cfquery name="ticket" datasource="CustomerSupport">
 SELECT pk_ticketID,title,priority,status,
cost_center,fk_customer_number,
customer_company,customer_Fname,customer_Lname,
customer_add1,customer_city,customer_state,
customer_zip,customer_email,customer_pri_phone,
customer_sec_phone,customer_notes,htpp FROM dbo.tbl_CS_ticketMaster
WHERE pk_ticketID = #URL.pk_ticketID#
</cfquery>
 
<cfquery name="serial" datasource="CustomerSupport">
SELECT pka_serialNo,pkb_fk_ticketNo,model_no,product_type ,
software_hardware,resolution,resolution_date,
verification_date,rma_data,
type_hardware_failure,dept_responsibility,resoluti on_verified_by FROM dbo.tbl_CS_serial
</cfquery>
 
<cfquery name="parts" datasource="CustomerSupport">
SELECT pk_partID,fk_serialNo,fk_ticketNo,hc_partNo,
part_returned,defective,submission
FROM dbo.tbl_CS_parts
</cfquery>
 
<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>"
 method="POST" onSubmit="return validate_form();">
</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

[acoder]

I meant the exact same call, i.e.

<cfinclude template="serialdisplay.cfm">

[bonneylake]

I meant the exact same call, i.e.

<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

[acoder]

I mean here:

<cfif serial.recordcount is 0>
<cfset model_no = "">
<cfset product_type = "">
<cfset type_hardware_failure = "">
<cfset pka_serialNo = "">
<cfset software_hardware = "">
<cfset description = "">
<cfset resolution = "">
<cfset resolution_date = "">
<cfset resolution_verified_by = "">
<cfset verification_date = "">
<cfset dept_responsibility = "">
<cfset rma_data = "">
 <cfinclude template="serialdisplay.cfm">
</cfif>
 

[bonneylake]

Hey Acoder,

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

<cfoutput query="serial">
<cfset model_no = #model_no#>
<cfset product_type = #product_type#>
<cfset type_hardware_failure = #type_hardware_failure#>
<cfset pka_serialNo = #pka_serialNo#>
<cfset software_hardware = #software_hardware#>
<cfset description = #description#>
<cfset resolution = #resolution#>
<cfset resolution_date = #resolution_date#>
<cfset resolution_verified_by = #resolution_verified_by#>
<cfset verification_date = #verification_date#>
<cfset dept_responsibility = #dept_responsibility#>
<cfset rma_data = #rma_data#>
</cfoutput>
<cfif serial.recordcount is 0>
<cfset model_no = "">
<cfset product_type = "">
<cfset type_hardware_failure = "">
<cfset pka_serialNo = "">
<cfset software_hardware = "">
<cfset description = "">
<cfset resolution = "">
<cfset resolution_date = "">
<cfset resolution_verified_by = "">
<cfset verification_date = "">
<cfset dept_responsibility = "">
<cfset rma_data = "">
<cfinclude template="serialdisplay.cfm">
</cfif>
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

Thank you,
Rach

[acoder]

Well, does it work? What happens?

[bonneylake]

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

[acoder]

Yes, put the div "dynamic#count#Input" code in the include template.

[bonneylake]

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

<!--- Parts Information --->
<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<cfset part_returned = #part_returned#>
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
<table class="createticketables" >
<tr>
</cfoutput>
<cfoutput query="ticket">
<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>
<td>On Site:</td><td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
<td>
<td>Number of Onsite:</td><td>
<select name="numonsite">
<option value="" selected>No Choice</option>
  <cfloop from="0" to="10" index="nonsite"><option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#</option></cfloop>
</select></cfoutput><td>
</tr>
</table>
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<cfoutput query="parts">
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</cfoutput>
</td>
</tr>
</table>
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>
 

and here is what i have on the parts template

<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<cfset part_returned = #part_returned#>
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
<table class="createticketables" >
<tr>
</cfoutput>
<cfoutput query="parts">
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</cfoutput>

Thank you,
Rach

[acoder]

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).

[bonneylake]

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

<!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
 
<cfif parts.recordcount is 0>  
<cfoutput>
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>
</cfif>

appears in original form

<!--- Parts Information --->
<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<cfset part_returned = #part_returned#>
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</tr>
</table>
</cfoutput>
<cfoutput query="ticket">
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
</cfoutput>
<cfoutput query="parts">
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

Thank you,
Rach

[acoder]

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.

[bonneylake]

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?

<!--- Parts Information --->
<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<cfset part_returned = #part_returned#>
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</tr>
</table>
</cfoutput>
<cfoutput query="ticket">
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
</cfoutput>
<cfoutput query="parts">
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">

heres what i have in partsdisplay.cfm

<!---IF HAVE ANY BLANKS IN ANY FIELDS THIS MAKES IT SO THE FIELD WILL SHOW UP--->
 
 
<cfoutput>
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
 
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>

Thank you,
Rach

[acoder]

Is there any way you could show how it's arranged, e.g. an attachment, or perhaps the HTML code.

[bonneylake]

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

<!--- Parts Information --->
<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<cfset part_returned = #part_returned#>
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</tr>
</table>
</cfoutput>
<cfoutput query="ticket">
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
</cfoutput>
<cfoutput query="parts">
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>

Thank you,
Rach

[acoder]

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.

[bonneylake]

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.

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</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

[acoder]

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:

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

[bonneylake]

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:

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</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

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

an here is whats on partdisplay.cfm

<cfoutput query="parts">
<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
</cfoutput>
<cfoutput query="ticket">
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
</cfoutput>
 
<cfoutput query="parts">
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
</cfoutput>

Thank you,
Rach

[acoder]

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.

[bonneylake]

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>

here is what the partsdisplay.cfm looks like

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>

Thank you,
Rach

[acoder]

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?

[bonneylake]

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

an here is what i have on partsdisplay.cfm

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>

Thank you,
Rach

[acoder]

Hmm, check the source code in the browser. Does the HTML show up?

[bonneylake]

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<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

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>
 

Thank you,
Rach

[acoder]

That part of the code should be in cfif tags:

<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

[bonneylake]

That part of the code should be in cfif tags:

<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

Hey Acoder,

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>
 

Thank you,
Rach

[acoder]

Ah, you will need cfoutput around the call, e.g.

<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

[bonneylake]

Ah, you will need cfoutput around the call, e.g.

<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

Hey Acoder,

It still don't like me.

main page

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
</cfif>

here whats on the partsdisplay.cfm

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>

Thank you,
Rach

[acoder]

You will also need an include in the first part:

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
</cfif>

[bonneylake]

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.

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
</cfif>
 

Thank you :),
Rach

[acoder]

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?

[bonneylake]

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

[acoder]

Make sure the variable names match up. For example, is it hc_partNo or hc_partsNo?

[bonneylake]

Hey Acoder,

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfoutput>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
</cfif>

and here is whats on partsdisplay.cfm

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>

Thank you,
Rach

[acoder]

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?

[bonneylake]

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

<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

[acoder]

Check the output from the query. If you put something like (for a test) :

<cfoutput query="parts">
#hc_partNo#;#part_returned#;#defective#;#submission#<br>
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>

what does it output?

[bonneylake]

Check the output from the query. If you put something like (for a test) :

<cfoutput query="parts">
#hc_partNo#;#part_returned#;#defective#;#submission#<br>
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</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

[acoder]

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?

[bonneylake]

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

[acoder]

OK, remove the <cfoutput> from around <cfinclude> and see if that makes a difference.

[bonneylake]

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<cfinclude template="partsdisplay.cfm">

here is what on partsdisplay.cfm

<table class="createticketables" id="spaceup" >
<th class="sectiontitle" colspan="7">Parts Information</th>
<tr>
<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
<td class="red">
Have all parts been returned*
<select name="partsreturn" id="partsreturn">
<option value="" selected>Make A Selection</option>
<option value="N/A"<cfif #part_returned# is "N/A">selected</cfif>>N/A</option>
<option value="No"<cfif #part_returned# is "No">selected</cfif>>No</option>
<option value="Yes"<cfif #part_returned# is "Yes">selected</cfif>>Yes</option>
</select>
</td>
<td>
<td class="indent">Defective<input type="checkbox" name="defective" value="#defective#"<cfif #defective# eq "1">checked=yes</cfif>/></td>
</td>
</tr>
</table>
 
<table class="createticketables" >
<tr>
<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>
<td>On Site:</td>
<td>
<select name="onsite" id="onsite">
<option value="" selected>No Choice</option>
  <option value="Yes"<cfif #onsite_flag# is "Y">selected</cfif>>Yes</option>
  <option value="No"<cfif #onsite_flag# is "N">selected</cfif>>No</option>
</select>
</td>
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>
</tr>
</table>
 
 
 
<table class="createticketables" id="space">
<tr>
<td class="indent" id="formfieldpadding">Submission:
<select class="submissionticketbox" name="submission">
<option value="" selected>Make a Selection</option>
  <option value="Phone"<cfif #submission# is "Phone">selected</cfif>>Phone</option>
  <option value="Techmail"<cfif #submission# is "Techmail">selected</cfif>>Techmail</option>
  <option value="Request"<cfif #submission# is "Request">selected</cfif>>Request</option>
</select>
</td>
</tr>
</table>

Thank you,
Rach

[acoder]

I didn't mean that you should remove the whole cfif part, just the cfoutput tags, i.e.

<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

[bonneylake]

I didn't mean that you should remove the whole cfif part, just the cfoutput tags, i.e.

<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

Hey Acoder,

I am confused am i only suppose to have

<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>
 

or

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
</cfoutput>
<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

[acoder]

Actually a combination of the two rather similar to serials:

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>
 

[bonneylake]

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

<cfoutput query="ticket">
<cfset followup_date = #followup_date#>
<cfset onsite_flag = #onsite_flag#>
<cfset number_onsite = #number_onsite#>
</cfoutput>
 
<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfinclude template="partsdisplay.cfm">
</cfif>

an here is what those 3 fields look like in partsdisplay.cfm

<td class="indent" id="formfieldpadding">HC P/N:&nbsp;&nbsp;&nbsp;<input type="text" name="hcpn" style="margin:0px" value="#hc_partNo#"></td>
 
<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>
 
 
<td>Number of Onsite:</td>
<td>
<select name="numonsite">
<option value="" selected>No Choice</option>
<cfloop from="0" to="10" index="nonsite">
<option value="#nonsite#"<cfif #number_onsite# is #nonsite#>selected</cfif>>#nonsite#
</option></cfloop>
</select>
</td>

Thank you,
Rach

[acoder]

I think you will need the <cfoutput> tags around those variables, but then that wouldn't work for the first part, so try this:

<cfoutput query="parts">
<cfset hc_partNo = #hc_partNo#>
<cfset part_returned = #part_returned#>
<cfset defective = #defective#>
<cfset submission = #submission#>
<cfinclude template="partsdisplay.cfm">
</cfoutput>
<cfif parts.recordcount is 0>
<cfset hc_partNo = "">
<cfset part_returned = "">
<cfset defective = "">
<cfset submission = "">
<cfoutput><cfinclude template="partsdisplay.cfm"></cfoutput>
</cfif>

[bonneylake]

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

[acoder]

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.

[bonneylake]

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