Return to act_updateorganization.cfm CVS log

Up to [Development] / p2rx-programs

Modifications

<!--- 	Name:  act_updateorganization.cfm
    	Purpose: This functions as the action file to update the existing organizational information passed on from the dsp_editorganization.cfm form
		.The values are updated in the dorganization table. 
		Date created: 02/24/2005
       	Dependancy: URL.Orgid 
		Variables: 	
		Functions: 
		Date changed: 
					02/24/2005			Prabin & Neena  Created & Documentation
 ---> 
<cfif 	#form.Phone_Area# EQ "" OR 
	  	#form.Phone_Area# EQ "N/A" OR
		#form.Phone_Prefix# EQ "" OR
		#form.Phone_Prefix# EQ "N/A" OR
		#form.Phone_Num# EQ "" OR
		#form.Phone_Num# EQ "N/A"
	>
		<cfset FinalPhoneNumber="">

<cfelse>
		<cfset FinalPhoneNumber='#form.Phone_Area#-#form.Phone_Prefix#-#form.Phone_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 FinalFaxNumber="">

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


<cfif 	#form.Hotline_Area# EQ "" OR 
	  	#form.Hotline_Area# EQ "N/A" OR
		#form.Hotline_Prefix# EQ "" OR
		#form.Hotline_Prefix# EQ "N/A" OR
		#form.Hotline_Num# EQ "" OR
		#form.Hotline_Num# EQ "N/A"
>
		<cfset FinalHotline="">

<cfelse>
		<cfset FinalHotline='#form.Hotline_Area#-#form.Hotline_Prefix#-#form.Hotline_Num#'> 
</cfif>

<Cfquery name="getstatus" datasource="#programsdb#">
select updatestatus as ups
from dorganization
where OrgID=#URL.OrgID#
</CFQUERY>
<cfquery name="Updateorg" datasource="#programsdb#">
	Update 	dOrganization
	Set 	OrganizationName='#form.OrganizationName#', 
			Phone='#FinalPhoneNumber#', 
			Extension='#form.Extension#', 
			Division='#form.Division#', 
			FaxNumber='#FinalFaxNumber#', 
			TimeZone='#form.TimeZone#', 
			Address1='#form.Address1#', 
			EmailName='#form.EmailName#', 
			GeoServiceID='#form.GeoServiceID#', 
			Address2='#form.Address2#', 
			Hotline='#FinalHotline#', 
			City='#form.City#', 
			StateOrProvince='#form.State#', 
			URL='#form.URL#', 
			PostalCode='#form.PostalCode#', 
			Country='#form.Country#', 
			GraphicURL='#form.GraphicURL#', 
			Profile='#form.Profile#',
			updateStatus = <Cfif #getstatus.ups# is 0>'2'<cfelseif #getstatus.ups# is 1>'1'<cfelseif #getstatus.ups# is 2>'2'</CFIF>
	Where 	OrgID=#URL.OrgID#
</cfquery>