Return to AddAcronym.cfm CVS log

Up to [Development] / p2rx-programs

Initial Commit

<!--- 	Name: AddAcronym.cfm 
       	Purpose: The purpose of the file add acronyms at the end of three program types.
	   	Date created: 11/17/2005
       	Dependancy:  
	   	Variables: 	
	   	Date changed:   11/17/2005     	Prabin    Created 
---> 


<!-- change the datasource name to your datasource name, you can find the name at application.cfm --->
<cfset programsdb = "Program">


<cfparam name="action" default="">

<cfif #action# IS "">
	<a href="AddAcronym.cfm?action=Update"><strong>Add Acronym at the end of Program Types</strong></a>
</cfif>
<cfif action IS "Update">
<cftry>
	<cfquery name="UpdateSBAP" datasource="#programsdb#">
		UPDATE 		ProgramTypes 
			SET 	ProgramType = 'Small Business Assistance Program (SBAP)'
			WHERE 	ProgramTypeID=8;
	</cfquery>
	
	<cfquery name="UpdateMEP" datasource="#programsdb#">
		UPDATE 		ProgramTypes 
			SET 	ProgramType = 'Manufacturing Extension Program (MEP)'
			WHERE 	ProgramTypeID=9;
	</cfquery>
	
	<cfquery name="UpdateSBDC" datasource="#programsdb#">
		UPDATE 		ProgramTypes 
			SET 	ProgramType = 'Small Business Developement Center (SBDC)'
			WHERE 	ProgramTypeID=11;
	</cfquery>
	<H3>THE FOLLOWING CHANGES WERE MADE</H3>
			<ol>
				<li>Smaill Business Assistance Program <strong> changed to</strong> Small Business Assistance Program (SBAP) </li><BR>
				<li>Manufacturing Extension Program  <strong> changed to</strong> Manufacturing Extension Program (MEP) </li><BR>
				<li>Small Business Developement Center <strong> changed to</strong> Small Business Developement Center (SBDC)</li><BR>
			</ol>		
	<cfcatch type="database">
		<cfif cfcatch.Errorcode IS "01S03">
			<p>	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The query did not update the fields.
		</cfif>
	</cfcatch>

</cftry>
</cfif>