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