1 neenan 1.1 <!--- Name: dsp_Addorganization.cfm
2 Purpose: It helps to add a organization in your dummy program database. It also transfers
3 all the form variables to act_addorganization.cfm where the actual action of inserting the data
4 into the table(dorganization) takes place.
5 Date created: 02/23/2005
6 Dependancy: vtime - value of date being passed from dsp_Usersform.cfm that stores the unique date/time value at which the
7 visitor/initial contact saved changes to the database.this value is used to remove any conflicts between other users
8 using the same form.
9 Variables: OrganizationName - Name of the organization (Required)
10 Division - Division of the organization if applicable
11 Address1 - Address of the organization (Required)
12 Address2 - Remaining part of the organization's address if applicable
13 City - City name of Organization's location (Required)
14 StateorProvince - Dropdown List values to select the appropriate State(Required)
15 PostalCode - Zipcode of the organization address (Required)
16 Phone_Area - Phone Area Number of the organization (Required)
17 Phone_Prefix - Phone Number Prefix of the organization (Required)
18 Phone_Num - Phone Number of the organization (Required)
19 Extension - Extension if applicable
20 FaxNumber_Area - Fax Area Number of the organization (Required)
21 FaxNumber_Prefix - Fax Number Prefix of the organization (Required)
22 neenan 1.1 FaxNumber_Num - Fax Number of the organization (Required)
23 TimeZone - TimeZone of the organization (Required)
24 EmailName - Email of the organization
25 HotLine_Area - HotLine Area Number of the organization
26 HotLine_Prefix - Hotline Number Prefix of the organization
27 Hotline_Num - Phone Number of the organization
28 GeoServiceID - Scope of the organization (Required)
29 Option - Local(5), Regional(3), State(2), National(1)
30 Visitor_ID - ID of the Initial user responsible for adding the organization information.
31
32 Functions:
33 Date changed:
34 02/23/2005 Prabin and Neena Created, Documentation
35 --->
36
37
38
39 <cfquery name="getGeoServices" datasource="#programsdb#">
40 Select GeoServiceID, GeoService
41 From GeoServices
42 </cfquery>
43 neenan 1.1
44 <cfoutput>
45 <cfquery name="GetvisitorID" datasource="#ProgramsDB#">
46 Select *
47 From OutsideUsers
48 Where vtime like '#userdate#'
49 </cfquery>
50 </cfoutput>
51
52 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
53 <tr>
54 <td>
55 <p>
56 <span class="subheading">
57 ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
58 ORGANIZATION INFO <img src="../images/siteimage/dart.gif" border="0"></span>
59 <span class="sublink2">Step 1 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
60 <span class="redtext"><font style="color: red">* Required Fields</font></span>
61
62
63 <form name="addorg" action="addeditprograms.cfm?fuseaction=AddContacts" method="post">
64 neenan 1.1 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
65 <tr>
66 <td><div class="formtext">Organization <font style="color: red">*</font></td>
67 <td><input type="text" size="40" name="OrganizationName" ></div>
68 <input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
69 </td>
70 </tr>
71 <tr>
72 <td><div class="formtext">Division</td>
73 <td><input type="text" size="40" name="Division" ></div></td>
74 </tr>
75 <tr>
76 <td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
77 <td><input type="text" size="40" name="Address1" ></div>
78 <input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
79 </td>
80 </tr>
81 <tr>
82 <td nowrap><div class="formtext">Address 2</td>
83 <td><input type="text" size="40" name="Address2" ></div></td>
84 </tr>
85 neenan 1.1 <tr>
86 <td><div class="formtext">City <font style="color: red">*</font></td>
87 <td align="justified" nowrap>
88 <input type="text" size="25" name="City" ></div>
89 <input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
90 </td>
91 </tr>
92 <tr>
93 <td><div class="formtext">State <font style="color: red">*</font></td>
94 <td><select name="StateOrProvince">
95 <option value="AL" selected> Alabama</option>
96 <option value="AK"> Alaska</option>
97 <option value="AZ"> Arizona</option>
98 <option value="AR"> Arkansas</option>
99 <option value="CA"> California</option>
100 <option value="CO"> Colorado</option>
101 <option value="CT"> Connecticut</option>
102 <option value="DE"> Delaware</option>
103 <option value="DC"> District of Columbia</option>
104 <option value="FL"> Florida</option>
105 <option value="GA"> Georgia</option>
106 neenan 1.1 <option value="HI"> Hawaii</option>
107 <option value="ID"> Idaho</option>
108 <option value="IL"> Illinois</option>
109 <option value="IN"> Indiana</option>
110 <option value="IA"> Iowa</option>
111 <option value="KS"> Kansas</option>
112 <option value="KY"> Kentucky</option>
113 <option value="LA"> Louisiana</option>
114 <option value="ME"> Maine</option>
115 <option value="MD"> Maryland</option>
116 <option value="MA"> Massachusetts</option>
117 <option value="MI"> Michigan</option>
118 <option value="MN"> Minnesota</option>
119 <option value="MS"> Mississippi</option>
120 <option value="MO"> Missouri</option>
121 <option value="MT"> Montana</option>
122 <option value="NE"> Nebraska</option>
123 <option value="NV"> Nevada</option>
124 <option value="NH"> New Hampshire</option>
125 <option value="NJ"> New Jersey</option>
126 <option value="NM"> New Mexico</option>
127 neenan 1.1 <option value="NY"> New York</option>
128 <option value="NC"> North Carolina</option>
129 <option value="ND"> North Dakota</option>
130 <option value="OH"> Ohio</option>
131 <option value="OK"> Oklahoma</option>
132 <option value="OR"> Oregon</option>
133 <option value="PA"> Pennsylvania</option>
134 <option value="RI"> Rhode Island</option>
135 <option value="SC"> South Carolina</option>
136 <option value="SD"> South Dakota</option>
137 <option value="TN"> Tennessee</option>
138 <option value="TX"> Texas</option>
139 <option value="UT"> Utah</option>
140 <option value="VT"> Vermont</option>
141 <option value="VA"> Virginia</option>
142 <option value="WA"> Washington</option>
143 <option value="WV"> West Virginia</option>
144 <option value="WI"> Wisconsin</option>
145 <option value="WY"> Wyoming</option>
146 <option value="Other"> Other</option>
147 </select></div>
148 neenan 1.1 </td>
149 </tr>
150 <tr>
151 <td><div class="formtext">Zip <font style="color: red">*</font></td>
152 <td align="justified" nowrap>
153 <input type="text" size="10" name="PostalCode" ></div>
154 <input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
155 </td>
156 </tr>
157 <tr>
158 <td><div class="formtext">Country<font style="color: red">*</font> </td>
159 <td><input type="text" size="18" name="Country" value="United States"></div>
160 <input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
161 </td>
162 </tr>
163
164
165 <tr>
166 <td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
167 <td><input type="Text" size="3" maxlength="3" name="Phone_Area">-
168 <input type="Text" size="3" maxlength="3" name="Phone_Prefix">-
169 neenan 1.1 <input type="Text" size="4" maxlength="4" name="Phone_Num">
170 <input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
171 <input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
172 <input type="hidden" name="Phone_Num_required" value="Please enter the phone number, or enter 'n/a'.">
173 <font class="formtext">Ext.</font>
174 <input type="text" size="5" name="Extension">
175 </td>
176 </tr>
177 <tr>
178 <td><div class="formtext">Organization Fax</td>
179 <td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3">-
180 <input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3">-
181 <input type="Text" name="FaxNumber_Num" size="4" maxlength="4"></div>
182 </td>
183 </tr>
184 <tr>
185 <td><div class="formtext">Hotline</td>
186 <td><input type="Text" name="Hotline_Area" size="3" maxlength="3">-
187 <input type="Text" name="Hotline_Prefix" size="3" maxlength="3">-
188 <input type="Text" name="Hotline_Num" size="4" maxlength="4"></div>
189 </td>
190 neenan 1.1 </tr>
191
192 <tr>
193 <td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
194 <td><select name="TimeZone">
195 <option value="Pacific" selected> Pacific</option>
196 <option value="Mountain"> Mountain</option>
197 <option value="Central"> Central</option>
198 <option value="Eastern"> Eastern</option>
199 <option value="Atlantic"> Atlantic</option>
200 <option value="Other"> Other</option>
201 </select></div>
202 </td>
203 </tr>
204 <tr>
205 <td><div class="formtext">Email</td>
206 <td><input type="text" size="40" name="EmailName"></div></td>
207 </tr>
208 <tr>
209 <td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
210 <td><select name="GeoServiceID">
211 neenan 1.1 <cfoutput query="getgeoServices">
212 <option value="#GeoServiceID#" selected>#GeoService#</option>
213 </cfoutput>
214 </select></div>
215 </td>
216 </tr>
217 <tr>
218 <tr>
219 <td><div class="formtext">URL <font style="color: red">*</font></td>
220 <td><input type="text" size="40" name="URL" value="http://"></div>
221 <input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
222 </td>
223 </tr>
224 <tr>
225 <td><div class="formtext">Logo URL <a href="javascript:newWindow ('help.cfm')"><font style="color: red" size="-1">Help</font></a></td>
226 <td><input type="text" size="40" name="GraphicURL" value="http://"></div></td>
227 </tr>
228 <tr>
229 <td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
230 <td><textarea cols="35" rows="10" align="top" name="Profile"></textarea></div>
231 <input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
232 neenan 1.1 </td>
233 </tr>
234 <tr>
235 <td> </td>
236 </tr>
237 <tr>
238 <td> </td>
239 <td><div class="formtext"><INPUT type="submit" value="Add Organization">
240 <INPUT type="reset" value="Reset"></div></td>
241 <cfoutput><input type="hidden" name="vid" value="#GetvisitorID.visitor_id#"></cfoutput>
242 </tr>
243 </table>
244 </form>
245
246 </td>
247 </tr>
248 </table>
249 </p>
250 <!--- <cfinclude template="../cfi/global_footer.cfm"> --->
|
Return to
dsp_AddOrganization.cfm
CVS log
Up to [Development] / p2rx-programs