Return to act_updatecontact.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name:  act_updatecontact.cfm
    	Purpose: This functions as the action file to update/further add the information of the existing contact(s) in the
		dcontacts table for the current organization information the user is entering via the programsadmin forms.
			
		Date created: 02/24/2005
       	Dependancy: URL.Orgid 
		Variables: 	
		Date changed: 
					02/24/2005			Prabin & Neena  Created
					02/24/2005			Neena		    Documentation
---> 
<cfif 	#form.WorkPhone_Area# EQ "" OR 
	  	#form.WorkPhone_Area# EQ "N/A" OR
		#form.WorkPhone_Prefix# EQ "" OR
		#form.WorkPhone_Prefix# EQ "N/A" OR
		#form.WorkPhone_Num# EQ "" OR
		#form.WorkPhone_Num# EQ "N/A"
>
		<cfset Form.WorkPhone="">

<cfelse>
		<cfset Form.WorkPhone='#form.WorkPhone_Area#-#form.WorkPhone_Prefix#-#form.WorkPhone_Num#'> 
</cfif>


<cfif 	#form.MobilePhone_Area# EQ "" OR 
	  	#form.MobilePhone_Area# EQ "N/A" OR
		#form.MobilePhone_Prefix# EQ "" OR
		#form.MobilePhone_Prefix# EQ "N/A" OR
		#form.MobilePhone_Num# EQ "" OR
		#form.MobilePhone_Num# EQ "N/A"
>
		<cfset Form.MobilePhone="">

<cfelse>
		<cfset Form.MobilePhone='#form.MobilePhone_Area#-#form.MobilePhone_Prefix#-#form.MobilePhone_Num#'> 
</cfif>


<cfif 	#form.FaxNumber_Area# EQ "" OR 
	  	#form.FaxNumber_Area# EQ "N/A" OR
		#form.FaxNumber_Prefix# EQ "" OR
		#form.FaxNumber_Prefix# EQ "N/A" OR
		#form.FaxNumber_Num# EQ "" OR
		#form.FaxNumber_Num# EQ "N/A"
>
		<cfset Form.FaxNumber="">

<cfelse>
		<cfset Form.FaxNumber='#form.FaxNumber_Area#-#form.FaxNumber_Prefix#-#form.FaxNumber_Num#'> 
</cfif>


<cfupdate datasource="#programsDB#" tablename="dcontacts" 
          formfields="ContactID, Primary, Prefix, FirstName, Middle, LastName, NameSuffix, Title, WorkPhone, WorkExtension, MobilePhone, FaxNumber, EmailName, Address, City, State, Zip">