Return to act_insertPrograms.cfm CVS log

Up to [Development] / p2rx-programs

Modifications

<P>
<!--- <a href="../directories/programs.cfm" class="sublink2"> --->
Agencies and Programs <img src="../images/siteimage/dart.gif" border="0"><!--- </a> --->
</p>


<cfquery name="dorg" datasource="#programsdb#">
Select * from Organization where Orgid = #URL.Orgid#
</cfquery>

<!--- <cfquery name="InsertOrg" datasource="#programsdb#">
Update dOrganization
	Set 	OrganizationName='#dorg.OrganizationName#',  
			Phone='#dorg.Phone#',  
			Extension='#dorg.Extension#',
			Division='#dorg.Division#',
			FaxNumber='#dorg.FaxNumber#', 
			TimeZone='#dorg.TimeZone#',  
			Address1='#dorg.Address1#',  
			EmailName='#dorg.EmailName#',  
			GeoServiceID='#dorg.GeoServiceID#',  
			Address2='#dorg.Address2#',  
			Hotline='#dorg.Hotline#',  
			City='#dorg.City#',  
			StateOrProvince='#dorg.StateOrProvince#',  
			URL='#dorg.URL#',  
			PostalCode='#dorg.PostalCode#',  
			Country='#dorg.Country#',
			GraphicURL='#dorg.GraphicURL#',
			Profile='#dorg.Profile#'
	Where 	OrgID=#URL.OrgID#
					
</cfquery> --->
<!--- 
<cfquery name="getorgid" datasource="#programsdb#">
Select max(orgid) as maxid from dorganization 
</cfquery> --->

<!--- <cfset maxorgid = getorgid.maxid> --->
<!--- Associating the dummy table from dcontacts table with the new orgID in the Contacts table - This query will get all the program type id's that have been 
associated with the program type.---> 

<cfquery name="getcontacts" datasource="#programsdb#">
Select * from contacts where Orgid = #URL.Orgid#
</cfquery>


<!--- Insert notepad Here ---> 
 
 <!--- changes to ORgid --->
 <CFIF #URL.fuseaction# IS "GETORG">
<cfquery name="provider1" datasource="#programsdb#">
			SELECT *
			FROM dOrganization
			where orgID = #URL.Orgid#
</cfquery>

<cflocation url="addeditprograms.cfm?FuseAction=Editorg&OrgID=#URL.Orgid#" addToken="No">
<!--- <cfoutput><input type="hidden" name="OrgID" value="maxorgid"></cfoutput>
<table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
        <tr> 
          <td> 
            <p><span class="tableheading">Programs in Region 7</span> <br><br>
			<p><cfoutput query="provider1"><a href="details.cfm?orgid=#maxorgid#" class="subheading">#organizationName#</a> 
			&nbsp;&nbsp;&nbsp;&nbsp;<a href="addeditprograms.cfm?FuseAction=Editorg&OrgID=#maxorgid#">Edit</a>
			
			<br><br><!--- </cfoutput> --->
			</cfoutput> --->
		
			<!--- <a href="#top"><img src="../images/SiteImage/top.gif" border="0"></a><br><br>

        </tr>
</table> --->


</CFIF>