Return to
dsp_editOrganization.cfm
CVS log
Up to [Development] / p2rx-programs
|
Return to
dsp_editOrganization.cfm
CVS log
|
Up to [Development] / p2rx-programs
|
|
File: [Development] / p2rx-programs / dsp_editOrganization.cfm
(download)
Revision: 1.2, Tue Mar 22 19:44:53 2005 UTC (4 years, 8 months ago) by neenan Branch: MAIN Changes since 1.1: +7 -7 lines Commented out span and image reference links. |
<!--- Name: dsp_editorganization.cfm
Purpose: It helps to edit a currently added organization in your dummy program database. It also transfers
all the form variables to act_updateorganization.cfm where the actual action of updating the data
into the table(dorganization) takes place.
Date created: 02/23/2005
Dependancy: None
Variables: OrganizationName - Name of the organization (Required)
Division - Division of the organization if applicable
Address1 - Address of the organization (Required)
Address2 - Remaining part of the organization's address if applicable
City - City name of Organization's location (Required)
StateorProvince - Dropdown List values to select the appropriate State(Required)
PostalCode - Zipcode of the organization address (Required)
Phone_Area - Phone Area Number of the organization (Required)
Phone_Prefix - Phone Number Prefix of the organization (Required)
Phone_Num - Phone Number of the organization (Required)
Extension - Extension if applicable
FaxNumber_Area - Fax Area Number of the organization (Required)
FaxNumber_Prefix - Fax Number Prefix of the organization (Required)
FaxNumber_Num - Fax Number of the organization (Required)
TimeZone - TimeZone of the organization (Required)
EmailName - Email of the organization
HotLine_Area - HotLine Area Number of the organization
HotLine_Prefix - Hotline Number Prefix of the organization
Hotline_Num - Phone Number of the organization
GeoServiceID - Scope of the organization (Required)
Option - Local(5), Regional(3), State(2), National(1)
Visitor_ID - ID of the Initial user responsible for adding the organization information.
Functions:
Date changed:
02/23/2005 Prabin and Neena Created, Documentation
03/22/2005 Neena Commented out the Span and image tags
--->
<cfquery name="editOrg" datasource="#programsdb#">
Select *
From dOrganization
Where OrgID = #URL.OrgID#
</cfquery>
<cfquery name="getGeoServices" datasource="#programsdb#">
Select GeoServiceID, GeoService
From GeoServices
Where GeoServiceID = #editorg.GeoServiceID#
</cfquery>
<cfif #EditOrg.Phone# EQ "" OR #EditOrg.Phone# EQ "N/A">
<cfset Phone_Area = "">
<cfset Phone_Prefix = "">
<cfset Phone_Num = "">
<cfelse>
<cfset Phone_Area = Left(EditOrg.Phone, 3)>
<cfset Phone_Prefix = Mid(EditOrg.Phone, 5, 3)>
<cfset Phone_Num = right(EditOrg.Phone, 4)>
</cfif>
<cfif #EditOrg.FaxNumber# EQ "" OR #EditOrg.FaxNumber# EQ "N/A">
<cfset FaxNumber_Area = "">
<cfset FaxNumber_Prefix = "">
<cfset FaxNumber_Num = "">
<cfelse>
<cfset FaxNumber_Area = Left(EditOrg.FaxNumber, 3)>
<cfset FaxNumber_Prefix = Mid(EditOrg.FaxNumber, 5, 3)>
<cfset FaxNumber_Num = right(EditOrg.FaxNumber, 4)>
</cfif>
<cfif #EditOrg.Hotline# EQ "" OR #EditOrg.Hotline# EQ "N/A">
<cfset Hotline_Area = "">
<cfset Hotline_Prefix = "">
<cfset Hotline_Num = "">
<cfelse>
<cfset Hotline_Area = Left(EditOrg.Hotline, 3)>
<cfset Hotline_Prefix = Mid(EditOrg.Hotline, 5, 3)>
<cfset Hotline_Num = right(EditOrg.Hotline, 4)>
</cfif>
<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
<tr>
<td>
<p>
<!--- <span class="subheading"> --->
EDIT A PROGRAM -> <!--- <img src="../images/siteimage/dart.gif" border="0"> --->
ORGANIZATION INFO <!--- <img src="../images/siteimage/dart.gif" border="0"></span> --->
<!--- <span class="sublink2"> --->Step 1 <!--- <img src="../images/siteimage/dart.gif" border="0"></span> ---><br><br>
<!--- <span class="redtext"> ---> * Required Fields<!--- </span> --->
<cfif #URL.fuseaction# IS "EditOrg">
<form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts1&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
<cfelseif #URL.fuseaction# IS "Editorganization">
<form name="addorg" action="addeditprograms.cfm?fuseaction=EditContacts&OrgID=<cfoutput>#URL.orgID#</cfoutput>" method="post">
</cfif>
<cfoutput query="EditORG">
<table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="##F4FFE9">
<tr>
<td><div class="formtext">Organization <font style="color: red">*</font></td>
<td><input type="text" size="50" name="OrganizationName" value="#OrganizationName#" ></div>
<input type="hidden" name="OrganizationName_required" value="Please enter the organization's name, or enter 'n/a'.">
</td>
</tr>
<tr>
<td><div class="formtext">Division</td>
<td><input type="text" size="40" name="Division" value="#Division#"></div></td>
</tr>
<tr>
<td nowrap><div class="formtext">Address 1 <font style="color: red">*</font></td>
<td><input type="text" size="40" name="Address1" value="#Address1#"></div>
<input type="hidden" name="Address1_required" value="Please enter the organization's address, or enter 'n/a'.">
</td>
</tr>
<tr>
<td nowrap><div class="formtext">Address 2</td>
<td><input type="text" size="40" name="Address2" value="#Address2#" ></div></td>
</tr>
<tr>
<td><div class="formtext">City <font style="color: red">*</font></td>
<td align="justified" nowrap>
<input type="text" size="25" name="City" value="#City#"></div>
<input type="hidden" name="City_required" value="Please enter the organization's city location, or enter 'n/a'.">
</td>
</tr>
<tr>
<td><div class="formtext">State <font style="color: red">*</font></td>
<td><select name="StateOrProvince">
<option value="#StateorProvince#" selected> #StateorProvince#</option>
<option value="AL"> Alabama</option>
<option value="AK"> Alaska</option>
<option value="AZ"> Arizona</option>
<option value="AR"> Arkansas</option>
<option value="CA"> California</option>
<option value="CO"> Colorado</option>
<option value="CT"> Connecticut</option>
<option value="DE"> Delaware</option>
<option value="DC"> District of Columbia</option>
<option value="FL"> Florida</option>
<option value="GA"> Georgia</option>
<option value="HI"> Hawaii</option>
<option value="ID"> Idaho</option>
<option value="IL"> Illinois</option>
<option value="IN"> Indiana</option>
<option value="IA"> Iowa</option>
<option value="KS"> Kansas</option>
<option value="KY"> Kentucky</option>
<option value="LA"> Louisiana</option>
<option value="ME"> Maine</option>
<option value="MD"> Maryland</option>
<option value="MA"> Massachusetts</option>
<option value="MI"> Michigan</option>
<option value="MN"> Minnesota</option>
<option value="MS"> Mississippi</option>
<option value="MO"> Missouri</option>
<option value="MT"> Montana</option>
<option value="NE"> Nebraska</option>
<option value="NV"> Nevada</option>
<option value="NH"> New Hampshire</option>
<option value="NJ"> New Jersey</option>
<option value="NM"> New Mexico</option>
<option value="NY"> New York</option>
<option value="NC"> North Carolina</option>
<option value="ND"> North Dakota</option>
<option value="OH"> Ohio</option>
<option value="OK"> Oklahoma</option>
<option value="OR"> Oregon</option>
<option value="PA"> Pennsylvania</option>
<option value="RI"> Rhode Island</option>
<option value="SC"> South Carolina</option>
<option value="SD"> South Dakota</option>
<option value="TN"> Tennessee</option>
<option value="TX"> Texas</option>
<option value="UT"> Utah</option>
<option value="VT"> Vermont</option>
<option value="VA"> Virginia</option>
<option value="WA"> Washington</option>
<option value="WV"> West Virginia</option>
<option value="WI"> Wisconsin</option>
<option value="WY"> Wyoming</option>
<option value="Other"> Other</option>
</select></div>
</td>
</tr>
<tr>
<td><div class="formtext">Zip <font style="color: red">*</font></td>
<td align="justified" nowrap>
<input type="text" size="10" name="PostalCode" value="#PostalCode#"></div>
<input type="hidden" name="PostalCode_required" value="Please enter the organization's zip code, or enter 'n/a'.">
</td>
</tr>
<tr>
<td><div class="formtext">Country<font style="color: red">*</font> </td>
<td><input type="text" size="18" name="Country" value="United States"></div>
<input type="hidden" name="Country_required" value="Please enter the organization's country location, or enter 'n/a'.">
</td>
</tr>
<tr>
<td><div class="formtext">Organization Phone <font style="color: red">*</font></td>
<td><input type="Text" size="3" maxlength="3" name="Phone_Area" value="#Phone_Area#">-
<input type="Text" size="3" maxlength="3" name="Phone_Prefix" value="#Phone_Prefix#">-
<input type="Text" size="4" maxlength="4" name="Phone_Num" value="#Phone_Num#">
<input type="hidden" name="Phone_Area_required" value="Please enter the area code of phone number, or enter 'n/a'.">
<input type="hidden" name="Phone_Prefix_required" value="Please enter the prefix of phone number, or enter 'n/a'.">
<input type="hidden" name="Phone_Num_required" value="Please enter the numer of phone number, or enter 'n/a'.">
<font class="formtext">Ext.</font>
<input type="text" size="5" name="Extension">
</td>
</tr>
<tr>
<td><div class="formtext">Organization Fax</td>
<td><input type="Text" name="FaxNumber_Area" size="3" maxlength="3" value="#FaxNumber_Area#">-
<input type="Text" name="FaxNumber_Prefix" size="3" maxlength="3" value="#FaxNumber_Prefix#">-
<input type="Text" name="FaxNumber_Num" size="4" maxlength="4" value="#FaxNumber_Num#"></div>
</td>
</tr>
<tr>
<td><div class="formtext">Hotline</td>
<td><input type="Text" name="Hotline_Area" size="3" maxlength="3" value="#Hotline_Area#">-
<input type="Text" name="Hotline_Prefix" size="3" maxlength="3" value="#Hotline_Prefix#">-
<input type="Text" name="Hotline_Num" size="4" maxlength="4" value="#Hotline_Num#"></div>
</td>
</tr>
<tr>
<td nowrap><div class="formtext">Time Zone <font style="color: red">*</font></td>
<td><select name="TimeZone">
<option value="#TimeZone#" selected> #TimeZone# </option>
<option value="Pacific"> Pacific</option>
<option value="Mountain"> Mountain</option>
<option value="Central"> Central</option>
<option value="Eastern"> Eastern</option>
<option value="Atlantic"> Atlantic</option>
<option value="Other"> Other</option>
</select></div>
</td>
</tr>
<tr>
<td><div class="formtext">Email</td>
<td><input type="text" size="40" name="EmailName" value="#EmailName#"></div></td>
</tr>
</cfoutput>
<tr>
<td nowrap><div class="formtext">Service Scope <font style="color: red">*</font></td>
<td><select name="GeoServiceID">
<cfoutput query="getgeoservices">
<option value="#GeoServiceID#" selected>#GeoService#</option>
</cfoutput>
<option value="5" > Local</option>
<option value="3"> Regional</option>
<option value="2"> State</option>
<option value="1"> National</option>
</select> </div>
</td>
</tr>
<tr>
<tr>
<cfoutput query="EditORG">
<td><div class="formtext">URL <font style="color: red">*</font></td>
<td><input type="text" size="40" name="URL" value="#URL#"></div>
<input type="hidden" name="URL_required" value="Please enter a URL for the organization.">
</td>
</tr>
<tr>
<td><div class="formtext">Graphic URL</td>
<td><input type="text" size="40" name="GraphicURL" value="#GraphicURL#"></div></td>
</tr>
<tr>
<td valign="top"><div class="formtext">Profile<font style="color: red">*</font></td>
<td><textarea cols="35" rows="10" align="top" name="Profile">#Profile#</textarea></div>
<input type="hidden" name="Profile_required" value="Please enter a profile for the organization.">
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
<td><div class="formtext"><INPUT type="submit" value="Edit Organization">
<INPUT type="reset" value="Reset"></div></td>
</tr>
</cfoutput>
</table>
</form>
</td>
</tr>
</table>
</p>
| CVS Admin |
Powered by ViewCVS 1.0-dev |