1 neenan 1.1 <!--- Name: dsp_editorganization.cfm
2 Purpose: It helps to edit a currently added organization in your dummy program database. It also transfers
3 all the form variables to act_updateorganization.cfm where the actual action of updating the data
4 into the table(dorganization) takes place.
5 Date created: 02/23/2005
6 Dependancy: None
7 Variables: OrganizationName - Name of the organization (Required)
8 Division - Division of the organization if applicable
9 Address1 - Address of the organization (Required)
10 Address2 - Remaining part of the organization's address if applicable
11 City - City name of Organization's location (Required)
12 StateorProvince - Dropdown List values to select the appropriate State(Required)
13 PostalCode - Zipcode of the organization address (Required)
14 Phone_Area - Phone Area Number of the organization (Required)
15 Phone_Prefix - Phone Number Prefix of the organization (Required)
16 Phone_Num - Phone Number of the organization (Required)
17 Extension - Extension if applicable
18 FaxNumber_Area - Fax Area Number of the organization (Required)
19 FaxNumber_Prefix - Fax Number Prefix of the organization (Required)
20 FaxNumber_Num - Fax Number of the organization (Required)
21 TimeZone - TimeZone of the organization (Required)
22 neenan 1.1 EmailName - Email of the organization
23 HotLine_Area - HotLine Area Number of the organization
24 HotLine_Prefix - Hotline Number Prefix of the organization
25 Hotline_Num - Phone Number of the organization
26 GeoServiceID - Scope of the organization (Required)
27 Option - Local(5), Regional(3), State(2), National(1)
28 Visitor_ID - ID of the Initial user responsible for adding the organization information.
29 Functions:
30 Date changed:
31 02/23/2005 Prabin and Neena Created, Documentation
32 --->
33
34
35
36 <cfquery name="editOrg" datasource="#programsdb#">
37 Select *
38 From dOrganization
39 Where OrgID = #URL.OrgID#
40 </cfquery>
41
42
43 neenan 1.1 <cfquery name="getGeoServices" datasource="#programsdb#">
44 Select GeoServiceID, GeoService
45 From GeoServices
46 Where GeoServiceID = #editorg.GeoServiceID#
47 </cfquery>
48
49
50
51 <cfif #EditOrg.Phone# EQ "" OR #EditOrg.Phone# EQ "N/A">
52 <cfset Phone_Area = "">
53 <cfset Phone_Prefix = "">
54 <cfset Phone_Num = "">
55
56 <cfelse>
57 <cfset Phone_Area = Left(EditOrg.Phone, 3)>
58 <cfset Phone_Prefix = Mid(EditOrg.Phone, 5, 3)>
59 <cfset Phone_Num = right(EditOrg.Phone, 4)>
60 </cfif>
|
61 pKanel 1.3
|
62 neenan 1.1
63 <cfif #EditOrg.FaxNumber# EQ "" OR #EditOrg.FaxNumber# EQ "N/A">
64 <cfset FaxNumber_Area = "">
65 <cfset FaxNumber_Prefix = "">
66 <cfset FaxNumber_Num = "">
67
68 <cfelse>
69 <cfset FaxNumber_Area = Left(EditOrg.FaxNumber, 3)>
70 <cfset FaxNumber_Prefix = Mid(EditOrg.FaxNumber, 5, 3)>
71 <cfset FaxNumber_Num = right(EditOrg.FaxNumber, 4)>
72 </cfif>
73
74
75 <cfif #EditOrg.Hotline# EQ "" OR #EditOrg.Hotline# EQ "N/A">
76 <cfset Hotline_Area = "">
77 <cfset Hotline_Prefix = "">
78 <cfset Hotline_Num = "">
79 <cfelse>
80 <cfset Hotline_Area = Left(EditOrg.Hotline, 3)>
81 <cfset Hotline_Prefix = Mid(EditOrg.Hotline, 5, 3)>
82 <cfset Hotline_Num = right(EditOrg.Hotline, 4)>
83 neenan 1.1 </cfif>
84
|
85 pKanel 1.3 <cfquery name="getstate">
86 select *
87 from States
88 </cfquery>
|
89 neenan 1.1
|
90 pKanel 1.3 <!-- #BeginEditable "Content" -->
|
91 neenan 1.1 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
92 <tr>
93 <td>
|
94 pKanel 1.3 <p>
95 <span class="subheading">
96 EDIT A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
97 ORGANIZATION INFO <img src="../images/siteimage/dart.gif" border="0"></span>
98 <span class="sublink2">Step 1 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
99 <span class="redtext">* Required Fields</span>
|
100 neenan 1.1
101 <cfif #URL.fuseaction# IS "EditOrg">
102 <form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
103 <cfelseif #URL.fuseaction# IS "Editorganization">
104 <form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
105 </cfif>
106
107 <cfoutput query="EditORG">
108 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="##F4FFE9">
109 <tr>
110 <td><div class="formtext">Organization <font style="color: red">*</font></td>
|
111 pKanel 1.3 <td><input type="hidden" size="3" name="statename" value="#EditORG.StateOrProvince#">
112 <input type="text" size="50" name="OrganizationName" value="#OrganizationName#" onfocus="return getStateOption3('addorg')"></div>
|
113 neenan 1.1 <input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
|
114 pKanel 1.3
|
115 neenan 1.1 </td>
116 </tr>
117 <tr>
118 <td><div class="formtext">Division</td>
119 <td><input type="text" size="40" name="Division" value="#Division#"></div></td>
|
120 pKanel 1.3
|
121 neenan 1.1 </tr>
122 <tr>
123 <td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
124 <td><input type="text" size="40" name="Address1" value="#Address1#"></div>
125 <input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
126 </td>
127 </tr>
128 <tr>
129 <td nowrap><div class="formtext">Address 2</td>
130 <td><input type="text" size="40" name="Address2" value="#Address2#" ></div></td>
131 </tr>
132 <tr>
133 <td><div class="formtext">City <font style="color: red">*</font></td>
134 <td align="justified" nowrap>
135 <input type="text" size="25" name="City" value="#City#"></div>
136 <input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
137 </td>
138 </tr>
|
139 pKanel 1.3 </cfoutput>
|
140 neenan 1.1 <tr>
|
141 pKanel 1.3 <td><div class="formtext"><font style="color: red">*</font>State</td>
142 <td>
143 <select name="State">
144 <cfoutput query="getState">
145 <option value="#Abbr#" <cfif #Abbr# EQ #editOrg.stateOrProvince#> selected </cfif>>#State#</option>
146 </cfoutput>
|
147 neenan 1.1 </select></div>
148 </td>
149 </tr>
|
150 pKanel 1.3 <cfoutput query="EditORG">
|
151 neenan 1.1 <tr>
152 <td><div class="formtext">Zip <font style="color: red">*</font></td>
153 <td align="justified" nowrap>
154 <input type="text" size="10" name="PostalCode" value="#PostalCode#"></div>
155 <input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
156 </td>
157 </tr>
158 <tr>
159 <td><div class="formtext">Country<font style="color: red">*</font> </td>
160 <td><input type="text" size="18" name="Country" value="United States"></div>
161 <input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
162 </td>
163 </tr>
164
165
166 <tr>
167 <td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
168 <td><input type="Text" size="3" maxlength="3" name="Phone_Area" value="#Phone_Area#">-
169 <input type="Text" size="3" maxlength="3" name="Phone_Prefix" value="#Phone_Prefix#">-
170 <input type="Text" size="4" maxlength="4" name="Phone_Num" value="#Phone_Num#">
171 <input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
172 neenan 1.1 <input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
173 <input type="hidden" name="Phone_Num_required" value="Please enter the numer of phone number, or enter 'n/a'.">
174 <font class="formtext">Ext.</font>
175 <input type="text" size="5" name="Extension">
176 </td>
177 </tr>
178 <tr>
179 <td><div class="formtext">Organization Fax</td>
180 <td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3" value="#FaxNumber_Area#">-
181 <input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3" value="#FaxNumber_Prefix#">-
182 <input type="Text" name="FaxNumber_Num" size="4" maxlength="4" value="#FaxNumber_Num#"></div>
183 </td>
184 </tr>
185 <tr>
186 <td><div class="formtext">Hotline</td>
187 <td><input type="Text" name="Hotline_Area" size="3" maxlength="3" value="#Hotline_Area#">-
188 <input type="Text" name="Hotline_Prefix" size="3" maxlength="3" value="#Hotline_Prefix#">-
189 <input type="Text" name="Hotline_Num" size="4" maxlength="4" value="#Hotline_Num#"></div>
190 </td>
191 </tr>
192
193 neenan 1.1 <tr>
194 <td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
195 <td><select name="TimeZone">
196 <option value="#TimeZone#" selected> #TimeZone# </option>
197 <option value="Pacific"> Pacific</option>
198 <option value="Mountain"> Mountain</option>
199 <option value="Central"> Central</option>
200 <option value="Eastern"> Eastern</option>
201 <option value="Atlantic"> Atlantic</option>
202 <option value="Other"> Other</option>
203 </select></div>
204 </td>
205 </tr>
206 <tr>
207 <td><div class="formtext">Email</td>
208 <td><input type="text" size="40" name="EmailName" value="#EmailName#"></div></td>
209 </tr>
210 </cfoutput>
211 <tr>
212
213 <td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
214 neenan 1.1 <td><select name="GeoServiceID">
215 <cfoutput query="getgeoservices">
216 <option value="#GeoServiceID#" selected>#GeoService#</option>
217 </cfoutput>
218 <option value="5" > Local</option>
219 <option value="3"> Regional</option>
220 <option value="2"> State</option>
221 <option value="1"> National</option>
222 </select> </div>
223 </td>
224
225 </tr>
226 <tr>
227 <tr>
228 <cfoutput query="EditORG">
229 <td><div class="formtext">URL <font style="color: red">*</font></td>
230 <td><input type="text" size="40" name="URL" value="#URL#"></div>
231 <input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
232 </td>
233 </tr>
234 <tr>
235 neenan 1.1 <td><div class="formtext">Graphic URL</td>
236 <td><input type="text" size="40" name="GraphicURL" value="#GraphicURL#"></div></td>
237 </tr>
238 <tr>
239 <td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
240 <td><textarea cols="35" rows="10" align="top" name="Profile">#Profile#</textarea></div>
241 <input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
242 </td>
243 </tr>
244 <tr>
245 <td> </td>
246 </tr>
247 <tr>
248 <td> </td>
249 <td><div class="formtext"><INPUT type="submit" value="Edit Organization">
250 <INPUT type="reset" value="Reset"></div></td>
251 </tr>
252 </cfoutput>
253 </table>
254 </form>
255 </td>
256 neenan 1.1 </tr>
257 </table>
258 </p>
|
Return to
dsp_editOrganization.cfm
CVS log
Up to [Development] / p2rx-programs