1 neenan 1.1 <!--- Name: act_addcontact.cfm
2 Purpose: This functions as the action file to insert the information of the contact(s) for the organization into the
3 dcontacts dummy table in the programs database.
4
5 Date created: 02/24/2005
6 Dependancy: URL.Orgid
7 Variables: FinalworkNumber - work area, work suffix and workphone transformed together into one variable.
8 FinalMobileNumber - Mobile suffix,mobile area and mobile number transformed together into one variable.
9 FinalfaxNumber - Fax suffix,Fax area and Fax number transformed into one variable.
10 Functions:
11 Date changed:
12 02/24/2005 Prabin & Neena Created
13 02/24/2005 Neena Documentation
14 --->
15
16 <cfparam name="form.Prefix" default="">
17 <cfparam name="form.FirstName" default="">
18 <cfparam name="form.Middle" default="">
19 <cfparam name="form.LastName" default="">
20 <cfparam name="form.NameSuffix" default="">
21 <cfparam name="form.Title" default="">
22 neenan 1.1 <cfparam name="form.Primary" default="0">
23 <cfparam name="form.Address" default="">
24 <cfparam name="form.City" default="">
25 <cfparam name="form.State" default="">
26 <cfparam name="form.Zip" default="">
27 <cfparam name="form.WorkPhone_Area" default="">
28 <cfparam name="form.WorkPhone_Prefix" default="">
29 <cfparam name="form.WorkPhone_Num" default="">
30 <cfparam name="form.WorkExtension" default="">
31 <cfparam name="form.MobilePhone_Area" default="">
32 <cfparam name="form.MobilePhone_Prefix" default="">
33 <cfparam name="form.MobilePhone_Num" default="">
34 <cfparam name="form.FaxNumber_Area" default="">
35 <cfparam name="form.FaxNumber_Prefix" default="">
36 <cfparam name="form.FaxNumber_Num" default="">
37 <cfparam name="form.EmailName" default="">
38 <cfparam name="form.Primary" default="0">
39
40 <cfif #form.WorkPhone_Area# EQ "" OR
41 #form.WorkPhone_Area# EQ "N/A" OR
42 #form.WorkPhone_Prefix# EQ "" OR
43 neenan 1.1 #form.WorkPhone_Prefix# EQ "N/A" OR
44 #form.WorkPhone_Num# EQ "" OR
45 #form.WorkPhone_Num# EQ "N/A"
46 >
47 <cfset FinalWorkNumber="">
48
49 <cfelse>
50 <cfset FinalWorkNumber='#form.WorkPhone_Area#-#form.WorkPhone_Prefix#-#form.WorkPhone_Num#'>
51 </cfif>
52
53
54 <cfif #form.MobilePhone_Area# EQ "" OR
55 #form.MobilePhone_Area# EQ "N/A" OR
56 #form.MobilePhone_Prefix# EQ "" OR
57 #form.MobilePhone_Prefix# EQ "N/A" OR
58 #form.MobilePhone_Num# EQ "" OR
59 #form.MobilePhone_Num# EQ "N/A"
60 >
61 <cfset FinalMobilePhone="">
62
63 <cfelse>
64 neenan 1.1 <cfset FinalMobilePhone='#form.MobilePhone_Area#-#form.MobilePhone_Prefix#-#form.MobilePhone_Num#'>
65 </cfif>
66
67
68 <cfif #form.FaxNumber_Area# EQ "" OR
69 #form.FaxNumber_Area# EQ "N/A" OR
70 #form.FaxNumber_Prefix# EQ "" OR
71 #form.FaxNumber_Prefix# EQ "N/A" OR
72 #form.FaxNumber_Num# EQ "" OR
73 #form.FaxNumber_Num# EQ "N/A"
74 >
75 <cfset FinalFaxNumber="">
76
77 <cfelse>
78 <cfset FinalFaxNumber='#form.FaxNumber_Area#-#form.FaxNumber_Prefix#-#form.FaxNumber_Num#'>
79 </cfif>
80 <!--- <cfoutput>#form.storedate#</cfoutput> --->
81
82 <cfquery datasource="#ProgramsDB#">
83 Insert Into dContacts
84 (Prefix, FirstName, Middle, LastName, NameSuffix, Title, Primary, WorkPhone, WorkExtension, MobilePhone, FaxNumber, EmailName, Address, City, State, Zip, OrgID)
85 neenan 1.1 Values ('#form.Prefix#',
86 '#form.FirstName#',
87 '#form.Middle#',
88 '#form.LastName#',
89 '#form.NameSuffix#',
90 '#form.Title#',
91 '#form.Primary#',
92 '#finalWorkNumber#',
93 '#form.WorkExtension#',
94 '#FinalMobilePhone#',
95 '#finalFaxNumber#',
96 '#form.EmailName#',
97 '#form.Address#',
98 '#form.City#',
99 '#form.State#',
100 '#form.Zip#',
101 #URL.OrgID#)
102 </cfquery>
103
|
Return to
act_addcontact.cfm
CVS log
Up to [Development] / p2rx-programs