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
|
33 neenan 1.1 --->
34
35
36
37 <cfquery name="editOrg" datasource="#programsdb#">
38 Select *
39 From dOrganization
40 Where OrgID = #URL.OrgID#
41 </cfquery>
42
43
44 <cfquery name="getGeoServices" datasource="#programsdb#">
45 Select GeoServiceID, GeoService
46 From GeoServices
47 Where GeoServiceID = #editorg.GeoServiceID#
48 </cfquery>
49
50
51
52 <cfif #EditOrg.Phone# EQ "" OR #EditOrg.Phone# EQ "N/A">
53 <cfset Phone_Area = "">
54 neenan 1.1 <cfset Phone_Prefix = "">
55 <cfset Phone_Num = "">
56
57 <cfelse>
58 <cfset Phone_Area = Left(EditOrg.Phone, 3)>
59 <cfset Phone_Prefix = Mid(EditOrg.Phone, 5, 3)>
60 <cfset Phone_Num = right(EditOrg.Phone, 4)>
61 </cfif>
62
63
64 <cfif #EditOrg.FaxNumber# EQ "" OR #EditOrg.FaxNumber# EQ "N/A">
65 <cfset FaxNumber_Area = "">
66 <cfset FaxNumber_Prefix = "">
67 <cfset FaxNumber_Num = "">
68
69 <cfelse>
70 <cfset FaxNumber_Area = Left(EditOrg.FaxNumber, 3)>
71 <cfset FaxNumber_Prefix = Mid(EditOrg.FaxNumber, 5, 3)>
72 <cfset FaxNumber_Num = right(EditOrg.FaxNumber, 4)>
73 </cfif>
74
75 neenan 1.1
76 <cfif #EditOrg.Hotline# EQ "" OR #EditOrg.Hotline# EQ "N/A">
77 <cfset Hotline_Area = "">
78 <cfset Hotline_Prefix = "">
79 <cfset Hotline_Num = "">
80 <cfelse>
81 <cfset Hotline_Area = Left(EditOrg.Hotline, 3)>
82 <cfset Hotline_Prefix = Mid(EditOrg.Hotline, 5, 3)>
83 <cfset Hotline_Num = right(EditOrg.Hotline, 4)>
84 </cfif>
85
86
87 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
88 <tr>
89 <td>
|
96 neenan 1.1
97 <cfif #URL.fuseaction# IS "EditOrg">
98 <form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
99 <cfelseif #URL.fuseaction# IS "Editorganization">
100 <form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
101 </cfif>
102
103 <cfoutput query="EditORG">
104 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="##F4FFE9">
105 <tr>
106 <td><div class="formtext">Organization <font style="color: red">*</font></td>
107 <td><input type="text" size="50" name="OrganizationName" value="#OrganizationName#" ></div>
108 <input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
109 </td>
110 </tr>
111 <tr>
112 <td><div class="formtext">Division</td>
113 <td><input type="text" size="40" name="Division" value="#Division#"></div></td>
114 </tr>
115 <tr>
116 <td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
117 neenan 1.1 <td><input type="text" size="40" name="Address1" value="#Address1#"></div>
118 <input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
119 </td>
120 </tr>
121 <tr>
122 <td nowrap><div class="formtext">Address 2</td>
123 <td><input type="text" size="40" name="Address2" value="#Address2#" ></div></td>
124 </tr>
125 <tr>
126 <td><div class="formtext">City <font style="color: red">*</font></td>
127 <td align="justified" nowrap>
128 <input type="text" size="25" name="City" value="#City#"></div>
129 <input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
130 </td>
131 </tr>
132 <tr>
133 <td><div class="formtext">State <font style="color: red">*</font></td>
134 <td><select name="StateOrProvince">
135 <option value="#StateorProvince#" selected> #StateorProvince#</option>
136 <option value="AL"> Alabama</option>
137 <option value="AK"> Alaska</option>
138 neenan 1.1 <option value="AZ"> Arizona</option>
139 <option value="AR"> Arkansas</option>
140 <option value="CA"> California</option>
141 <option value="CO"> Colorado</option>
142 <option value="CT"> Connecticut</option>
143 <option value="DE"> Delaware</option>
144 <option value="DC"> District of Columbia</option>
145 <option value="FL"> Florida</option>
146 <option value="GA"> Georgia</option>
147 <option value="HI"> Hawaii</option>
148 <option value="ID"> Idaho</option>
149 <option value="IL"> Illinois</option>
150 <option value="IN"> Indiana</option>
151 <option value="IA"> Iowa</option>
152 <option value="KS"> Kansas</option>
153 <option value="KY"> Kentucky</option>
154 <option value="LA"> Louisiana</option>
155 <option value="ME"> Maine</option>
156 <option value="MD"> Maryland</option>
157 <option value="MA"> Massachusetts</option>
158 <option value="MI"> Michigan</option>
159 neenan 1.1 <option value="MN"> Minnesota</option>
160 <option value="MS"> Mississippi</option>
161 <option value="MO"> Missouri</option>
162 <option value="MT"> Montana</option>
163 <option value="NE"> Nebraska</option>
164 <option value="NV"> Nevada</option>
165 <option value="NH"> New Hampshire</option>
166 <option value="NJ"> New Jersey</option>
167 <option value="NM"> New Mexico</option>
168 <option value="NY"> New York</option>
169 <option value="NC"> North Carolina</option>
170 <option value="ND"> North Dakota</option>
171 <option value="OH"> Ohio</option>
172 <option value="OK"> Oklahoma</option>
173 <option value="OR"> Oregon</option>
174 <option value="PA"> Pennsylvania</option>
175 <option value="RI"> Rhode Island</option>
176 <option value="SC"> South Carolina</option>
177 <option value="SD"> South Dakota</option>
178 <option value="TN"> Tennessee</option>
179 <option value="TX"> Texas</option>
180 neenan 1.1 <option value="UT"> Utah</option>
181 <option value="VT"> Vermont</option>
182 <option value="VA"> Virginia</option>
183 <option value="WA"> Washington</option>
184 <option value="WV"> West Virginia</option>
185 <option value="WI"> Wisconsin</option>
186 <option value="WY"> Wyoming</option>
187 <option value="Other"> Other</option>
188 </select></div>
189 </td>
190 </tr>
191 <tr>
192 <td><div class="formtext">Zip <font style="color: red">*</font></td>
193 <td align="justified" nowrap>
194 <input type="text" size="10" name="PostalCode" value="#PostalCode#"></div>
195 <input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
196 </td>
197 </tr>
198 <tr>
199 <td><div class="formtext">Country<font style="color: red">*</font> </td>
200 <td><input type="text" size="18" name="Country" value="United States"></div>
201 neenan 1.1 <input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
202 </td>
203 </tr>
204
205
206 <tr>
207 <td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
208 <td><input type="Text" size="3" maxlength="3" name="Phone_Area" value="#Phone_Area#">-
209 <input type="Text" size="3" maxlength="3" name="Phone_Prefix" value="#Phone_Prefix#">-
210 <input type="Text" size="4" maxlength="4" name="Phone_Num" value="#Phone_Num#">
211 <input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
212 <input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
213 <input type="hidden" name="Phone_Num_required" value="Please enter the numer of phone number, or enter 'n/a'.">
214 <font class="formtext">Ext.</font>
215 <input type="text" size="5" name="Extension">
216 </td>
217 </tr>
218 <tr>
219 <td><div class="formtext">Organization Fax</td>
220 <td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3" value="#FaxNumber_Area#">-
221 <input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3" value="#FaxNumber_Prefix#">-
222 neenan 1.1 <input type="Text" name="FaxNumber_Num" size="4" maxlength="4" value="#FaxNumber_Num#"></div>
223 </td>
224 </tr>
225 <tr>
226 <td><div class="formtext">Hotline</td>
227 <td><input type="Text" name="Hotline_Area" size="3" maxlength="3" value="#Hotline_Area#">-
228 <input type="Text" name="Hotline_Prefix" size="3" maxlength="3" value="#Hotline_Prefix#">-
229 <input type="Text" name="Hotline_Num" size="4" maxlength="4" value="#Hotline_Num#"></div>
230 </td>
231 </tr>
232
233 <tr>
234 <td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
235 <td><select name="TimeZone">
236 <option value="#TimeZone#" selected> #TimeZone# </option>
237 <option value="Pacific"> Pacific</option>
238 <option value="Mountain"> Mountain</option>
239 <option value="Central"> Central</option>
240 <option value="Eastern"> Eastern</option>
241 <option value="Atlantic"> Atlantic</option>
242 <option value="Other"> Other</option>
243 neenan 1.1 </select></div>
244 </td>
245 </tr>
246 <tr>
247 <td><div class="formtext">Email</td>
248 <td><input type="text" size="40" name="EmailName" value="#EmailName#"></div></td>
249 </tr>
250 </cfoutput>
251 <tr>
252
253 <td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
254 <td><select name="GeoServiceID">
255 <cfoutput query="getgeoservices">
256 <option value="#GeoServiceID#" selected>#GeoService#</option>
257 </cfoutput>
258 <option value="5" > Local</option>
259 <option value="3"> Regional</option>
260 <option value="2"> State</option>
261 <option value="1"> National</option>
262 </select> </div>
263 </td>
264 neenan 1.1
265 </tr>
266 <tr>
267 <tr>
268 <cfoutput query="EditORG">
269 <td><div class="formtext">URL <font style="color: red">*</font></td>
270 <td><input type="text" size="40" name="URL" value="#URL#"></div>
271 <input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
272 </td>
273 </tr>
274 <tr>
275 <td><div class="formtext">Graphic URL</td>
276 <td><input type="text" size="40" name="GraphicURL" value="#GraphicURL#"></div></td>
277 </tr>
278 <tr>
279 <td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
280 <td><textarea cols="35" rows="10" align="top" name="Profile">#Profile#</textarea></div>
281 <input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
282 </td>
283 </tr>
284 <tr>
285 neenan 1.1 <td> </td>
286 </tr>
287 <tr>
288 <td> </td>
289 <td><div class="formtext"><INPUT type="submit" value="Edit Organization">
290 <INPUT type="reset" value="Reset"></div></td>
291 </tr>
292 </cfoutput>
293 </table>
294 </form>
295 </td>
296 </tr>
297 </table>
298 </p>
|
Return to
dsp_editOrganization.cfm
CVS log
Up to [Development] / p2rx-programs