1 pKanel 1.1 <!--- Name: AddAcronym.cfm
2 Purpose: The purpose of the file add acronyms at the end of three program types.
3 Date created: 11/17/2005
4 Dependancy:
5 Variables:
6 Date changed: 11/17/2005 Prabin Created
7 --->
8
9
10 <!-- change the datasource name to your datasource name, you can find the name at application.cfm --->
11 <cfset programsdb = "Program">
12
13
14 <cfparam name="action" default="">
15
16 <cfif #action# IS "">
17 <a href="AddAcronym.cfm?action=Update"><strong>Add Acronym at the end of Program Types</strong></a>
18 </cfif>
19 <cfif action IS "Update">
20 <cftry>
21 <cfquery name="UpdateSBAP" datasource="#programsdb#">
22 pKanel 1.1 UPDATE ProgramTypes
23 SET ProgramType = 'Small Business Assistance Program (SBAP)'
24 WHERE ProgramTypeID=8;
25 </cfquery>
26
27 <cfquery name="UpdateMEP" datasource="#programsdb#">
28 UPDATE ProgramTypes
29 SET ProgramType = 'Manufacturing Extension Program (MEP)'
30 WHERE ProgramTypeID=9;
31 </cfquery>
32
33 <cfquery name="UpdateSBDC" datasource="#programsdb#">
34 UPDATE ProgramTypes
35 SET ProgramType = 'Small Business Developement Center (SBDC)'
36 WHERE ProgramTypeID=11;
37 </cfquery>
38 <H3>THE FOLLOWING CHANGES WERE MADE</H3>
39 <ol>
40 <li>Smaill Business Assistance Program <strong> changed to</strong> Small Business Assistance Program (SBAP) </li><BR>
41 <li>Manufacturing Extension Program <strong> changed to</strong> Manufacturing Extension Program (MEP) </li><BR>
42 <li>Small Business Developement Center <strong> changed to</strong> Small Business Developement Center (SBDC)</li><BR>
43 pKanel 1.1 </ol>
44 <cfcatch type="database">
45 <cfif cfcatch.Errorcode IS "01S03">
46 <p> The query did not update the fields.
47 </cfif>
48 </cfcatch>
49
50 </cftry>
51 </cfif>
52
53
54
|
Return to
AddAcronym.cfm
CVS log
Up to [Development] / p2rx-programs