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 pKanel 1.2 <cfset programsdb = "Programs">
|
12 pKanel 1.1
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 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 pKanel 1.1 <cfquery name="UpdateSBDC" datasource="#programsdb#">
34 UPDATE ProgramTypes
35 SET ProgramType = 'Small Business Developement Center (SBDC)'
36 WHERE ProgramTypeID=11;
37 </cfquery>
|
38 pKanel 1.2
39 <cfquery name="UpdateSBAP" datasource="#programsdb#">
40 UPDATE dProgramTypes
41 SET ProgramType = 'Small Business Assistance Program (SBAP)'
42 WHERE ProgramTypeID=8;
43 </cfquery>
44
45 <cfquery name="UpdateMEP" datasource="#programsdb#">
46 UPDATE dProgramTypes
47 SET ProgramType = 'Manufacturing Extension Program (MEP)'
48 WHERE ProgramTypeID=9;
49 </cfquery>
50
51 <cfquery name="UpdateSBDC" datasource="#programsdb#">
52 UPDATE dProgramTypes
53 SET ProgramType = 'Small Business Developement Center (SBDC)'
54 WHERE ProgramTypeID=11;
55 </cfquery>
|
56 pKanel 1.1 <H3>THE FOLLOWING CHANGES WERE MADE</H3>
57 <ol>
58 <li>Smaill Business Assistance Program <strong> changed to</strong> Small Business Assistance Program (SBAP) </li><BR>
59 <li>Manufacturing Extension Program <strong> changed to</strong> Manufacturing Extension Program (MEP) </li><BR>
60 <li>Small Business Developement Center <strong> changed to</strong> Small Business Developement Center (SBDC)</li><BR>
61 </ol>
62 <cfcatch type="database">
63 <cfif cfcatch.Errorcode IS "01S03">
64 <p> The query did not update the fields.
65 </cfif>
66 </cfcatch>
67
68 </cftry>
69 </cfif>
70
71
72
|
Return to
AddAcronym.cfm
CVS log
Up to [Development] / p2rx-programs