(file) Return to dsp_AddOrganization.cfm CVS log (file) (dir) Up to [Development] / p2rx-programs

  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 neenan 1.2 					03/22/2005			Neena				Commented out the Span tags and image file references.
 36 neenan 1.1 ---> 
 37            
 38            
 39            
 40            <cfquery name="getGeoServices" datasource="#programsdb#">
 41            	Select 	GeoServiceID, GeoService
 42            	From	GeoServices
 43            </cfquery>
 44            
 45            <cfoutput>
 46            <cfquery name="GetvisitorID" datasource="#ProgramsDB#">
 47            	Select 		*
 48            	From 		OutsideUsers 
 49            	Where  vtime like '#userdate#'
 50            </cfquery>
 51            </cfoutput>
 52            
 53            <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
 54                    <tr> 
 55                      <td> 
 56                        <p>	
 57 neenan 1.2 			<!--- <span class="subheading"> --->
 58            					ADD	A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
 59            				ORGANIZATION INFO - <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
 60            			<!--- 	<span class="sublink2" ---> Step 1 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
 61            			<!--- <span class="redtext"> ---><font style="color: red">* Required Fields</font><!--- </span> --->
 62 neenan 1.1 
 63            
 64            		<form name="addorg" action="addeditprograms.cfm?fuseaction=AddContacts" method="post">
 65            			<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
 66            				<tr>
 67            					<td><div class="formtext">Organization <font style="color: red">*</font></td>
 68            					<td><input type="text" size="40" name="OrganizationName" ></div>
 69            						<input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
 70            					</td>
 71            				</tr>
 72            				<tr>
 73            					<td><div class="formtext">Division</td>
 74            					<td><input type="text" size="40" name="Division" ></div></td>
 75            				</tr>
 76            				<tr>
 77            					<td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
 78            					<td><input type="text" size="40" name="Address1" ></div>
 79            						<input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
 80            					</td>
 81            				</tr>
 82            				<tr>
 83 neenan 1.1 					<td nowrap><div class="formtext">Address 2</td>
 84            					<td><input type="text" size="40" name="Address2" ></div></td>
 85            				</tr>
 86            				<tr>
 87            					<td><div class="formtext">City <font style="color: red">*</font></td>
 88            					<td align="justified" nowrap>
 89            						<input type="text" size="25" name="City" ></div>
 90            						<input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
 91            					</td>
 92            				</tr>
 93            				<tr>	
 94            					<td><div class="formtext">State <font style="color: red">*</font></td>
 95            					<td><select name="StateOrProvince">
 96            							<option value="AL" selected> Alabama</option>
 97            							<option value="AK"> Alaska</option>
 98            							<option value="AZ"> Arizona</option>
 99            							<option value="AR"> Arkansas</option>
100            							<option value="CA"> California</option>
101            							<option value="CO"> Colorado</option>
102            							<option value="CT"> Connecticut</option>
103            							<option value="DE"> Delaware</option>
104 neenan 1.1 							<option value="DC"> District of Columbia</option>
105            							<option value="FL"> Florida</option>
106            							<option value="GA"> Georgia</option>
107            							<option value="HI"> Hawaii</option>
108            							<option value="ID"> Idaho</option>
109            							<option value="IL"> Illinois</option>
110            							<option value="IN"> Indiana</option>
111            							<option value="IA"> Iowa</option>
112            							<option value="KS"> Kansas</option>
113            							<option value="KY"> Kentucky</option>
114            							<option value="LA"> Louisiana</option>
115            							<option value="ME"> Maine</option>
116            							<option value="MD"> Maryland</option>
117            							<option value="MA"> Massachusetts</option>
118            							<option value="MI"> Michigan</option>
119            							<option value="MN"> Minnesota</option>
120            							<option value="MS"> Mississippi</option>
121            							<option value="MO"> Missouri</option>
122            							<option value="MT"> Montana</option>
123            							<option value="NE"> Nebraska</option>
124            							<option value="NV"> Nevada</option>
125 neenan 1.1 							<option value="NH"> New Hampshire</option>
126            							<option value="NJ"> New Jersey</option>
127            							<option value="NM"> New Mexico</option>
128            							<option value="NY"> New York</option>
129            							<option value="NC"> North Carolina</option>
130            							<option value="ND"> North Dakota</option>
131            							<option value="OH"> Ohio</option>
132            							<option value="OK"> Oklahoma</option>
133            							<option value="OR"> Oregon</option>
134            							<option value="PA"> Pennsylvania</option>
135            							<option value="RI"> Rhode Island</option>
136            							<option value="SC"> South Carolina</option>
137            							<option value="SD"> South Dakota</option>
138            							<option value="TN"> Tennessee</option>
139            							<option value="TX"> Texas</option>
140            							<option value="UT"> Utah</option>
141            							<option value="VT"> Vermont</option>
142            							<option value="VA"> Virginia</option>
143            							<option value="WA"> Washington</option>
144            							<option value="WV"> West Virginia</option>
145            							<option value="WI"> Wisconsin</option>
146 neenan 1.1 							<option value="WY"> Wyoming</option>
147            							<option value="Other"> Other</option>
148            					</select></div>
149            					</td>
150            				</tr>
151            				<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" ></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>&nbsp;</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 neenan 1.1 					<td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
168            					<td><input type="Text" size="3" maxlength="3" name="Phone_Area">-
169            						<input type="Text" size="3" maxlength="3" name="Phone_Prefix">-
170            						<input type="Text" size="4" maxlength="4" name="Phone_Num">
171            						<input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
172            						<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 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">-
181            						<input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3">-
182            						<input type="Text" name="FaxNumber_Num" size="4" maxlength="4"></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">-
188 neenan 1.1 						<input type="Text" name="Hotline_Prefix" size="3" maxlength="3">-
189            						<input type="Text" name="Hotline_Num" size="4" maxlength="4"></div>
190            					</td>
191            				</tr>
192            
193            				<tr>
194            					<td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
195            					<td><select name="TimeZone">
196            							<option value="Pacific" selected> Pacific</option>
197            							<option value="Mountain"> Mountain</option>
198            							<option value="Central"> Central</option>
199            							<option value="Eastern"> Eastern</option>
200            							<option value="Atlantic"> Atlantic</option>
201            							<option value="Other"> Other</option>
202            						</select></div>
203            					</td>
204            				</tr>
205            				<tr>
206            					<td><div class="formtext">Email</td>
207            					<td><input type="text" size="40" name="EmailName"></div></td>
208            				</tr>
209 neenan 1.1 				<tr>
210            					<td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
211            					<td><select name="GeoServiceID">
212            						<cfoutput query="getgeoServices">
213            							<option value="#GeoServiceID#" selected>#GeoService#</option>
214            						</cfoutput>
215            						</select></div>
216            					</td>
217            				</tr>
218            				<tr>
219            				<tr>
220            					<td><div class="formtext">URL <font style="color: red">*</font></td>
221            					<td><input type="text" size="40" name="URL" value="http://"></div>
222            						<input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
223            					</td>
224            				</tr>
225            				<tr>	
226            					<td><div class="formtext">Logo URL <a href="javascript:newWindow ('help.cfm')"><font style="color: red" size="-1">Help</font></a></td>
227            					<td><input type="text" size="40" name="GraphicURL" value="http://"></div></td>
228            				</tr>
229            			<tr>
230 neenan 1.1 					<td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
231            					<td><textarea cols="35" rows="10" align="top" name="Profile"></textarea></div>
232            						<input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
233            					</td>
234            				</tr>	
235            				<tr>
236            					<td>&nbsp;</td>
237            				</tr>
238            				<tr> 
239            					<td>&nbsp;</td>
240                  				<td><div class="formtext"><INPUT type="submit" value="Add Organization">
241            	  				<INPUT type="reset" value="Reset"></div></td>
242            					<cfoutput><input type="hidden" name="vid" value="#GetvisitorID.visitor_id#"></cfoutput>
243                			</tr>
244            		</table>
245            	</form>
246            
247            </td>
248            </tr>
249            </table>
250            </p>

CVS Admin
Powered by
ViewCVS 1.0-dev