Solved

Cfform Cfwindow CFdiv element value not passing

Posted on 2010-11-21
23
1,305 Views
Last Modified: 2012-05-10
In the code attached, the element EusersSpecialtyID seems to have the correct data when displaying the page.  But the action page has a blank value in the form scope.  There seems to be a particular bug about whether you CFparam this element or not.  When the display page is up I can use Web Developer to display the form information and the data is there.  Using CFdump on a CFwindow or its action page is a PITA (pain in the...) and useless.  I've used other debug techniques to discover that #form.EusersSpecialtyID# is blank but should have a value of 3 as displayed in the CFdiv.
This is the CFdiv thats on a CFform in a CFwindow;



<td colspan="4">

<cfdiv id="UsersSpecialtyDiv" bind="url:UserSpecialtyDiv.cfm?Tec1={Eistec1}&Tec2={Eistec2}&Tec3={Eistec3}&namePrefix=E" bindonload="true" /></td>



<cfif isdefined("url.Tec1")>





This is the binding code in UserSpecialtyDiv.cfm;

<cfoutput>

	<cfif val(url.Tec3) gt 24>

		<cfset SetUserSpecialty= "International">

		<cfset SetUserSpecialtyID= "3">

	<cfelseif val(url.Tec2) gt 49>

		<cfset SetUserSpecialty= "State/Local">

		<cfset SetUserSpecialtyID= "2">

	<cfelse>

		<cfset SetUserSpecialty= "Fed/Gen">

		<cfset SetUserSpecialtyID= "1">

	</cfif>

	<cfset TotalOfTecs = #val(url.tec1)#+#val(url.tec2)#+#val(url.tec3)#>

	<cfif val(TotalOfTecs) neq 100>

		<th style="background-color:ff0000;color:FFFFFF;">#val(TotalOfTecs)#%</th>

	</cfif>

	User Specialty-#SetUserSpecialtyID#

		<input type="text" name="#namePrefix#UserSpecialtyID" id="#namePrefix#UserSpecialtyID" value="#SetUserSpecialtyID#" size="3" disabled/>

		<input type="text" name="#namePrefix#UserSpecialty" id="#namePrefix#UserSpecialty" value="#SetUserSpecialty#" size="20" maxlength="20" disabled/>

		



</cfoutput>

</cfif>

Open in new window

0
Comment
Question by:lantervj
  • 12
  • 10
23 Comments
 
LVL 52

Expert Comment

by:_agx_
ID: 34185241
What do you mean by "on a CFForm"? Can you post more code so we can see how the elements (cfdiv/cfform/cfwindow) are actually nested?
0
 
LVL 4

Expert Comment

by:docnica
ID: 34185259
the problem is that variables are not defined. Also pass Tec1={Eistec1} this way Tec1=#Eistec1#. I asume Eistec1 is a variable you defined earlier...
0
 

Author Comment

by:lantervj
ID: 34185300
Main page
<cfajaximport tags="cfform">
<!--- <cfdump var="#form#" /> --->
<cfparam name="BENCHMARKGRID.ID" default="" />
<cfparam name="SB_GRID.BENCHID" default="" />
<cfif isdefined("url.cfgridkey")>
	<cfset attributes.benchID = "#listfirst(val(cfgridkey))#" />
<cfelse>
	<cfif BENCHMARKGRID.ID NEQ "">
		<cfset attributes.benchID = "#val(BENCHMARKGRID.ID)#" />
	</cfif>
	<cfif SB_GRID.BENCHID NEQ "">
		<cfset attributes.benchID = "#val(SB_GRID.BENCHID)#" />
	</cfif>
</cfif>
<link rel="stylesheet" type="text/css" href="/control/individuals/indiv.css" title="Global" />
<cfparam name="attributes.benchID" type="integer" />
<cfset searchnum = #attributes.benchID# />
<cfinvoke component="cfc.basic" method="getBenchmarkById" benchID="#attributes.benchID#" returnvariable="benchInfo" />
<cfinvoke component="cfc.basic" method="recruiterList" returnvariable="recruiterInfo" />
<cfinvoke component="cfc.basic" method="packageList" cid="#benchInfo.company_id#" sid="4" returnvariable="packageInfo" />
<cfinvoke component="cfc.basic" method="getSubSpecs" returnvariable="subSpecInfo" />
<cfinvoke component="CompanyCfc.basic" method="GetSalesLevel" returnvariable="QSalesLevel" />
<cfinvoke component="cfc.basic" method="getUsedParticipants" benchID="#attributes.benchID#" returnvariable="participantsInfo" />
<cfset doc_title = #replace(benchInfo.report_title, " ", "_", "all")# />
<h3 align="left">View Salary Benchmark 
	<cfoutput>
		#attributes.benchID#
	</cfoutput></h3>
<cfsavecontent variable="SBscript">
	<script type="text/javascript">
		function submitFrm(){
		ColdFusion.Ajax.submitForm('newParticipantForm', 'actNewParticipant.cfm', callback, errorhandler);
		};
		
		callback=function(text)
		{
		ColdFusion.Window.hide('newParticipant');
		ColdFusion.Grid.refresh('participantGrid', true);
		};
		
		submitFrmAnon=function(){
		ColdFusion.Ajax.submitForm('newAnonParticipantForm', 'actNewAnonParticipant.cfm', callbackanon, errorhandler);
		};
		
		callbackanon=function(text)
		{
		ColdFusion.Window.hide('newAnonParticipant');
		ColdFusion.Grid.refresh('participantGrid', true);
		};
		
		submitFrm2=function(){
		ColdFusion.Ajax.submitForm('editParticipantForm', 'actEditParticipant.cfm', callback2, errorhandler);
		};
		
		callback2=function(text)
		{
		ColdFusion.Window.hide('editParticipant');
		ColdFusion.Grid.refresh('participantGrid', true);
		};
		
		submitFrm3=function(){
		ColdFusion.Ajax.submitForm('deleteParticipantForm', 'actDeleteParticipant.cfm', callback3, errorhandler);
		};
		
		callback3=function(text)
		{
		ColdFusion.Window.hide('deleteParticipant');
		ColdFusion.Grid.refresh('participantGrid', true);
		};
		
		submitFrm4=function(){
		ColdFusion.Ajax.submitForm('editAnonParticipantForm', 'actEditAnonParticipants.cfm', callback4, errorhandler);
		};
		
		callback4=function(text)
		{
		ColdFusion.Window.hide('editAnonParticipant');
		ColdFusion.Grid.refresh('AnonparticipantGrid', true);
		};
		
		submitFrm5=function(){
		ColdFusion.Ajax.submitForm('deleteAnonParticipantForm', 'actDeleteAnonParticipants.cfm', callback5, errorhandler);
		};
		
		callback5=function(text)
		{
		ColdFusion.Window.hide('deleteAnonParticipant');
		ColdFusion.Grid.refresh('AnonparticipantGrid', true);
		};
		
		errorhandler=function(code, msg)
		{
		alert("Error!!! " + code + ": " + msg);
		};
		
	<!--
		function checkIt(){
		    if (confirm("Are you sure you want to re-open this Benchmark?")) {
		        return true;
		    }
		    else {
		        return false;
		    }       
		}
		
		function checkIt2(){
		    if (confirm("Are you sure you want to exit without saving?")) {
		        return true;
		    }
		    else {
		        return false;
		    }       
		}
		
		function checkIt3(){
		    if (confirm("Are you sure you want to DELETE this Salary Benchmark?")) {
		        return true;
		    }
		    else {
		        return false;
		    }       
		}
		
		function checkIt4(){
		    if (confirm("Are you sure you want to close this Benchmark?")) {
		        return true;
		    }
		    else {
		        return false;
		    }       
		}
		//-->
	var workIsDone = false; window.onbeforeunload = confirmBrowseAway; 
	confirmBrowseAway=function() 
	{ 
		if (!workIsDone) { confirm('Are you sure you want to do that? If you leave this page ' + 'now, your work will NOT be saved!');
			 return false;
		 }
	 }; 
	 fileMyTaxes=function()
	  { 
	  	// The user has finished their work, so we don't 
	  	// need a warning anymore! 
		workIsDone = true;
	 }; 
	</script> 
</cfsavecontent>
<cfhtmlhead text="#SBscript#">
<cfform action="index.cfm?fa=editAction" method="post" name="viewBench">
	<cfinput type="hidden" name="company_id" value="#benchInfo.company_id#" />
	<cfinput type="hidden" name="benchid" value="#attributes.benchID#" />
	<table>
		<tr>
			<td colspan="2">
				<cflayout type="hbox">
					<cflayoutarea style="width:200px" align="center">
						<cfinput type="submit" name="Submit" value="Save and Exit" onClick="fileMyTaxes();" />
					</cflayoutarea>
					<cflayoutarea style="width:200px" align="center">
						<cfinput type="submit" name="Submit" value="Update" onClick="fileMyTaxes();" />
					</cflayoutarea>
					<cflayoutarea style="width:200px" align="center">
						<cfif benchInfo.the_status EQ "O">
							<cfinput type="submit" name="Submit" value="Close" onClick="fileMyTaxes();return checkIt4();" />
						<cfelse>
							<cfinput type="submit" name="Submit" value="Re-Open" onClick="fileMyTaxes();return checkIt();" />
						</cfif>
					</cflayoutarea>
					<cflayoutarea style="width:200px" align="center">
						<cfif cookie.currentrole EQ "Admin" OR cookie.currentrole EQ "Management">
							<cfinput type="submit" name="Submit" value="Delete Benchmark" onClick="fileMyTaxes();return checkIt3();" />
						</cfif>
					</cflayoutarea>
					<cflayoutarea style="width:200px" align="center">
						<cfinput type="submit" name="Submit" value="Exit without Saving" onClick="fileMyTaxes();return checkIt2();" />
					</cflayoutarea>
				</cflayout>
			</td>
		</tr>
		<tr>
			<td colspan="2">
				<cflayout type="tab" name="benchDetails" style="width:1100px">
					<cflayoutarea title="Company Details" align="left" style="height:400px">
						<cfoutput>
							<table width="100%">
								<tr>
									<td colspan="3" valign="top">
										<table>
											<tr>
												<td>
													<strong>Company:</strong>
												</td>
												<td>
													<a href="/control/companies/index.cfm?fa=viewComp&companyNum=#benchInfo.company_id#" target="_blank">#benchInfo.Name#</a>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.City#, #benchInfo.CompanyStateName#</td>
											</tr>
										</table>
									</td>
								</tr>
								<tr>
									<td width="33%" valign="top">
										<table>
											<tr>
												<td>
													<strong>Tax Contact:</strong>
												</td>
												<td>
													<a href="/control/individuals/?fa=viewindiv&indivnum=#benchInfo.contact_tax_id#" target="_blank">
														#benchInfo.taxlastname#, #benchInfo.taxfirstname#
													</a>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.taxtitle#</td>
											</tr>
											<tr>
												<td></td>
												<td>
													<cfif benchInfo.taxphone NEQ "" AND benchInfo.taxphone NEQ "0">
														(#benchInfo.taxac#) #Insert("-", benchInfo.taxphone, 3)#
													</cfif>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.taxwemail#</td>
											</tr>
											<tr>
												<td colspan="2">
													<span style="color:##FF0000">(To change, type in lastname firstname)</span>
												</td>
											</tr>
											<tr>
												<td colspan="2">
													<cfinput type="text" name="tax_contact_id_new" size="25" maxlength="200" autosuggest="url:#request.controlURL#jobads/qryUsers.cfm?term={cfautosuggestvalue}&companyid=#val(benchInfo.company_id)#&sType=ha" maxResultsDisplay="20" showAutoSuggestLoadingIcon="true" />
												</td>
											</tr>
										</table>
									</td>
									<td width="34%" valign="top">
										<table>
											<tr>
												<td>
													<strong>HR Contact:</strong>
												</td>
												<td>
													<a href="/control/individuals/?fa=viewindiv&indivnum=#benchInfo.contact_hr_id#" target="_blank">#benchInfo.hrlastname#, #benchInfo.hrfirstname#</a>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.hrtitle#</td>
											</tr>
											<tr>
												<td></td>
												<td>
													<cfif benchInfo.hrphone NEQ "">
														(#benchInfo.hrac#) #Insert("-", benchInfo.hrphone, 3)#
													</cfif>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.hrwemail#</td>
											</tr>
											<tr>
												<td colspan="2">
													<span style="color:##FF0000">(To change, type in lastname firstname)</span>
												</td>
											</tr>
											<tr>
												<td colspan="2">
													<cfinput type="text" name="hr_contact_id_new" size="25" maxlength="200" autosuggest="url:#request.controlURL#jobads/qryUsers.cfm?term={cfautosuggestvalue}&companyid=#val(benchInfo.company_id)#" maxResultsDisplay="20" showAutoSuggestLoadingIcon="true" />
												</td>
											</tr>
										</table>
									</td>
									<td width="33%" valign="top">
										<table>
											<tr>
												<td>
													<strong>Comp. Consultant:</strong>
												</td>
												<td>
													<a href="/control/individuals/?fa=viewindiv&indivnum=#benchInfo.comp_consultant_id#" target="_blank">
														#benchInfo.complastname#, #benchInfo.compfirstname#
													</a>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.comptitle#</td>
											</tr>
											<tr>
												<td></td>
												<td>
													<cfif benchInfo.compphone NEQ "">
														(#benchInfo.compac#) #Insert("-", benchInfo.compphone, 3)#
													</cfif>
												</td>
											</tr>
											<tr>
												<td></td>
												<td>#benchInfo.compwemail#</td>
											</tr>
											<tr>
												<td colspan="2">
													<span style="color:##FF0000">(To change, type in lastname firstname)</span>
												</td>
											</tr>
											<tr>
												<td colspan="2">
													<cfinput type="text" name="comp_contact_id_new" size="25" maxlength="200" autosuggest="url:#request.controlURL#jobads/qryUsers.cfm?term={cfautosuggestvalue}&companyid=#val(benchInfo.company_id)#" maxResultsDisplay="20" showAutoSuggestLoadingIcon="true" />
												</td>
											</tr>
										</table>
									</td>
								</tr>
							</table>
						</cfoutput>
					</cflayoutarea>
					<cflayoutarea title="Benchmark Details" align="left">
						<table>
							<tr>
								<td valign="top">
									<table>
										<tr>
											<td align="right">
												<strong>Record Created:</strong>
											</td>
											<td>
												<cfoutput>#benchInfo.date_entered#</cfoutput>
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Description:</strong>
											</td>
											<td>
												<cfinput type="text" name="description" size="75" maxlength="200" value="#benchInfo.description#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Start Date:</strong>
											</td>
											<td>
												<cfinput type="text" name="start_date" size="12" value="#benchInfo.start_date#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>End Date:</strong>
											</td>
											<td>
												<cfinput type="text" name="end_date" size="12" value="#benchInfo.end_date#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Date Purchased:</strong>
											</td>
											<td>
												<cfoutput>#benchInfo.date_purchased#</cfoutput>
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Position Title:</strong>
											</td>
											<td align="left">
												<cfinput type="text" name="title" size="75" maxlength="200" value="#benchInfo.title#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Position Location:</strong>
											</td>
											<td align="left">
												<cfinput type="text" name="location" size="50" maxlength="200" value="#benchInfo.location#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Domestic Or Foreign:</strong>
											</td>
											<td align="left">
												<input name="domestic_flag" type="radio" value="True" 
												<cfif benchInfo.domestic_flag EQ "True">
													checked="checked"
												</cfif>
												/>Domestic
												<br />
												<input name="domestic_flag" type="radio" value="False" 
												<cfif benchInfo.domestic_flag EQ "False">
													checked="checked"
												</cfif>
												/>Foreign
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Company Sales Level:</strong>
											</td>
											<td align="left">
												<cfselect width="30" display="Sales_Level" name="Sales_Level" multiple="no" query="QSalesLevel" value="ID" selected="#benchInfo.Sales_Level#"></cfselect>
												<!--- <cfinput type="text" name="Actual_Sales_Per_Million" size="50" maxlength="200" value="#benchInfo.Actual_Sales_Per_Million#" /> --->
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Marketer:</strong>
											</td>
											<td>
												<cfselect name="referral_id" multiple="no" query="recruiterInfo" value="adminid" display="AS400_Initials" queryPosition="below">
													<cfif benchInfo.referral_id  NEQ "0" AND benchInfo.referral_id  NEQ "">
														<cfinvoke component="indiv.basic" method="recruiterByID" adminID="#benchInfo.referral_id#" returnvariable="current_referral" />
														<cfoutput>
															<option value = "#current_referral.adminID#" selected="selected">#current_referral.AS400_Initials#</option>
														</cfoutput>
													<cfelse>
														<!--- <option value = ""></option> --->
													</cfif>
												</cfselect>
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Primary Ops:</strong>
											</td>
											<td>
												<cfselect name="consultant_id" multiple="no" query="recruiterInfo" value="adminid" display="AS400_Initials" queryPosition="below">
													<cfif benchInfo.consultant_id  NEQ "0" AND benchInfo.consultant_id  NEQ "">
														<cfinvoke component="indiv.basic" method="recruiterByID" adminID="#benchInfo.consultant_id#" returnvariable="current_consultant" />
														<cfoutput>
															<option value = "#current_consultant.adminID#" selected="selected">#current_consultant.AS400_Initials#</option>
														</cfoutput>
													<cfelse>
														<!--- <option value = ""></option> --->
													</cfif>
												</cfselect>
											</td>
										</tr>
										<tr>
											<td align="right"><strong>
													Fee:
												</strong></td>
											<td>
												<cfinput type="text" name="fee" size="20" maxlength="50" value="#benchInfo.fee#" />
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Part of Package?</strong>
											</td>
											<td>
												<cfselect name="package" multiple="no">
													<cfif benchInfo.package EQ "False">
														<option value = "No" selected="selected">No</option>
													<cfelse>
														<option value = "No">No</option>
													</cfif>
													<cfloop query="packageInfo">
														<cfoutput>
															<cfif benchInfo.package_id EQ packageInfo.id>
																<option value = "#packageInfo.id#" selected="selected">#packageInfo.description#</option>
															<cfelse>
																<option value = "#packageInfo.id#">#packageInfo.description#</option>
															</cfif>
														</cfoutput>
													</cfloop>
												</cfselect>
											</td>
										</tr>
									</table>
								</td>
								<td valign="top">
									<table>
										<tr>
											<td align="right">
												<strong>General Tax Areas:</strong>
											</td>
											<td>
												<cfselect name="specialty" multiple="yes">
													<option value = "1" 
													<cfif listfind(benchInfo.specialty, "1")>
														selected="selected"
													</cfif>
													>Fed / Gen</option> <option value = "2" 
													<cfif listfind(benchInfo.specialty, "2")>
														selected="selected"
													</cfif>
													>State & Local</option> <option value = "3" 
													<cfif listfind(benchInfo.specialty, "3")>
														selected="selected"
													</cfif>
													>International</option> <option value = "9" 
													<cfif listfind(benchInfo.specialty, "9")>
														selected="selected"
													</cfif>
													>International - Transfer Pricing</option> 
												</cfselect>
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Tax Technology</strong>
											</td>
											<td>
												<cfif benchInfo.tax_technology EQ "true">
													<cfinput type="checkbox" name="tax_technology" value="true" checked="yes" />
												<cfelse>
													<cfinput type="checkbox" name="tax_technology" value="true" />
												</cfif>
											</td>
										</tr>
										<tr>
											<td align="right">
												<strong>Specific Tax Areas:</strong>
											</td>
											<td>
												<cfselect name="sub_specialty" multiple="yes" size="12">
													<cfoutput query="subSpecInfo" group="Specialty_Title">
														<option value = "" style="font-weight:bold">#Specialty_Title#</option>
														<cfoutput>
															<option value = "#subspecialtyid#" 
															<cfif listfind(benchInfo.sub_specialty, "#subspecialtyid#")>
																selected="selected"
															</cfif>
															>&nbsp;&nbsp;#Sub_Title#</option> 
														</cfoutput>
													</cfoutput>
												</cfselect>
											</td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
					</cflayoutarea>
					<cflayoutarea title="Job Specs" align="left"><cfinclude template="dspSpecs.cfm" /></cflayoutarea>
					<cflayoutarea title="Participants" align="left">
						<br />
						(Type Lastname Firstname)
						<br />
						Name: 
						<cfinput type="text" name="isrecnum" size="25" maxlength="200" autosuggest="url:#request.controlUrl#jobads/qryUsers2.cfm?term={cfautosuggestvalue}&companyid=" maxResultsDisplay="20" showAutoSuggestLoadingIcon="true" />
						<br />
						<!--- UserID: <cfinput type="text" name="isrecnum" size="10" maxlength="10"><br /> --->
						<br />
						<br />
						<cfinput type="button" name="newParticpantButton" value="Add New Participant from above" onclick="javascript:ColdFusion.Window.show('newParticipant')" />
						<cfinput type="button" name="newAnonParticpantButton" value="Add New Anonymous Participant" onclick="javascript:ColdFusion.Window.show('newAnonParticipant')" />
						<br />
						<br />
						To change whether or not a Participant is used in the final report, double click in the "Used" column and either check/un-check the check-box.
						<br />
						<!--- <br />
							<br /> --->
						<div>
							<!--- These are actual participants<br /> --->
							<cfgrid format="html" name="participantGrid"  bind="url:GetAllParticipants.cfm?benchid=#attributes.benchID#&page={cfgridpage}&pageSize={cfgridpagesize}&sortCol={cfgridsortcolumn}&sortDir={cfgridsortdirection}" bindonload="yes" width="875" selectonload="yes" pagesize="8" selectmode="edit" onchange="cfc:actEditParticipantList.editParticipantData({cfgridaction},{cfgridrow},{cfgridchanged})" selectcolor="##FF9900">
								<cfgridcolumn name="ID" display="no" />
								<cfgridcolumn name="benchid" display="no" />
								<cfgridcolumn name="indivnum" display=true header="UserID" width="75" select="no" />
								<cfgridcolumn name="full_name" display=true header="Name" width="150" select="no" href="/control/individuals/?fa=viewindiv" hrefkey="indivnum" target="_blank" />
								<cfgridcolumn name="email_work" display=true header="Work Email" width="150" select="no" />
								<cfgridcolumn name="email_home" display=true header="Home Email" width="150" select="no" />
								<cfgridcolumn name="email_other" display=true header="Other Email" width="150" select="no" />
								<cfgridcolumn name="add_date" display=true header="Date Added" width="150" select="no" />
								<cfgridcolumn name="used_in_study" type="boolean" display="true" header="Used" width="50" select="yes" />
							</cfgrid>
							<cfinput type="button" name="editParticpantButton" value="Edit Participant" onclick="javascript:ColdFusion.Window.show('editParticipant')" />
							<cfinput type="button" name="deleteParticpantButton" value="Delete Participant" onclick="javascript:ColdFusion.Window.show('deleteParticipant')" />
							<br />
						</div>
						<br />
						<br />
						<!--- 			<div>	
							These are anonymous participants<br />
							<cfgrid format="html" name="AnonparticipantGrid"  bind="url:actGetAnonParticipans.cfm?benchid=#attributes.benchID#&page={cfgridpage}&pageSize={cfgridpagesize}&sortCol={cfgridsortcolumn}&sortDir={cfgridsortdirection}" bindonload="yes" width="390" selectonload="yes" pagesize="8" selectmode="edit" onchange="cfc:actEditParticipantList.editAnonParticipantData({cfgridaction},{cfgridrow},{cfgridchanged})" selectcolor="##FF9900" >
							<cfgridcolumn name="ID" display="no" />
							<cfgridcolumn name="benchid" display="no" />
							<cfgridcolumn name="indivnum" display=true header="UserID" width="75" select="no" />
							<cfgridcolumn name="full_name" display=true header="Name" width="150" select="no" />
							<cfgridcolumn name="add_date" display=true header="Date Added" width="150" select="no" />
							<cfgridcolumn name="used_in_study" type="boolean" display="true" header="Used" width="50" select="yes" />
							</cfgrid>
							<cfinput type="button" name="editAnonParticpantButton" value="Edit Anonymous Participant" onclick="javascript:ColdFusion.Window.show('editAnonParticipant')">
							<cfinput type="button" name="deleteAnonParticpantButton" value="Delete Anonymous Participant" onclick="javascript:ColdFusion.Window.show('deleteAnonParticipant')">
							</div>	 --->
					</cflayoutarea>
					<!--- <cflayoutarea title="Call Lists" align="left">
						<cfset searchnum = "#attributes.benchID#">
						<cfinclude template="panelCallLists_1.cfm">
						</cflayoutarea>   --->
					<!--- planning Tab --->
					<cflayoutarea title="Planning" name="tab8"><cfinclude template="panelPlanning.cfm"></cflayoutarea>
					<!--- Surveys --->
					<cflayoutarea title="surveys" name="tab9"><cfinclude template="panelSurveys.cfm"></cflayoutarea>
					<!--- Docs --->
					<cflayoutarea title="Documents" align="left" name="tab10"><cfinclude template="panelDocuments.cfm" /></cflayoutarea>
				</cflayout>
			</td>
		</tr>
	</table>
</cfform>
<table>
	<tr>
		<td colspan="2">
			<table width="100%">
				<tr>
					<td width="50%" colspan="2" valign="top" align="center">
						<cfform action="index.cfm?fa=customReportCreate_new" method="post" name="beginClientReport">
							<cfinput type="hidden" name="benchID" value="#attributes.benchID#" />
							<cfif participantsInfo.recordCount EQ "0">
								<cfinput type="submit" name="submit" value="Generate New Reports" onClick="fileMyTaxes();" disabled="disabled" />
							<cfelse>
								<cfinput type="submit" name="submit" value="Generate New Reports" onClick="fileMyTaxes();" />
							</cfif>
						</cfform>
					</td>
					<td width="25%" valign="top" align="center">
						<cfform action="index.cfm?fa=emailStart" method="post" name="beginClientEmail">
							<cfinput type="hidden" name="benchID" value="#attributes.benchID#" />
							<cfinput type="hidden" name="rptp" value="1" />
							<cfif fileExists("#request.controlpath#salarybenchmarking\reports\#attributes.benchID#\#replace(benchInfo.title, " ", "_", "all")#_client.pdf")>
								<cfinput type="submit" name="submit" value="Email Client Report" onClick="fileMyTaxes();" />
								<br />
								<br />
								<cfoutput>
									<a href="#request.controlURL#salarybenchmarking/reports/#attributes.benchID#/#replace(benchInfo.title, " ", "_", "all")#_client.pdf" target="_blank">View Client Report</a>
								</cfoutput>
							<cfelse>
								<cfinput type="submit" name="submit" value="Email Client Report" onClick="fileMyTaxes();" disabled="disabled" />
							</cfif>
						</cfform>
					</td>
					<td width="25%" valign="top" align="center">
						<cfform action="index.cfm?fa=emailStart" method="post" name="beginParticipantEmail">
							<cfinput type="hidden" name="benchID" value="#attributes.benchID#" />
							<cfinput type="hidden" name="rptp" value="2" />
							<cfif fileExists("#request.controlpath#salarybenchmarking\reports\#attributes.benchID#\#replace(benchInfo.title, " ", "_", "all")#_participant.pdf")>
								<cfinput type="submit" name="submit" value="Email Participant Report" onClick="fileMyTaxes();" />
								<br />
								<br />
								<cfoutput>
									<a href="#request.controlURL#salarybenchmarking/reports/#attributes.benchID#/#replace(benchInfo.title, " ", "_", "all")#_participant.pdf" target="_blank">View Participant Report</a>
								</cfoutput>
							<cfelse>
								<cfinput type="submit" name="submit" value="Email Participant Report" onClick="fileMyTaxes();" disabled="disabled" />
							</cfif>
						</cfform>
					</td>
				</tr>
			</table>
		</td>
	</tr>
</table>
<br />
<!--- <cfoutput><a href="index.cfm?fa=customReportCreate&benchID=#attributes.benchID#">Custom Report</a></cfoutput> --->
<cfwindow x="50" y="50" width="840" height="560" name="newParticipant" minHeight="400" minWidth="400" title="New Participant" initshow="false" source="dspNewParticipant.cfm?benchID=#attributes.benchID#&indivnum={isrecnum}" />
<cfwindow x="50" y="50" width="840" height="560" name="newAnonParticipant" minHeight="400" minWidth="600" title="New Anon Participant" initshow="false" source="dspNewAnonParticipant.cfm?benchID=#attributes.benchID#&indivnum=0" />
<cfwindow x="50" y="50" width="840" height="760" name="editParticipant" minHeight="400" minWidth="400" title="Edit Participant" initshow="false" source="dspEditParticipant.cfm?benchID=#attributes.benchID#&partID={participantGrid.id}&fullname={participantGrid.full_name}" />
<cfwindow x="50" y="50" width="840" height="560" name="deleteParticipant" minHeight="400" minWidth="400" title="Delete Participant" initshow="false" source="dspDeleteParticipant.cfm?benchID=#attributes.benchID#&partID={participantGrid.id}" />
<!--- <cfwindow x="50" y="50" width="840" height="760" name="editAnonParticipant" minHeight="400" minWidth="400" title="Edit Anonymous Participant" initshow="false" source="dspEditAnonParticipant.cfm?benchID=#attributes.benchID#&partID={AnonparticipantGrid.id}" destroyonclose="True" />
	<cfwindow x="50" y="50" width="840" height="560" name="deleteAnonParticipant" minHeight="400" minWidth="400" title="Delete Anonymous Participant" initshow="false" source="dspDeleteAnonParticipant.cfm?benchID=#attributes.benchID#&partID={AnonparticipantGrid.id}" destroyonclose="True" /> --->

Open in new window

0
 

Author Comment

by:lantervj
ID: 34185302
CFwindow
<cfset attributes.suppresslayout2 = "true" />
<link rel="stylesheet" type="text/css" href="/control/individuals/indiv.css" title="Global" />
<cfparam name="attributes.partid" default="" />
<cfif attributes.partid NEQ "">
	<cfif url.fullname eq "Anonymous">
		<cfinvoke component="cfc.basic" method="AnonparticipantByID" partid="#url.partid#" returnvariable="partInfo" />
		<cfinvoke component="cfc.basic" method="AnonusersByIndivNum" indivNum="#partInfo.userid#" returnvariable="users" />
		<cfinvoke component="cfc.basic" method="AnonuserInfoByIndivNum" indivNum="#partInfo.userid#" returnvariable="users_Info" />
		<cfinvoke component="indiv.basic" method="companyByCompNum" compNum="#val(users_Info.current_company_number)#" returnvariable="compInfo" />
		<cfinvoke component="cfc.basic" method="AnonskillsByUserID" indivNum="#partInfo.userid#" returnvariable="skillsInfo" />
		<cfinvoke component="cfc.basic" method="AnonsalaryByUserID" indivNum="#partInfo.userid#" returnvariable="users_salary" />
		<cfinvoke component="cfc.basic" method="getBenchSpecialtyById" benchID="#attributes.benchID#" returnvariable="benchInfo" />
		<cfinvoke component="cfc.basic" method="getSpecsByBenchId" benchid="#attributes.benchid#" returnvariable="specInfo" />
	<cfelse>
		<cfinvoke component="cfc.basic" method="participantByID" partid="#attributes.partid#" returnvariable="partInfo" />
		<cfinvoke component="indiv.basic" method="usersByIndivNum" indivNum="#partInfo.userid#" returnvariable="users" />
		<cfinvoke component="indiv.basic" method="userInfoByIndivNum" indivNum="#partInfo.userid#" returnvariable="users_Info" />
		<cfinvoke component="indiv.basic" method="companyByCompNum" compNum="#val(users_Info.current_company_number)#" returnvariable="compInfo" />
		<cfinvoke component="indiv.basic" method="skillsByUserID" indivNum="#partInfo.userid#" returnvariable="skillsInfo" />
		<cfinvoke component="indiv.basic" method="salaryByUserID" indivNum="#partInfo.userid#" returnvariable="users_salary" />
		<cfinvoke component="cfc.basic" method="getBenchSpecialtyById" benchID="#attributes.benchID#" returnvariable="benchInfo" />
		<cfinvoke component="cfc.basic" method="getSpecsByBenchId" benchid="#attributes.benchid#" returnvariable="specInfo" />
	</cfif>
	<cfform name="editParticipantForm">
		<cfinput type="hidden" name="Ecreate_date" value="#dateformat(Now(), "yyyy/mm/dd")#" /> 
		<cfinput type="hidden" name="Ecreate_admin_id" value="#cookie.adminid#" />
		<cfinput type="hidden" name="Efullname" value="#url.fullname#" />
		<cfoutput>
			<cfoutput>(#url.partid#) #partInfo.userid#</cfoutput>
			<table>
				<tr>
					<td colspan="2">
						<table width="100%">
							<tr>
								<td colspan="4" style="background-color:333333;color:FFFFFF;">Company Info</td>
							</tr>
							<tr>
								<td>
									<a target="_blank" href="/control/companies/index.cfm?fa=viewcomp&CompanyNum=<cfoutput>#users_Info.current_company_number#</cfoutput>">Company:</a>
									:
								</td>
								<cfif compInfo.US_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##FFFF00" />
									<cfelseif compInfo.US_Subsidiary_US_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##00FFFF" />
									<cfelseif compInfo.US_Headquarters_Foreign_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##00FF00" />
									<cfelseif compInfo.Foreign_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##FF0000" />
									<cfelseif compInfo.US_Subsidiary_Foreign_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##FF00FF" />
									<cfelseif compInfo.Foreign_Subsidiary_Foreign_Parent EQ "true">
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" style="background-color:##000000; color:##0000FF" />
									<cfelse>
									<td style="width:140">
										<cfinput type="text" name="Ecurrent_company_name" value="#compInfo.name#" size="25" maxlength="75" />
									</td>
								</cfif>
								<td>Company Type:</td>
								<td>
									<cfinput type="text" name="Ecompany_type" value="#partInfo.company_type#" size="25" maxlength="75" />
								</td>
							</tr>
							<tr>
								<td>Company Location:</td>
								<td>#compInfo.city#, #compInfo.state#</td>
								<td>Company Revenue:</td>
								<td>
									<cfinput type="text" name="Eactual_sales_per_million" value="#compInfo.actual_sales_per_million#" size="25" maxlength="75" />
									(In millions) 
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						<table width="100%">
							<tr>
								<td colspan="4" style="background-color:333333;color:FFFFFF;">Individual Info</td>
							</tr>
							<tr>
								<td>Name:</td>
								<td>
									<cfinput type="text" name="Efirstname" value="#users_Info.firstname#" size="25" maxlength="50" style="background-color:##FFFFCC; color:##000000; font-weight:bold; border: 1px solid ##000000" />
									<cfinput type="text" name="Elastname" value="#users_Info.lastname#" size="25" maxlength="75" style="background-color:##FFFFCC; color:##000000; font-weight:bold; border: 1px solid ##000000" />
								</td>
								<td>Title:</td>
								<td>
									<cfselect name="Etitle_number" multiple="no">
										<option value="" style="font-weight:bold">Tax</option>
										<option value="11" 
										<cfif users_info.title_number EQ "11">
											selected="selected"
										</cfif>
										>Non Equity Partner</option> <option value="52" 
										<cfif users_info.title_number EQ "52">
											selected="selected"
										</cfif>
										>National Tax Partner</option> <option value="12" 
										<cfif users_info.title_number EQ "12">
											selected="selected"
										</cfif>
										>Regional Tax Partner</option> <option value="13" 
										<cfif users_info.title_number EQ "13">
											selected="selected"
										</cfif>
										>Managing Tax Partner</option> <option value="14" 
										<cfif users_info.title_number EQ "14">
											selected="selected"
										</cfif>
										>PIC - Tax</option> <option value="15" 
										<cfif users_info.title_number EQ "15">
											selected="selected"
										</cfif>
										>Partner</option> <option value="53" 
										<cfif users_info.title_number EQ "53">
											selected="selected"
										</cfif>
										>Sr. Vice President Tax</option> <option value="16" 
										<cfif users_info.title_number EQ "16">
											selected="selected"
										</cfif>
										>Vice President Tax</option> <option value="17" 
										<cfif users_info.title_number EQ "17">
											selected="selected"
										</cfif>
										>Asst. Vice President Tax</option> <option value="54" 
										<cfif users_info.title_number EQ "54">
											selected="selected"
										</cfif>
										>Tax Controller </option> <option value="55" 
										<cfif users_info.title_number EQ "55">
											selected="selected"
										</cfif>
										>Sr. Director</option> <option value="18" 
										<cfif users_info.title_number EQ "18">
											selected="selected"
										</cfif>
										>Director/Principal</option> <option value="19" 
										<cfif users_info.title_number EQ "19">
											selected="selected"
										</cfif>
										>Asst. Director</option> <option value="27" 
										<cfif users_info.title_number EQ "27">
											selected="selected"
										</cfif>
										>General Counsel - Tax</option> <option value="28" 
										<cfif users_info.title_number EQ "28">
											selected="selected"
										</cfif>
										>Sr. Tax Counsel</option> <option value="29" 
										<cfif users_info.title_number EQ "29">
											selected="selected"
										</cfif>
										>Tax Counsel/Atty</option> <option value="20" 
										<cfif users_info.title_number EQ "20">
											selected="selected"
										</cfif>
										>Sr. Manager</option> <option value="21" 
										<cfif users_info.title_number EQ "21">
											selected="selected"
										</cfif>
										>Manager</option> <option value="22" 
										<cfif users_info.title_number EQ "22">
											selected="selected"
										</cfif>
										>Asst Manager</option> <option value="23" 
										<cfif users_info.title_number EQ "23">
											selected="selected"
										</cfif>
										>Supervisor</option> <option value="24" 
										<cfif users_info.title_number EQ "24">
											selected="selected"
										</cfif>
										>Senior/Consultant</option> <option value="25" 
										<cfif users_info.title_number EQ "25">
											selected="selected"
										</cfif>
										>Staff/Accountant</option> <option value="26" 
										<cfif users_info.title_number EQ "26">
											selected="selected"
										</cfif>
										>Self Employed</option> <option value="50" 
										<cfif users_info.title_number EQ "50">
											selected="selected"
										</cfif>
										>Intern</option> 
										<option value=""></option>
										<option value="" style="font-weight:bold">Non-Tax Corporate</option>
										<option value="1" 
										<cfif users_info.title_number EQ "1">
											selected="selected"
										</cfif>
										>Chairman of the Board</option> <option value="2" 
										<cfif users_info.title_number EQ "2">
											selected="selected"
										</cfif>
										>Chief Executive Officer</option> <option value="3" 
										<cfif users_info.title_number EQ "3">
											selected="selected"
										</cfif>
										>Chief Financial Officer</option> <option value="65" 
										<cfif users_info.title_number EQ "65">
											selected="selected"
										</cfif>
										>Chief Diversity Officer</option> <option value="4" 
										<cfif users_info.title_number EQ "4">
											selected="selected"
										</cfif>
										>President</option> <option value="5" 
										<cfif users_info.title_number EQ "5">
											selected="selected"
										</cfif>
										>Vice President</option> <option value="6" 
										<cfif users_info.title_number EQ "6">
											selected="selected"
										</cfif>
										>Treasurer (& Asst)</option> <option value="7" 
										<cfif users_info.title_number EQ "7">
											selected="selected"
										</cfif>
										>Corporate Controller</option> <option value="8" 
										<cfif users_info.title_number EQ "8">
											selected="selected"
										</cfif>
										>Assistant Corporate Controller</option> <option value="9" 
										<cfif users_info.title_number EQ "9">
											selected="selected"
										</cfif>
										>General Counsel Non Tax</option> <option value="10" 
										<cfif users_info.title_number EQ "10">
											selected="selected"
										</cfif>
										>Vice President Non Tax</option> <option value="64" 
										<cfif users_info.title_number EQ "64">
											selected="selected"
										</cfif>
										>Administrative Assistant</option> 
										<option value=""></option>
										<option value="" style="font-weight:bold">HR</option>
										<option value="56" 
										<cfif users_info.title_number EQ "56">
											selected="selected"
										</cfif>
										>Recruiter</option> <option value="62" 
										<cfif users_info.title_number EQ "62">
											selected="selected"
										</cfif>
										>ExPat-HR</option> <option value="63" 
										<cfif users_info.title_number EQ "63">
											selected="selected"
										</cfif>
										>ExPat-Admin</option> 
										<option value=""></option>
										<option value="" style="font-weight:bold">Education</option>
										<option value="57" 
										<cfif users_info.title_number EQ "57">
											selected="selected"
										</cfif>
										>Accounting/Tax Professor</option> <option value="58" 
										<cfif users_info.title_number EQ "58">
											selected="selected"
										</cfif>
										>Law Professor</option> <option value="59" 
										<cfif users_info.title_number EQ "59">
											selected="selected"
										</cfif>
										>Graduate Student </option> <option value="60" 
										<cfif users_info.title_number EQ "60">
											selected="selected"
										</cfif>
										>Undergraduate Student</option> 
										<option value=""></option>
										<option value="" style="font-weight:bold">Advertising Agency</option>
										<option value="61" 
										<cfif users_info.title_number EQ "61">
											selected="selected"
										</cfif>
										>Account Executive</option> 
										<!--- <cfoutput query="skillList1"><option value = "#id#">#description#</option></cfoutput> --->
									</cfselect>
								</td>
							</tr>
							<tr>
								<td>W Email:</td>
								<td>
									<cfinput type="text" name="Eemail_work" value="#users.email_work#" size="50" maxlength="75" />
								</td>
								<td>H Email:</td>
								<td>
									<cfinput type="text" name="Eemail_home" value="#users.email_home#" size="50" maxlength="75" />
								</td>
							</tr>
							<tr>
								<td>Send Report?</td>
								<td>
									<input type="radio" name="Esend_report" value="True" 
									<cfif partInfo.send_report EQ "True">
										checked="checked"
									</cfif>
									/>Yes <input type="radio" name="Esend_report" value="False" 
									<cfif partInfo.send_report EQ "False">
										checked="checked"
									</cfif>
									/>No
								</td>
								<td>Send To:</td>
								<td>
									<input type="radio" name="Esend_to" value="Home" 
									<cfif partInfo.send_to EQ "Home">
										checked="checked"
									</cfif>
									/>Home <input type="radio" name="Esend_to" value="Work" 
									<cfif partInfo.send_to EQ "Work">
										checked="checked"
									</cfif>
									/>Work <input type="radio" name="Esend_to" value="Other" 
									<cfif partInfo.send_to EQ "Other">
										checked="checked"
									</cfif>
									/>Other
								</td>
							</tr>
							<tr>
								<td colspan="2"></td>
								<td>Other Email:</td>
								<td>
									<cfinput type="text" name="Eemail_other" value="#partInfo.email_other#" size="50" maxlength="75" />
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						<table  width="100%">
							<tr>
								<td colspan="4" style="background-color:333333;color:FFFFFF;">Experience</td>
							</tr>
							<tr>
								<td>Year Started in Tax:</td>
								<td>
									<cfinput type="text" name="Eyear_started_in_tax" value="#users_info.year_started_in_tax#" size="20" maxlength="75" />
								</td>
								<td>Foreign Language:</td>
								<td>
									<cfquery name="skillList" datasource="#request.dsn#">
										SELECT * FROM users_skill_mask WHERE Skill_Number = 5 
									</cfquery>
									<cfselect name="Eskill_5" multiple="yes" size="5">
										<cfloop query="skillList">
											<cfquery name="skillCheck" dbtype="query">
												SELECT * FROM skillsInfo WHERE UserID = 
												<cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND Skill_Mask_Number = 5 AND skill_line_number = #skillList.line_number# 
											</cfquery>
											<cfif skillCheck.recordcount EQ "0">
												<option value="#skillList.line_number#">#skillList.description#</option>
											<cfelse>
												<option value="#skillList.line_number#" selected="selected">#skillList.description#</option>
											</cfif>
										</cfloop>
									</cfselect>
								</td>
								<td>
									Other:
									<br />
									<cfinput type="text" name="Eother_language" value="#partInfo.other_language#" size="20" maxlength="50" />
								</td>
							</tr>
							<tr>
								<td valign="middle">Past/Present Employer:</td>
								<td colspan="4" valign="middle">
									Public: 
									<cfif users_info.past_public_flag EQ "true">
										<cfinput type="checkbox" name="Epast_public_flag" value="true" checked="yes" />
									<cfelse>
										<cfinput type="checkbox" name="Epast_public_flag" value="true" />
									</cfif>
									Corp: 
									<cfif users_info.past_corp_flag EQ "true">
										<cfinput type="checkbox" name="Epast_corp_flag" value="true" checked="yes" />
									<cfelse>
										<cfinput type="checkbox" name="Epast_corp_flag" value="true" />
									</cfif>
									Law: 
									<cfif users_info.past_law_flag EQ "true">
										<cfinput type="checkbox" name="Epast_law_flag" value="true" checked="yes" />
									<cfelse>
										<cfinput type="checkbox" name="Epast_law_flag" value="true" />
									</cfif>
									Gov't: 
									<cfif users_info.past_govt_flag EQ "true">
										<cfinput type="checkbox" name="Epast_govt_flag" value="true" checked="yes" />
									<cfelse>
										<cfinput type="checkbox" name="Epast_govt_flag" value="true" />
									</cfif>
								</td>
							</tr>
							<tr>
								<td>Qualitative Factors:</td>
								<td colspan="4">
									<cfinput type="text" name="EQualitative_Factors" value="#partInfo.Qualitative_Factors#" size="100" />
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td valign="top">
						<table width="100%">
							<tr>
								<td colspan="2" style="background-color:333333;color:FFFFFF;">Education</td>
							</tr>
							<tr>
								<td valign="top">
									<cfquery name="skillList" datasource="#request.dsn#">
										SELECT * FROM users_skill_mask WHERE Skill_Number = 2 
									</cfquery>
									<cfselect name="Eskill_2" multiple="yes" size="5">
										<cfloop query="skillList">
											<cfquery name="skillCheck" dbtype="query">
												SELECT * FROM skillsInfo WHERE UserID = 
												<cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND Skill_Mask_Number = 2 AND skill_line_number = #skillList.line_number# 
											</cfquery>
											<cfif skillCheck.recordcount EQ "0">
												<option value="#skillList.line_number#">#skillList.description#</option>
											<cfelse>
												<option value="#skillList.line_number#" selected="selected">#skillList.description#</option>
											</cfif>
										</cfloop>
									</cfselect>
								</td>
								<td valign="top">
									Other:
									<br />
									<cfinput type="text" name="Eother_education" value="#partInfo.other_education#" size="20" maxlength="50" />
								</td>
							</tr>
						</table>
					</td>
					<td valign="top">
						<table width="100%">
							<tr>
								<td colspan="2" style="background-color:333333;color:FFFFFF;">Management Experience</td>
							</tr>
							<tr>
								<td valign="top">Tax Dept Size:</td>
								<td valign="top">&nbsp;</td>
							</tr>
							<tr>
								<td valign="top">Non-US / US</td>
								<td valign="top">
									<cfinput type="text" name="Ereport_ww" size="5" maxlength="10" value="#partInfo.report_ww#" />
									/ 
									<cfinput type="text" name="Ereport_us" size="5" maxlength="10" value="#partInfo.report_us#" />
								</td>
							</tr>
							<tr>
								<td valign="top">Report (Direct/Total)</td>
								<td valign="top">
									<cfinput type="text" name="Ereport_direct" value="#partInfo.report_direct#" size="5" maxlength="10" />
									/ 
									<cfinput type="text" name="Ereport_total" value="#partInfo.report_total#" size="5" maxlength="10" />
								</td>
							</tr>
							<tr>
								<td colspan="2">
									<cfdiv id="TaxDeptSize" bind="url:TaxDeptSizeDiv.cfm?SizeNonUS={Ereport_ww}&SizeUS={Ereport_us}&namePrefix=E" />
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						<table  width="100%">
							<tr>
								<td colspan="4" style="background-color:333333;color:FFFFFF;">Compensation</td>
							</tr>
							<tr>
								<td colspan="4">
									<strong>
										All monetary fields to input in thousands per year. Ex: IF Salary is $265,000, input 265. If Bonus is $15,000, input 15.
									</strong>
								</td>
							</tr>
							<tr>
								<td valign="top">
									Base Salary: $ 
									<cfinput type="text" name="Eissalc" value="#users_info.current_salary#" size="3" maxlength="4" />
									<!--- <br />
										SALARY INFO INPUT IN THOUSANDS PER YEAR<br />
										(EX: If salary is $265,500 then input 265) --->
								</td>
								<td valign="top">
									Target Bonus:
									<cfinput type="text" name="Etarget_bonus" value="#partInfo.target_bonus#" size="6" maxlength="10" />
								</td>
								<td valign="top">
									Bonus: $ 
									<cfinput type="text" name="Eisbnus" value="#users_salary.isbnus#" size="3" maxlength="4" />
								</td>
								<td valign="top">
									Next Review Date:
									<cfinput type="text" name="Enext_review_date" value="#partInfo.next_review_date#" size="6" maxlength="10" />
								</td>
							</tr>
							<tr>
								<td>
									Stock Grant (RSU): $ 
									<cfinput type="text" name="Eisstck" value="#users_salary.isstck#" size="3" maxlength="10" />
								</td>
								<td>
									Vesting: 
									<cfinput type="text" name="Evesting" size="20" maxlength="50" value="#partInfo.vesting#" />
								</td>
								<td>
									Stock Options: 
									<cfinput type="text" name="Estock_options_count" size="10" maxlength="20" value="#partInfo.stock_options_count#" />
								</td>
								<td>
									Vest: 
									<cfinput type="text" name="Evest" size="20" maxlength="50" value="#partInfo.vest#" />
								</td>
							</tr>
							<tr>
								<!--- <td>Stock Options: <cfif users_salary.isbon1 EQ "X">
									<cfinput id="Eisbon1a" type="radio" name="Eisbon1" value="X" checked="yes">Yes 
									<cfinput id="Eisbon1b" type="radio" name="Eisbon1" value="">No
								<cfelse>
									<cfinput id="Eisbon1a" type="radio" name="Eisbon1" value="X">Yes 
									<cfinput id="Eisbon1b" type="radio" name="Eisbon1" value="" checked="yes">No
									</cfif>
									</td> --->
								<td>
									401K Match: 
									<cfif users_salary.isbon2 EQ "X">
										<cfinput id="Eisbon2a" type="radio" name="Eisbon2" value="X" checked="yes" />
										Yes 
										<cfinput id="Eisbon2b" type="radio" name="Eisbon2" value="" />
										No 
									<cfelse>
										<cfinput id="Eisbon2a" type="radio" name="Eisbon2" value="X" />
										Yes 
										<cfinput id="Eisbon2b" type="radio" name="Eisbon2" value="" checked="yes" />
										No 
									</cfif>
								</td>
								<td>
									Pension: 
									<cfif users_salary.isbon3 EQ "X">
										<cfinput id="Eisbon3a" type="radio" name="Eisbon3" value="X" checked="yes" />
										Yes 
										<cfinput id="Eisbon3b" type="radio" name="Eisbon3" value="" />
										No 
									<cfelse>
										<cfinput id="Eisbon3a" type="radio" name="Eisbon3" value="X" />
										Yes 
										<cfinput id="Eisbon3b" type="radio" name="Eisbon3" value="" checked="yes" />
										No 
									</cfif>
								</td>
								<td>
									Car: 
									<cfif users_salary.isbon4 EQ "X">
										<cfinput id="Eisbon4a" type="radio" name="Eisbon4" value="X" checked="yes" />
										Yes 
										<cfinput id="Eisbon4b" type="radio" name="Eisbon4" value="" />
										No 
									<cfelse>
										<cfinput id="Eisbon4a" type="radio" name="Eisbon4" value="X" />
										Yes 
										<cfinput id="Eisbon4b" type="radio" name="Eisbon4" value="" checked="yes" />
										No 
									</cfif>
								</td>
								<td>
									Yearly Car Allowance: $ 
									<cfinput type="text" name="Eisbon7" value="#users_salary.isbon7#" size="3" maxlength="4" />
								</td>
							</tr>
							<tr>
								<td colspan="3">
									Other Perks (Car/Health/Country Club/Other): 
									<cfinput type="text" name="Eother_perks" size="20" maxlength="50" value="#partInfo.other_perks#" />
								</td>
								<td>
									SERP/LTIP: 
									<cfinput type="text" name="Eserp_ltip" size="20" maxlength="50" value="#partInfo.serp_ltip#" />
								</td>
							</tr>
							<cfif specInfo.other_comp_1 NEQ "" OR specInfo.other_comp_2 NEQ "" OR specInfo.other_comp_3 NEQ "" OR specInfo.other_comp_4 NEQ "">
								<tr>
									<td colspan="4">Other Compensation (Enter input in thousands per year)</td>
								</tr>
								<tr>
									<td>
										<cfif specInfo.other_comp_1 NEQ "">
											#specInfo.other_comp_1#:
											<cfinput type="text" name="Eother_comp_1" value="#partInfo.other_comp_1#" size="3" maxlength="4" />
										</cfif>
									</td>
									<td>
										<cfif specInfo.other_comp_2 NEQ "">
											#specInfo.other_comp_2#:
											<cfinput type="text" name="Eother_comp_2" value="#partInfo.other_comp_2#" size="3" maxlength="4" />
										</cfif>
									</td>
									<td>
										<cfif specInfo.other_comp_3 NEQ "">
											#specInfo.other_comp_3#:
											<cfinput type="text" name="Eother_comp_3" value="#partInfo.other_comp_3#" size="3" maxlength="4" />
										</cfif>
									</td>
									<td>
										<cfif specInfo.other_comp_4 NEQ "">
											#specInfo.other_comp_4#:
											<cfinput type="text" name="Eother_comp_4" value="#partInfo.other_comp_4#" size="3" maxlength="4" />
										</cfif>
									</td>
								</tr>
							</cfif>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						<table  width="100%">
							<tr>
								<td colspan="3" style="background-color:333333;color:FFFFFF;">Functional/Technical</td>
							</tr>
							<tr>
								<td width="33%" valign="top">
									<table width="100%">
										<tr>
											<td colspan="3">General Tax Areas</td>
										</tr>
										<tr>
											<td style="width:60">
												<cfinput type="text" name="Eistec1" value="#users_salary.istec1#" size="2" maxlength="3" />
												%
											</td>
											<td style="width:35">
												<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.istec1#" returnvariable="letter" />
												#letter#
											</td>
											<td style="width:140">Federal</td>
										</tr>
										<tr>
											<td style="width:60">
												<cfinput type="text" name="Eistec2" value="#users_salary.istec2#" size="2" maxlength="3" />
												%
											</td>
											<td style="width:35">
												<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.istec2#" returnvariable="letter" />
												#letter#
											</td>
											<td style="width:140">State/Local</td>
										</tr>
										<tr>
											<td style="width:60">
												<cfinput type="text" name="Eistec3" value="#users_salary.istec3#" size="2" maxlength="3" />
												%
											</td>
											<td style="width:35">
												<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.istec3#" returnvariable="letter" />
												#letter#
											</td>
											<td style="width:140">International</td>
										</tr>
										<tr>
											<td colspan="4">
												<cfdiv id="UsersSpecialtyDiv" bind="url:UserSpecialtyDiv.cfm?Tec1={Eistec1}&Tec2={Eistec2}&Tec3={Eistec3}&namePrefix=E" bindonload="true" />
											
											</td>
										</tr>
									</table>
									<table>
										<tr>
											<td colspan="3">International Specific</td>
										</tr>
										<cfif url.fullname eq "Anonymous">
											<cfset ETableName1 = "salarybenchmarking_anon_users_subspecialty">
											<cfset ETableName2 = "salarybenchmarking_users_subspecialty">
										<cfelse>
											<cfset ETableName1 = "users_subspecialty">
											<cfset ETableName2 = "salarybenchmarking_users_subspecialty">
										</cfif>
										<cfquery name="subSpecList" datasource="#request.dsn#">
											SELECT * FROM Subspecialty WHERE specialtyID = '3' 
										</cfquery>
										<cfloop query="subSpecList">
											<cfquery name="subSpecCheck" datasource="#request.dsn#">
												SELECT * 
												FROM #ETableName1# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid# 
												Union All
												SELECT * 
												FROM #ETableName2# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid#
											</cfquery>
											<tr>
												<td style="width:60">
													<input type="text" name="Esubspec_#subSpecList.subspecialtyid#" id="Esubspec_#subSpecList.subspecialtyid#" size="2" 
													<cfif subSpecCheck.recordCount GT "0">
														value="#subSpecCheck.percentage#"
													</cfif>
													/> %
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpecCheck.percentage#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">#title#</td>
											</tr>
										</cfloop>
									</table>
								</td>
								<td width="34%" valign="top">
									<table>
										<tr>
											<td colspan="3">State/Local Specific</td>
										</tr>
										<cfquery name="subSpecList" datasource="#request.dsn#">
											SELECT * FROM Subspecialty WHERE specialtyID = '2' 
										</cfquery>
										<cfloop query="subSpecList">
											<cfquery name="subSpecCheck" datasource="#request.dsn#">
												SELECT * 
												FROM #ETableName1# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid# 
												Union All
												SELECT * 
												FROM #ETableName2# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid#
											</cfquery>
											<tr>
												<td style="width:60">
													<input type="text" name="Esubspec_#subSpecList.subspecialtyid#" id="Esubspec_#subSpecList.subspecialtyid#" size="2" 
													<cfif subSpecCheck.recordCount GT "0">
														value="#subSpecCheck.percentage#"
													</cfif>
													/> %
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpecCheck.percentage#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">#title#</td>
											</tr>
										</cfloop>
										<tr>
											<td style="width:60">
												<input type="text" name="Esnl_other_percentage" size="2" />
												%
											</td>
											<td style="width:35">Other</td>
											<td style="width:140"><input type="text" name="Esnl_other" size="20" /></td>
										</tr>
										<tr>
											<td colspan="3">Federal Specific</td>
										</tr>
										<cfquery name="subSpecList" datasource="#request.dsn#">
											SELECT * FROM Subspecialty WHERE specialtyID = '1' 
										</cfquery>
										<cfloop query="subSpecList">
											<cfquery name="subSpecCheck" datasource="#request.dsn#">
												SELECT * 
												FROM #ETableName1# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid# 
												Union All
												SELECT * 
												FROM #ETableName2# 
												WHERE UserID = <cfqueryparam value="#partInfo.userid#" cfsqltype="CF_SQL_NUMERIC" maxlength="10"/>
												AND subspecialtyid = #subSpecList.subspecialtyid#
											</cfquery>
											<tr>
												<td style="width:60">
													<input type="text" name="Esubspec_#subSpecList.subspecialtyid#" id="Esubspec_#subSpecList.subspecialtyid#" size="2" 
													<cfif subSpecCheck.recordCount GT "0">
														value="#subSpecCheck.percentage#"
													</cfif>
													/> %
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpecCheck.percentage#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">#title#</td>
											</tr>
										</cfloop>
										<tr>
											<td style="width:60">
												<input type="text" name="Efed_other_percentage" size="2" />
												%
											</td>
											<td style="width:35">Other</td>
											<td style="width:140"><input type="text" name="Efed_other" size="20" /></td>
										</tr>
									</table>
								</td>
								<td width="33%" valign="top">
									<table>
										<tr>
											<td colspan="3">Functional</td>
										</tr>
										<cfif benchInfo.specialty EQ "9">
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun8" value="#users_salary.isfun8#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun8#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Docu/Impl</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun9" value="#users_salary.isfun9#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun9#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">APA</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun10" value="#users_salary.isfun10#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun10#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Planning</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun11" value="#users_salary.isfun11#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun11#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Audit Defense</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun12" value="#users_salary.isfun12#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun12#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Compliance</td>
											</tr>
										<cfelseif benchInfo.tax_technology EQ "true">
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun13" value="#users_salary.isfun13#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun13#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Tax</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun14" value="#users_salary.isfun14#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun14#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Systems</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun15" value="#users_salary.isfun15#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun15#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Compliance</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun16" value="#users_salary.isfun16#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun16#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Design & Impl</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun17" value="#users_salary.isfun17#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun17#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Corp Tax Admin</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun18" value="#users_salary.isfun18#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun18#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Mapping & Bridge</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun19" value="#users_salary.isfun19#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun19#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Tax Acct</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun20" value="#users_salary.isfun20#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun20#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Planning</td>
											</tr>
										<cfelse>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun7" value="#users_salary.isfun7#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun7#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">M/A</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun1" value="#users_salary.isfun1#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun1#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Other Plan</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun2" value="#users_salary.isfun2#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun2#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Compl Prep</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun3" value="#users_salary.isfun3#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun3#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Compl Review</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun4" value="#users_salary.isfun4#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun4#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">FAS 109</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun5" value="#users_salary.isfun5#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun5#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Audit/Appeal</td>
											</tr>
											<tr>
												<td style="width:60">
													<cfinput type="text" name="Eisfun6" value="#users_salary.isfun6#" size="2" maxlength="3" />
													%
												</td>
												<td style="width:35">
													<cfinvoke component="indiv.basic" method="getPercLetter" perc="#users_salary.isfun6#" returnvariable="letter" />
													#letter#
												</td>
												<td style="width:140">Litigation</td>
											</tr>
										</cfif>
									</table>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						Note: 
						<cftextarea name="Enotes" cols="95" rows="5">#partInfo.notes#</cftextarea>
					</td>
				</tr>
				<tr>
					<td colspan="2">
						<cfinput type="hidden" name="Eindivnum" value="#partInfo.userid#" />
						<cfinput type="hidden" name="Ebenchid" value="#url.benchid#" />
						<cfinput type="hidden" name="Ecompanyid" value="#val(users_Info.current_company_number)#" />
						<cfinput type="button" name="submit" value="Submit Document" onclick="javascript:submitFrm2();" />
					</td>
				</tr>
			</table>
		</cfoutput>
	</cfform>
<cfelse>
	You did not enter a Individual's ID number. Close window and try again. 
</cfif>

Open in new window

0
 

Author Comment

by:lantervj
ID: 34185304
CFdiv source
<cfset attributes.suppresslayout2 = "true">
<cfparam name="url.Tec1" default="0" />
<cfparam name="url.Tec2" default="0" />
<cfparam name="url.Tec3" default="0" />
<!---  name prefix is needed to differentiate between regular participants and anonymous participants and add/edit  vaughn 2001/11/16 --->
<cfparam name="url.namePrefix" default="" />
<!--- <cfoutput>
url.Tec1: #url.Tec1#<br>
url.Tec2: #url.Tec2#<br>
url.Tec3: #url.Tec3#<br>

</cfoutput> --->

<cfif isdefined("url.Tec1")>
<cfform name="divForm">
<cfoutput>
	<cfif val(url.Tec3) gt 24>
		<cfset SetUserSpecialty= "International">
		<cfset SetUserSpecialtyID= "3">
	<cfelseif val(url.Tec2) gt 49>
		<cfset SetUserSpecialty= "State/Local">
		<cfset SetUserSpecialtyID= "2">
	<cfelse>
		<cfset SetUserSpecialty= "Fed/Gen">
		<cfset SetUserSpecialtyID= "1">
	</cfif>
	<cfset TotalOfTecs = #val(url.tec1)#+#val(url.tec2)#+#val(url.tec3)#>
	<cfif val(TotalOfTecs) neq 100>
		<th style="background-color:ff0000;color:FFFFFF;">#val(TotalOfTecs)#%</th>
	</cfif>
	User Specialty
		<cfinput type="text" name="#namePrefix#UserSpecialtyID" id="#namePrefix#UserSpecialtyID" value="#SetUserSpecialtyID#" size="3" disabled/>
		<cfinput type="text" name="#namePrefix#UserSpecialty" id="#namePrefix#UserSpecialty" value="#SetUserSpecialty#" size="20" maxlength="20" disabled/>
		

</cfoutput>
</cfform>
</cfif>

Open in new window

0
 

Author Comment

by:lantervj
ID: 34185306
action page
<cfset attributes.suppresslayout2 = "true" />
<cfparam name="form.Ebenchid" type="integer" />
<cfparam name="form.Eindivnum" type="integer" />
<cfparam name="form.Ecompanyid" type="integer" />


<cfinvoke component="cfc.basic" method="getBenchSpecialtyById" benchID="#attributes.EbenchID#" returnvariable="benchInfo" />
<cfquery name="subSpecList" datasource="#request.dsn#">
	SELECT * FROM Subspecialty 
</cfquery>
<cfif Efullname eq "Anonymous">
	<cfquery name="kill_sub_specs" datasource="#request.dsn#">
		DELETE FROM SalaryBenchmarking_Anon_Users_SubSpecialty WHERE userID = #val(form.Eindivnum)# 
	</cfquery>
	<cfquery name="kill_sub_specs" datasource="#request.dsn#">
		DELETE FROM SalaryBenchmarking_Users_SubSpecialty WHERE userID = #val(form.Eindivnum)# 
	</cfquery>
	<cfloop query="subSpecList">
		<cfif isdefined("form.ESUBSPEC_#subSpecList.currentrow#")>
			<cfset subSpec_value = Evaluate("form.ESUBSPEC_" & "#subSpecList.currentrow#") />
			<cfif subSpec_value EQ "0">
				<cfset subSpec_value = "" />
			</cfif>
			<cfif subSpec_value NEQ "">
				<cfif subSpecList.SpecialtyID eq "#val(form.EUserSpecialtyID)#">
					<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpec_value#" returnvariable="letter" />
					<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
						INSERT INTO SalaryBenchmarking_Anon_Users_SubSpecialty (UserID, SubSpecialtyID, ABC, Percentage) VALUES(#val(form.Eindivnum)#, #subSpecList.currentrow#, '#letter#', '#subSpec_value#') 
					</cfquery>
				<cfelse>
					<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpec_value#" returnvariable="letter" />
					<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
						INSERT INTO salarybenchmarking_users_SubSpecialty (UserID, SubSpecialtyID, ABC, Percentage) VALUES(#val(form.Eindivnum)#, #subSpecList.currentrow#, '#letter#', '#subSpec_value#') 
					</cfquery>
				</cfif>
			</cfif>
		</cfif>
	</cfloop>
<cfelse>
	<cfquery name="kill_sub_specs" datasource="#request.dsn#">
		DELETE FROM Users_SubSpecialty WHERE userID = '#form.Eindivnum#' 
	</cfquery>
	<cfquery name="kill_sub_specs" datasource="#request.dsn#">
		DELETE FROM salarybenchmarking_users_SubSpecialty WHERE userID = '#form.Eindivnum#' 
	</cfquery>
	<cfloop query="subSpecList">
		<cfif isdefined("form.ESUBSPEC_#currentrow#")>
			<cfset subSpec_value = Evaluate("form.ESUBSPEC_" & "#currentrow#") />
			<cfif subSpec_value EQ "0">
				<cfset subSpec_value = "" />
			</cfif>
			<cfif subSpec_value NEQ "">
				<cfif subSpecList.SpecialtyID eq "#form.EUserSpecialtyID#">
					<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpec_value#" returnvariable="letter" />
					<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
						INSERT INTO Users_SubSpecialty (UserID, SubSpecialtyID, ABC, Percentage) VALUES('#form.Eindivnum#', '#currentrow#', '#letter#', '#subSpec_value#') 
					</cfquery>
				<cfelse>
					<cfinvoke component="indiv.basic" method="getPercLetter" perc="#subSpec_value#" returnvariable="letter" />
					<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
						INSERT INTO salarybenchmarking_users_SubSpecialty (UserID, SubSpecialtyID, ABC, Percentage) VALUES('#form.Eindivnum#', '#currentrow#', '#letter#', '#subSpec_value#') 
					</cfquery>
				</cfif>
			</cfif>
		</cfif>
	</cfloop>
</cfif>
<!--- salaryBenchmarking_Participants --->
<cfparam name="form.Ecompany_type" default="" />
<cfparam name="form.Eother_language" default="" />
<cfparam name="form.Eother_education" default="" />
<cfparam name="form.Ereport_direct" default="" />
<cfparam name="form.Ereport_total" default="" />
<cfparam name="form.Enext_review_date" default="" />
<cfparam name="form.Estock_options_count" default="" />
<cfparam name="form.Eserp_ltip" default="" />
<cfparam name="form.Eother_perks" default="" />
<cfparam name="form.Eyear_started_in_tax" default="" />
<cfparam name="form.Eposition_resp" default="" />
<cfparam name="form.Etarget_bonus" default="" />
<cfparam name="form.Esnl_other_percentage" default="" />
<cfparam name="form.Esnl_other" default="" />
<cfparam name="form.Efed_other_percentage" default="" />
<cfparam name="form.Efed_other" default="" />
<cfparam name="form.Esend_report" default="True" />
<cfparam name="form.Esend_to" default="Home" />
<cfparam name="form.Eother_comp_1" default="" />
<cfparam name="form.Eother_comp_2" default="" />
<cfparam name="form.Eother_comp_3" default="" />
<cfparam name="form.Eother_comp_4" default="" />
<cfset now_date = #dateformat(Now(), "yyyy")# />
<cfif val(form.Eyear_started_in_tax) gt 0>
<cfset tax_experience = dateformat(Now(), "yyyy") - "#form.Eyear_started_in_tax#" />
<cfelse>
<cfset tax_experience ="0" />
</cfif>
<cfif Efullname eq "Anonymous">
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE salaryBenchmarking_Participants_Anon SET serp_ltip='#form.Eserp_ltip#', other_perks='#form.Eother_perks#', report_direct='#form.Ereport_direct#', report_total='#form.Ereport_total#', other_education='#form.Eother_education#', other_language='#form.Eother_language#', company_type='#form.Ecompany_type#', tax_experience='#tax_experience#', stock_options_count='#form.Estock_options_count#', target_bonus='#form.Etarget_bonus#', snl_other_percentage='#form.Esnl_other_percentage#', snl_other='#form.Esnl_other#', fed_other_percentage='#form.Efed_other_percentage#', fed_other='#form.Efed_other#', vesting='#form.Evesting#', vest='#form.Evest#', report_ww='#form.Ereport_ww#', report_us='#form.Ereport_us#', notes='#form.Enotes#', send_report='#form.Esend_report#', send_to='#form.Esend_to#', email_other='#form.Eemail_other#', other_comp_1='#form.Eother_comp_1#', other_comp_2='#form.Eother_comp_2#', other_comp_3='#form.Eother_comp_3#', other_comp_4='#form.Eother_comp_4#',Qualitative_Factors='#form.EQualitative_Factors#' WHERE benchid = '#form.Ebenchid#' AND userid = '#form.Eindivnum#' 
	</cfquery>
<cfelse>
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE salaryBenchmarking_Participants SET serp_ltip='#form.Eserp_ltip#', other_perks='#form.Eother_perks#', report_direct='#form.Ereport_direct#', report_total='#form.Ereport_total#', other_education='#form.Eother_education#', other_language='#form.Eother_language#', company_type='#form.Ecompany_type#', tax_experience='#tax_experience#', stock_options_count='#form.Estock_options_count#', target_bonus='#form.Etarget_bonus#', snl_other_percentage='#form.Esnl_other_percentage#', snl_other='#form.Esnl_other#', fed_other_percentage='#form.Efed_other_percentage#', fed_other='#form.Efed_other#', vesting='#form.Evesting#', vest='#form.Evest#', report_ww='#form.Ereport_ww#', report_us='#form.Ereport_us#', notes='#form.Enotes#', send_report='#form.Esend_report#', send_to='#form.Esend_to#', email_other='#form.Eemail_other#', other_comp_1='#form.Eother_comp_1#', other_comp_2='#form.Eother_comp_2#', other_comp_3='#form.Eother_comp_3#', other_comp_4='#form.Eother_comp_4#',Qualitative_Factors='#form.EQualitative_Factors#' WHERE benchid = '#form.Ebenchid#' AND userid = '#form.Eindivnum#' 
	</cfquery>
</cfif>
<!--- Users_Info --->
<cfparam name="form.Ecurrent_title" default="" />
<cfparam name="form.Epast_public_flag" default="" />
<cfparam name="form.Epast_corp_flag" default="" />
<cfparam name="form.Epast_law_flag" default="" />
<cfparam name="form.Epast_govt_flag" default="" />
<cfparam name="form.Eissalc" default="" />
<cfparam name="form.EUserSpecialtyID" default="" />
<cfset form.scspecialty="">
<cfif form.euserspecialtyid EQ "1">
	<cfset form.scspecialty="fedandgen">
<cfelseif form.euserspecialtyid EQ "2">
	<cfset form.scspecialty="statelocal">
<cfelseif form.euserspecialtyid EQ "3">
	<cfset form.scspecialty="international">
</cfif>
<cfif Efullname eq "Anonymous">
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE SalaryBenchmarking_Anon_Users_Info SET title_number=#val(form.Etitle_number)#, year_started_in_tax='#form.Eyear_started_in_tax#', past_public_flag='#form.Epast_public_flag#', past_corp_flag='#form.Epast_corp_flag#', past_law_flag='#form.Epast_law_flag#', past_govt_flag='#form.Epast_govt_flag#', current_salary='#form.Eissalc#', sb_Participant='True', bonuses='#form.Eisbnus#', specialty='#form.Euserspecialtyid#', tax_specialty_id='#val(form.Euserspecialtyid)#' WHERE ID = '#form.Eindivnum#' 
	</cfquery>
<cfelse>
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE Users_Info SET title_number=#val(form.Etitle_number)#, year_started_in_tax='#form.Eyear_started_in_tax#', past_public_flag='#form.Epast_public_flag#', past_corp_flag='#form.Epast_corp_flag#', past_law_flag='#form.Epast_law_flag#', past_govt_flag='#form.Epast_govt_flag#', current_salary='#form.Eissalc#', sb_Participant='True', bonuses='#form.Eisbnus#', specialty='#form.euserspecialtyid#', tax_specialty_id='#val(form.euserspecialtyid)#' WHERE ID = #val(form.Eindivnum)# 
	</cfquery>
</cfif>
<!--- Users --->
<cfparam name="form.Eemail_work" default="" />
<cfparam name="form.Eemail_home" default="" />
<cfif Efullname neq "Anonymous">
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE Users SET email_work='#form.Eemail_work#', email_home='#form.Eemail_home#', scspecialty='#form.euserspecialtyid#' WHERE ID = '#form.Eindivnum#' 
	</cfquery>
</cfif>
<!--- Companies --->
<cfparam name="form.Eactual_sales_per_million" default="" />
<cfparam name="form.Etax_department_size" default="" />
<cfquery name="team" datasource="#request.dsn#">
	UPDATE Companies SET actual_sales_per_million='#form.Eactual_sales_per_million#', tax_department_size_confirmed=#val(form.Etax_department_size)#,tax_department_size_confirmdate='#dateformat(now(),"yyyy/mm/dd")#' WHERE ID = '#form.Ecompanyid#' 
</cfquery>
<!--- Users_Skills --->
<cfif Efullname neq "Anonymous">
	<cfparam name="form.Eskill_5" default="" />
	<cfif form.Eskill_5 NEQ "">
		<cfquery name="kill_skill_5" datasource="#request.dsn#">
			DELETE FROM Users_Skills WHERE userID = '#form.Eindivnum#' AND Skill_Mask_Number ='5' 
		</cfquery>
		<cfloop index="skill_5" list="#form.Eskill_5#">
			<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
				INSERT INTO Users_Skills (Skill_Mask_Number, Skill_Line_Number, Skill_Data, UserID) VALUES('5', '#skill_5#', '*', '#form.Eindivnum#') 
			</cfquery>
		</cfloop>
	</cfif>
	<cfparam name="form.Eskill_2" default="" />
	<cfif form.Eskill_2 NEQ "">
		<cfquery name="kill_skill_2" datasource="#request.dsn#">
			DELETE FROM Users_Skills WHERE userID = '#form.Eindivnum#' AND Skill_Mask_Number ='2' 
		</cfquery>
		<cfloop index="skill_2" list="#form.Eskill_2#">
			<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
				INSERT INTO Users_Skills (Skill_Mask_Number, Skill_Line_Number, Skill_Data, UserID) VALUES('2', '#skill_2#', '*', '#form.Eindivnum#') 
			</cfquery>
		</cfloop>
	</cfif>
<cfelse>
	<cfif form.Eskill_5 NEQ "">
		<cfquery name="kill_skill_5" datasource="#request.dsn#">
			DELETE FROM SalaryBenchmarking_Anon_Users_Skills WHERE userID = #val(form.Eindivnum)# AND Skill_Mask_Number ='5' 
		</cfquery>
		<cfloop index="skill_5" list="#form.Eskill_5#">
			<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
				INSERT INTO SalaryBenchmarking_Anon_Users_Skills (Skill_Mask_Number, Skill_Line_Number, Skill_Data, UserID) VALUES('5', '#skill_5#', '*', #val(form.Eindivnum)#) 
			</cfquery>
		</cfloop>
	</cfif>
	<cfparam name="form.Eskill_2" default="" />
	<cfif form.Eskill_2 NEQ "">
		<cfquery name="kill_skill_2" datasource="#request.dsn#">
			DELETE FROM SalaryBenchmarking_Anon_Users_Skills WHERE userID = #val(form.Eindivnum)# AND Skill_Mask_Number ='2' 
		</cfquery>
		<cfloop index="skill_2" list="#form.Eskill_2#">
			<cfquery name="ins_sub_specialty" datasource="#request.dsn#">
				INSERT INTO SalaryBenchmarking_Anon_Users_Skills (Skill_Mask_Number, Skill_Line_Number, Skill_Data, UserID) VALUES('2', '#skill_2#', '*', #val(form.Eindivnum)#) 
			</cfquery>
		</cfloop>
	</cfif>
</cfif>
<!--- Users_Salary --->
<cfparam name="form.Eissalc" default="" />
<cfparam name="form.Eisbnus" default="" />
<cfparam name="form.Eisstck" default="" />
<cfparam name="form.Eisbon1" default="" />
<cfparam name="form.Eisbon2" default="" />
<cfparam name="form.Eisbon3" default="" />
<cfparam name="form.Eisbon4" default="" />
<cfparam name="form.Eisbon7" default="" />
<cfparam name="form.Eistec1" default="" />
<cfparam name="form.Eistec2" default="" />
<cfparam name="form.Eistec3" default="" />
<cfparam name="form.Eisfun1" default="" />
<cfif form.Estock_options_count NEQ "" AND form.Estock_options_count NEQ "0">
	<cfset form.Eisbon1 = "X" />
</cfif>
<cfif form.Eisbnus EQ "">
	<cfset form.Eisbnus = "0" />
</cfif>
<cfif form.Eisbon7 EQ "">
	<cfset form.Eisbon7 = "0" />
</cfif>
<!--- <cfset form.Eisbnus = form.Eisbnus + form.Eisbon7 /> --->
<cfif Efullname neq "Anonymous">
	<cfquery name="getScDate" datasource="#request.dsn#">
		SELECT issalc FROM Users_Salary WHERE userID = '#form.Eindivnum#' 
	</cfquery>
	<cfif getScDate.issalc NEQ form.Eissalc>
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE Users SET scdate = '#dateformat(Now(), "yyyy/mm/dd")#' WHERE ID = '#form.Eindivnum#' 
		</cfquery>
	</cfif>
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE Users_Salary SET issalc='#form.Eissalc#', isbnus='#form.Eisbnus#', isstck='#form.Eisstck#', isbon1='#form.Eisbon1#', isbon2='#form.Eisbon2#', isbon3='#form.Eisbon3#', isbon4='#form.Eisbon4#', istec1='#form.Eistec1#', istec2='#form.Eistec2#', istec3='#form.Eistec3#', isbon7='#form.Eisbon7#' WHERE userID = '#form.Eindivnum#' 
	</cfquery>
	<cfif benchInfo.specialty EQ "9">
		<cfparam name="form.Eisfun8" default="" />
		<cfparam name="form.Eisfun9" default="" />
		<cfparam name="form.Eisfun10" default="" />
		<cfparam name="form.Eisfun11" default="" />
		<cfparam name="form.Eisfun12" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE Users_Salary SET isfun8='#form.Eisfun8#', isfun9='#form.Eisfun9#', isfun10='#form.Eisfun10#', isfun11='#form.Eisfun11#', isfun12='#form.Eisfun12#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	<cfelseif benchInfo.tax_technology EQ "true">
		<cfparam name="form.Eisfun13" default="" />
		<cfparam name="form.Eisfun14" default="" />
		<cfparam name="form.Eisfun15" default="" />
		<cfparam name="form.Eisfun16" default="" />
		<cfparam name="form.Eisfun17" default="" />
		<cfparam name="form.Eisfun18" default="" />
		<cfparam name="form.Eisfun19" default="" />
		<cfparam name="form.Eisfun20" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE Users_Salary SET isfun13='#form.Eisfun13#', isfun14='#form.Eisfun14#', isfun15='#form.Eisfun15#', isfun16='#form.Eisfun16#', isfun17='#form.Eisfun17#', isfun18='#form.Eisfun18#', isfun19='#form.Eisfun19#', isfun20='#form.Eisfun20#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	<cfelse>
		<cfparam name="form.Eisfun1" default="" />
		<cfparam name="form.Eisfun2" default="" />
		<cfparam name="form.Eisfun3" default="" />
		<cfparam name="form.Eisfun4" default="" />
		<cfparam name="form.Eisfun5" default="" />
		<cfparam name="form.Eisfun6" default="" />
		<cfparam name="form.Eisfun7" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE Users_Salary SET isfun1='#form.Eisfun1#', isfun2='#form.Eisfun2#', isfun3='#form.Eisfun3#', isfun4='#form.Eisfun4#', isfun5='#form.Eisfun5#', isfun6='#form.Eisfun6#', isfun7='#form.Eisfun7#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	</cfif>
<cfelse>
	<cfquery name="checkSalaryRecord" datasource="#request.dsn#">
		SELECT issalc FROM SalaryBenchmarking_Anon_Users_Salary WHERE userID = #val(form.Eindivnum)# 
	</cfquery>
	<cfif checkSalaryRecord.recordcount eq 0>
		<cfquery name="insertSalaryRecord" datasource="#request.dsn#">
			insert into SalaryBenchmarking_Anon_Users_Salary (UserID) VALUES(#val(form.Eindivnum)#) 
		</cfquery>
	</cfif>
	<!--- <cfset form.Eisbnus = form.Eisbnus + form.Eisbon7 /> --->
	<cfquery name="getScDate" datasource="#request.dsn#">
		SELECT issalc FROM SalaryBenchmarking_Anon_Users_Salary WHERE userID = #val(form.Eindivnum)# 
	</cfquery>
	<!--- <cfif getScDate.issalc NEQ form.Eissalc>
		<cfquery name="team" datasource="#request.dsn#">
		UPDATE Users
		SET scdate = '#dateformat(Now(), "yyyy/mm/dd")#'
		WHERE ID = '#form.Eindivnum#'
		</cfquery>
		</cfif> --->
	<cfquery name="team" datasource="#request.dsn#">
		UPDATE SalaryBenchmarking_Anon_Users_Salary SET issalc='#form.Eissalc#', isbnus='#form.Eisbnus#', isstck='#form.Eisstck#', isbon1='#form.Eisbon1#', isbon2='#form.Eisbon2#', isbon3='#form.Eisbon3#', isbon4='#form.Eisbon4#', istec1='#form.Eistec1#', istec2='#form.Eistec2#', istec3='#form.Eistec3#', isbon7='#form.Eisbon7#' WHERE userID = #val(form.Eindivnum)# 
	</cfquery>
	<cfif benchInfo.specialty EQ "9">
		<cfparam name="form.Eisfun8" default="" />
		<cfparam name="form.Eisfun9" default="" />
		<cfparam name="form.Eisfun10" default="" />
		<cfparam name="form.Eisfun11" default="" />
		<cfparam name="form.Eisfun12" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE SalaryBenchmarking_Anon_Users_Salary SET isfun8='#form.Eisfun8#', isfun9='#form.Eisfun9#', isfun10='#form.Eisfun10#', isfun11='#form.Eisfun11#', isfun12='#form.Eisfun12#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	<cfelseif benchInfo.tax_technology EQ "true">
		<cfparam name="form.Eisfun13" default="" />
		<cfparam name="form.Eisfun14" default="" />
		<cfparam name="form.Eisfun15" default="" />
		<cfparam name="form.Eisfun16" default="" />
		<cfparam name="form.Eisfun17" default="" />
		<cfparam name="form.Eisfun18" default="" />
		<cfparam name="form.Eisfun19" default="" />
		<cfparam name="form.Eisfun20" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE SalaryBenchmarking_Anon_Users_Salary SET isfun13='#form.Eisfun13#', isfun14='#form.Eisfun14#', isfun15='#form.Eisfun15#', isfun16='#form.Eisfun16#', isfun17='#form.Eisfun17#', isfun18='#form.Eisfun18#', isfun19='#form.Eisfun19#', isfun20='#form.Eisfun20#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	<cfelse>
		<cfparam name="form.Eisfun1" default="" />
		<cfparam name="form.Eisfun2" default="" />
		<cfparam name="form.Eisfun3" default="" />
		<cfparam name="form.Eisfun4" default="" />
		<cfparam name="form.Eisfun5" default="" />
		<cfparam name="form.Eisfun6" default="" />
		<cfparam name="form.Eisfun7" default="" />
		<cfquery name="team" datasource="#request.dsn#">
			UPDATE SalaryBenchmarking_Anon_Users_Salary SET isfun1='#form.Eisfun1#', isfun2='#form.Eisfun2#', isfun3='#form.Eisfun3#', isfun4='#form.Eisfun4#', isfun5='#form.Eisfun5#', isfun6='#form.Eisfun6#', isfun7='#form.Eisfun7#' WHERE userID = '#form.Eindivnum#' 
		</cfquery>
	</cfif>
</cfif>

Open in new window

0
 

Author Comment

by:lantervj
ID: 34185313
I've been trying to isolate the problem so there may be a few extra lines from my debugging like changing the input tags in the div source to cfinput. That causes an error that CFinput must be nested inside a CFform, so I added a CFform to that source.

CF9 btw
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185351
Ok, that's a *lot* of code and obviously we can't run it without the queries ;-) Let's see if we can wade through it and create a small (isolated) test case that reproduces the problem.
0
 

Author Comment

by:lantervj
ID: 34185364
The high points are the CFwindow for "edit participants" at the bottom of dspView.cfm and the rest of the code to display and update.  The undefined field (or the one that comes across blank, depending on the use of CFparam) is EuserSpecialtyID in the CFdiv.  Just search for CFdiv in dspEditParticipant.cfm. There are only 2.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185369
>> so I added a CFform to that source.

Then any fields inside it won't be part of the main form submission.  You can't nest CFFORM tags.
0
 

Author Comment

by:lantervj
ID: 34185383
Yeah, I get that.  I was just chasing the problem.  But I HAVE to use <input> and not <cfinput> to get past the problem.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 52

Expert Comment

by:_agx_
ID: 34185400
Yeah, but the whole problem is the cfdiv contents aren't part of the form submission.  That's why the fields don't exist on your action page. Why are you using cfdiv here? ie Is it really necessary?
0
 

Author Comment

by:lantervj
ID: 34185415
I'm binding it to the above three fields to create a resulting specialty.
0
 

Author Comment

by:lantervj
ID: 34185418
Are you saying that CFdiv will NOT create an element in the form scope?
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185434
Yep.. more specifically the CFDIV's input fields aren't being included in the parent form.  Run these test pages and you'll see.  The response doesn't include any of the CFDIV fields.

MAINPAGE
================
<cfajaximport tags="CFFORM,CFDIV" />
<script type="text/javascript">
      submitFrm2=function(){
            ColdFusion.Ajax.submitForm('editParticipantForm', 'actionPageTest.cfm', callback2, errorhandler);
            };
      callback2=function(text)
            {
            alert('Action Page Results = 'text);
            ColdFusion.Window.hide('editParticipant');
            };
      errorhandler=function(code, msg)
            {
            alert("Error!!! " + code + ": " + msg);
            };
</script>
<h1>Main Page</h1>
<a href="javascript:ColdFusion.Window.show('editParticipant');">Show window</a>
<cfwindow x="50" y="80" width="840" height="560"
            name="editParticipant"
            minHeight="400" minWidth="400" title="Test Window"
            initshow="true" source="cfwindowContents.cfm" />

cfwindowContents.cfm
====================
<cfform name="editParticipantForm">
      Eistec1<cfinput type="text" name="Eistec1" value="10" size="2" maxlength="3" />
      Eistec2<cfinput type="text" name="Eistec2" value="2```0" size="2" maxlength="3" />
      Eistec3<cfinput type="text" name="Eistec3" value="30" size="2" maxlength="3" />
      <cfdiv id="UsersSpecialtyDiv" bind="url:cfDivContents.cfm?Tec1={Eistec1}&Tec2={Eistec2}&Tec3={Eistec3}&namePrefix=E" bindonload="true" />
      
      <cfinput type="button" name="submit" value="Submit Document" onclick="javascript:submitFrm2();" />
</cfform>      

cfDivContents.cfm
====================
User Specialty-
      <input type="text" name="EUserSpecialtyID" value="123" size="3" disabled/>
      <input type="text" name="EUserSpecialty" value="SomeSpecialty" size="20" maxlength="20" disabled/>


actionPageTest.cfm
====================
<cfoutput>#structKeyList(form)#</cfoutput>
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185447
Copy n' Paste correction:
MAINPAGE

=============

<cfajaximport tags="CFFORM,CFDIV" />

<script type="text/javascript">

      submitFrm2=function(){

            ColdFusion.Ajax.submitForm('editParticipantForm', 'actionPageTest.cfm', callback2, errorhandler);

            };

      callback2=function(text)

            {

            alert('Action Page Results = '+ text);

            ColdFusion.Window.hide('editParticipant');

            };

      errorhandler=function(code, msg)

            {

            alert("Error!!! " + code + ": " + msg);

            };

</script>

<h1>Main Page</h1>

<a href="javascript:ColdFusion.Window.show('editParticipant');">Show window</a>

<cfwindow x="50" y="80" width="840" height="560"

            name="editParticipant"

            minHeight="400" minWidth="400" title="Test Window"

            initshow="true" source="cfwindowContents.cfm" />

Open in new window

0
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 34185468
Oh wait ... I can't believe I missed it.  The reason they're not being submitted is because those fields are *disabled*.  Disabled fields aren't supposed to be submitted ;-)

http://www.w3.org/TR/html401/interact/forms.html#h-17.12
0
 

Author Comment

by:lantervj
ID: 34185469
Well, it's back to school for me!  Got an idea on how to do what I'm trying to do?  
0
 

Author Comment

by:lantervj
ID: 34185482
Apparently changing "disabled" to "readonly=true" does the trick.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185485
Yeah, see my last comment.  I was wrong, I totally forgot your fields are disabled (duh!). So they won't be submitted no matter what.   Just make the fields "readonly" OR create mirror fields that are "hidden" and it'll work fine.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185489
>> Apparently changing "disabled" to "readonly=true" does the trick.

Yeah, if you look at the specs I posted above, they say disabled fields can't be successful (ie submitted) but "readonly" fields can

http://www.w3.org/TR/html401/interact/forms.html#h-17.12
0
 

Author Comment

by:lantervj
ID: 34185493
Many thanks.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 34185507
Welcome.  
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now