(file) Return to act_updateorganization.cfm CVS log (file) (dir) Up to [Development] / p2rx-programs 
 1 neenan 1.1 <!--- 	Name:  act_updateorganization.cfm
 2                	Purpose: This functions as the action file to update the existing organizational information passed on from the dsp_editorganization.cfm form
 3            		.The values are updated in the dorganization table. 
 4            		Date created: 02/24/2005
 5                   	Dependancy: URL.Orgid 
 6            		Variables: 	
 7            		Functions: 
 8            		Date changed: 
 9            					02/24/2005			Prabin & Neena  Created & Documentation
10             ---> 
11            <cfif 	#form.Phone_Area# EQ "" OR 
12            	  	#form.Phone_Area# EQ "N/A" OR
13            		#form.Phone_Prefix# EQ "" OR
14            		#form.Phone_Prefix# EQ "N/A" OR
15            		#form.Phone_Num# EQ "" OR
16            		#form.Phone_Num# EQ "N/A"
17            	>
18            		<cfset FinalPhoneNumber="">
19            
20            <cfelse>
21            		<cfset FinalPhoneNumber='#form.Phone_Area#-#form.Phone_Prefix#-#form.Phone_Num#'> 
22 neenan 1.1 </cfif>
23            
24            
25            <cfif 	#form.FaxNumber_Area# EQ "" OR 
26            	  	#form.FaxNumber_Area# EQ "N/A" OR
27            		#form.FaxNumber_Prefix# EQ "" OR
28            		#form.FaxNumber_Prefix# EQ "N/A" OR
29            		#form.FaxNumber_Num# EQ "" OR
30            		#form.FaxNumber_Num# EQ "N/A"
31            >
32            		<cfset FinalFaxNumber="">
33            
34            <cfelse>
35            		<cfset FinalFaxNumber='#form.FaxNumber_Area#-#form.FaxNumber_Prefix#-#form.FaxNumber_Num#'> 
36            </cfif>
37            
38            
39            <cfif 	#form.Hotline_Area# EQ "" OR 
40            	  	#form.Hotline_Area# EQ "N/A" OR
41            		#form.Hotline_Prefix# EQ "" OR
42            		#form.Hotline_Prefix# EQ "N/A" OR
43 neenan 1.1 		#form.Hotline_Num# EQ "" OR
44            		#form.Hotline_Num# EQ "N/A"
45            >
46            		<cfset FinalHotline="">
47            
48            <cfelse>
49            		<cfset FinalHotline='#form.Hotline_Area#-#form.Hotline_Prefix#-#form.Hotline_Num#'> 
50            </cfif>

51 pKanel 1.2 
52            <Cfquery name="getstatus" datasource="#programsdb#">
53            select updatestatus as ups
54            from dorganization
55            where OrgID=#URL.OrgID#
56            </CFQUERY>

57 neenan 1.1 <cfquery name="Updateorg" datasource="#programsdb#">
58            	Update 	dOrganization
59            	Set 	OrganizationName='#form.OrganizationName#', 
60            			Phone='#FinalPhoneNumber#', 
61            			Extension='#form.Extension#', 
62            			Division='#form.Division#', 
63            			FaxNumber='#FinalFaxNumber#', 
64            			TimeZone='#form.TimeZone#', 
65            			Address1='#form.Address1#', 
66            			EmailName='#form.EmailName#', 
67            			GeoServiceID='#form.GeoServiceID#', 
68            			Address2='#form.Address2#', 
69            			Hotline='#FinalHotline#', 
70            			City='#form.City#', 

71 pKanel 1.2 			StateOrProvince='#form.State#', 

72 neenan 1.1 			URL='#form.URL#', 
73            			PostalCode='#form.PostalCode#', 
74            			Country='#form.Country#', 
75            			GraphicURL='#form.GraphicURL#', 

76 pKanel 1.2 			Profile='#form.Profile#',
77            			updateStatus = <Cfif #getstatus.ups# is 0>'2'<cfelseif #getstatus.ups# is 1>'1'<cfelseif #getstatus.ups# is 2>'2'</CFIF>

78 neenan 1.1 	Where 	OrgID=#URL.OrgID#
79            </cfquery>
80
CVS Admin
 Powered by
ViewCVS 1.0-dev