1 neenan 1.1 <!--- Name: dsp_Addprogramtypes.cfm
2 Purpose: It helps to add the relation between existing program types and organization in your dummy program database.
3 It also transfers all the programTypeID values that the user selects to act_addProgramTypes.cfm where
4 the actual action of inserting the association between the organization and its related program
5 types in table dOrgToProgramType
6 Date created: 02/23/2005
7 Dependancy: URL.Orgid
8 Variables: ProgramTypeID - Unique ID of each ProgramType
9 ProgramType - Type of the Program organization
10 OrganizationName - Name of the organization
11
12 Functions:
|
13 pKanel 1.3 Date changed: 02/23/2005 Prabin & Neena Creation and Documentation
14 08/15/2005 Terry Added URL variable for skipping step (line 46)
15 08/15/2005 Terry Documentation
|
16 neenan 1.1 --->
17
18 <cfquery name="progtypes" datasource="#Programsdb#">
|
19 pKanel 1.3 Select ProgramType, ProgramTypeID
20 From dProgramTypes
21 Where Approved = 0
|
22 neenan 1.1 </cfquery>
23
24 <cfquery name="getORG" datasource="#Programsdb#">
25 SELECT OrganizationName
26 FROM dOrganization
27 WHERE OrgID = #URL.OrgID#
28 </cfquery>
29
30 <body>
|
31 pKanel 1.3 <!-- #BeginEditable "Content" -->
|
32 neenan 1.1 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
33 <tr>
34 <td>
35 <p>
|
36 pKanel 1.3 <span class="subheading">
37 ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
38 PROGRAM TYPES<img src="../images/siteimage/dart.gif" border="0"></span>
39 <span class="sublink2">Step 3 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
|
40 neenan 1.1
41
42 <cfoutput query="getORG">Organization Name: <strong>#OrganizationName#</strong></cfoutput><br><br>
43
44 Please select the program type(s) which describe your organization.<br>
|
45 pKanel 1.3 <span class="redtext"><font style="color: red">* Atleast One</font></span><br><br>
46 <form name="addProgramsTypes" action="addeditprograms.cfm?fuseaction=AssociateServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>&skip=0" onsubmit="return Validate(this)" method="post">
|
47 neenan 1.1 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
48 <cfloop query="progtypes">
49 <tr>
50 <cfoutput>
51 <td colspan="2"><div class="formtext">
52 <input type="checkbox" name="ProgramTypeID" value="#ProgramTypeID#">
53 #ProgramType#</div>
54 </td>
55 </cfoutput>
56 </tr>
57 </cfloop>
58 <tr>
59 <td colspan="2"><div class="formtext">
60 <INPUT type="submit" value="Submit">
61 <INPUT type="reset" value="Reset"></div></td>
62 </tr>
63 </table>
64 </form>
65
66 </td>
67 </tr>
68 neenan 1.1 </table>
69 </p>
|
70 pKanel 1.3
71 <!--- <cfinclude template="../cfi/global_footer.cfm"> --->
|