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 <!--- <cfset urlvalue = #URL.orgId#> --->
52 <cfquery name="Updateorg" datasource="#programsdb#">
53 Update dOrganization
54 Set OrganizationName='#form.OrganizationName#',
55 Phone='#FinalPhoneNumber#',
56 Extension='#form.Extension#',
57 Division='#form.Division#',
58 FaxNumber='#FinalFaxNumber#',
59 TimeZone='#form.TimeZone#',
60 Address1='#form.Address1#',
61 EmailName='#form.EmailName#',
62 GeoServiceID='#form.GeoServiceID#',
63 Address2='#form.Address2#',
64 neenan 1.1 Hotline='#FinalHotline#',
65 City='#form.City#',
66 StateOrProvince='#form.StateOrProvince#',
67 URL='#form.URL#',
68 PostalCode='#form.PostalCode#',
69 Country='#form.Country#',
70 GraphicURL='#form.GraphicURL#',
71 Profile='#form.Profile#'
72 Where OrgID=#URL.OrgID#
73 </cfquery>
74
75 <!--- <cfoutput> <input type="hidden" name="OrgId1" value="#urlvalue#"> </cfoutput> --->
|
Return to
act_updateorganization.cfm
CVS log
Up to [Development] / p2rx-programs