Return to act_addProgramtypes.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name:  act_addprogramTypes.cfm
    	Purpose: This functions as the action file to link the existing programtypes selected by the user for their 
				organization to the	dorganization table. The values are passed on from the dsp_addprogramtypes.cfm form.
				Each time this page is called,the records in the dorgtoprogramtype table are deleted for the particular 
				organization and fresh records are appended.
		Date created: 02/24/2005
       	Dependancy: URL.URL.Orgid
		Variables: 	
					
		Functions: 
		Date changed: 	02/24/2005			Prabin & Neena  Created & Documentation
---> 	


<cfquery name="deletepg" datasource="#Programsdb#">
delete 
from   dOrgToProgramType
Where	OrgID = #URL.ORGID#
</cfquery> 


<cfset Array = #ListToArray(form.ProgramTypeID)#>

<cfloop from="1" to="#ArrayLen(Array)#" index="x">
	<cfquery datasource="#Programsdb#">
	Insert Into dOrgtoprogramtype (OrgID, ProgramTypeID)
		Values(#URL.OrgID#, #Array[x]#)
	</cfquery>
</cfloop>