1 neenan 1.1 <!--- Name: act_updatecontact.cfm
2 Purpose: This functions as the action file to update/further add the information of the existing contact(s) in the
3 dcontacts table for the current organization information the user is entering via the programsadmin forms.
4
5 Date created: 02/24/2005
6 Dependancy: URL.Orgid
7 Variables:
8 Date changed:
9 02/24/2005 Prabin & Neena Created
10 02/24/2005 Neena Documentation
11 --->
12 <cfif #form.WorkPhone_Area# EQ "" OR
13 #form.WorkPhone_Area# EQ "N/A" OR
14 #form.WorkPhone_Prefix# EQ "" OR
15 #form.WorkPhone_Prefix# EQ "N/A" OR
16 #form.WorkPhone_Num# EQ "" OR
17 #form.WorkPhone_Num# EQ "N/A"
18 >
19 <cfset Form.WorkPhone="">
20
21 <cfelse>
22 neenan 1.1 <cfset Form.WorkPhone='#form.WorkPhone_Area#-#form.WorkPhone_Prefix#-#form.WorkPhone_Num#'>
23 </cfif>
24
25
26 <cfif #form.MobilePhone_Area# EQ "" OR
27 #form.MobilePhone_Area# EQ "N/A" OR
28 #form.MobilePhone_Prefix# EQ "" OR
29 #form.MobilePhone_Prefix# EQ "N/A" OR
30 #form.MobilePhone_Num# EQ "" OR
31 #form.MobilePhone_Num# EQ "N/A"
32 >
33 <cfset Form.MobilePhone="">
34
35 <cfelse>
36 <cfset Form.MobilePhone='#form.MobilePhone_Area#-#form.MobilePhone_Prefix#-#form.MobilePhone_Num#'>
37 </cfif>
38
39
40 <cfif #form.FaxNumber_Area# EQ "" OR
41 #form.FaxNumber_Area# EQ "N/A" OR
42 #form.FaxNumber_Prefix# EQ "" OR
43 neenan 1.1 #form.FaxNumber_Prefix# EQ "N/A" OR
44 #form.FaxNumber_Num# EQ "" OR
45 #form.FaxNumber_Num# EQ "N/A"
46 >
47 <cfset Form.FaxNumber="">
48
49 <cfelse>
50 <cfset Form.FaxNumber='#form.FaxNumber_Area#-#form.FaxNumber_Prefix#-#form.FaxNumber_Num#'>
51 </cfif>
52
53
54 <cfupdate datasource="#programsDB#" tablename="dcontacts"
55 formfields="ContactID, Primary, Prefix, FirstName, Middle, LastName, NameSuffix, Title, WorkPhone, WorkExtension, MobilePhone, FaxNumber, EmailName, Address, City, State, Zip">
56
|
Return to
act_updatecontact.cfm
CVS log
Up to [Development] / p2rx-programs