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 Date changed: 02/23/2005 Prabin & Neena Creation and Documentation
14 --->
15
16 <cfquery name="progtypes" datasource="#Programsdb#">
17 Select ProgramType, ProgramTypeID
18 From dProgramTypes
19 Where Approved = 0
20 </cfquery>
21
22 neenan 1.1 <cfquery name="getORG" datasource="#Programsdb#">
23 SELECT OrganizationName
24 FROM dOrganization
25 WHERE OrgID = #URL.OrgID#
26 </cfquery>
27
28 <body>
29 <!-- #BeginEditable "Content" -->
30 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
31 <tr>
32 <td>
33 <p>
34 <span class="subheading">
35 ADD A PROGRAM <img src="../images/siteimage/dart.gif" border="0">
36 PROGRAM TYPES<img src="../images/siteimage/dart.gif" border="0"></span>
37 <span class="sublink2">Step 3 <img src="../images/siteimage/dart.gif" border="0"></span><br><br>
38
39
40 <cfoutput query="getORG">Organization Name: <strong>#OrganizationName#</strong></cfoutput><br><br>
41
42 Please select the program type(s) which describe your organization.<br>
43 neenan 1.1 <span class="redtext"><font style="color: red">* At least One</font></span><br><br>
44 <form name="addProgramsTypes" action="addeditprograms.cfm?fuseaction=AssociateServices&OrgID=<cfoutput>#URL.OrgID#</cfoutput>" onsubmit="return Validate(this)" method="post">
45 <table width="95%" border="0" cellspacing="0" cellpadding="5" bgcolor="#F4FFE9">
46 <cfloop query="progtypes">
47 <tr>
48 <cfoutput>
49 <td colspan="2"><div class="formtext">
50 <input type="checkbox" name="ProgramTypeID" value="#ProgramTypeID#">
51 #ProgramType#</div>
52 </td>
53 </cfoutput>
54 </tr>
55 </cfloop>
56 <tr>
57 <td colspan="2"><div class="formtext">
58 <INPUT type="submit" value="Submit">
59 <INPUT type="reset" value="Reset"></div></td>
60 </tr>
61 </table>
62 </form>
63
64 neenan 1.1 </td>
65 </tr>
66 </table>
67 </p>
68
69 <!--- <cfinclude template="../cfi/global_footer.cfm"> --->
|