Return to act_finalprocess.cfm CVS log

Up to [Development] / p2rx-programs

Changed the reoccurence of Address 1 in the cfmail tag to address1 and address2

<!--- 
    Please change the 'To' & 'From' fields in the CFmail tag to include each center admin email address 

 	Name:  act_finalprocess.cfm
    	Purpose: This file is as action file to bring up all the information such as organization details, services selected. The 
				email of the user is also selected so the details can be emailed to the concerned person. The hidden variable - Visitor_id
				using the GetUserEmail query passed onto the next dsp_adduser.cfm form if user selects "Edit the program" on the final 
				confirmation page.
		Date created: 02/23/2005
       	Dependancy: URl.Orgid
		Variables: 	
					
		Functions: 
		Date changed: 
					02/24/2005			Prabin & Neena  Created & Documentation
---> 	

<cfquery name="GetUserEmail" datasource="#programsdb#">
	Select 		*
	From 		OutsideUsers
	where orgid= #URL.OrgID#
</cfquery>


<cfquery name="DisPlayProgramExpertise" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Expertise' and o.OrgID=#URL.OrgID#
</cfquery> 

<cfquery name="DisPlayProgramClients" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Clients' and o.OrgID=#URL.OrgID#
</cfquery> 

<cfquery name="DisPlayProgramResource" datasource="#programsdb#">
select *
from dService s, dOrgtoService os, dOrganization o
where o.orgID=os.orgID and os.ServiceID=s.ServiceID and s.type='Resources' and o.OrgID=#URL.OrgID#
</cfquery> 

<cfquery name="getOrg" datasource="#programsdb#">
select * from dorganization
where OrgID=#URL.OrgID#
</cfquery>

<cfoutput><input type="hidden" name="vid" value="#GetUserEmail.visitor_id#"></cfoutput>

<cfmail from="ryoder@unomaha.edu" to="pkanel@mail.unomaha.edu,nnaidu@mail.unomaha.edu, #getUserEmail.Email#" subject="Information of the organization has been changed">
#GetUserEmail.fname# #GetUserEmail.lname#
This e-mail is automatically generated to let you know that the information for your organization
has been changed in our database. We might contact you to validate the information. Once the information has been 
validated, the status for the organization will be changed and will be displayed on our site.

Current Information:
====================

Organization Name: #getORG.OrganizationName#
Profile: #getOrg.Profile#
Division: #getOrg.Division#
Address: #getOrg.Address1# #getOrg.Address2#
		 #getOrg.City# #getOrg.StateOrProvince# #getOrg.PostalCode#
		 #getOrg.Country#  
Region:	 #getOrg.Region#
TimeZone: #getOrg.TimeZone#
Phone Number: #getOrg.Phone#
Extension: #getOrg.Extension#
Fax Number: #getOrg.FaxNumber#  
Email Address: #getOrg.EmailName#  
HotLine:  #getOrg.Hotline#
URL: #getOrg.URL#  
Graphic URL: #getOrg.GraphicURL#  
Resources: #DisplayProgramResource.Service# 
Expertise: #DisplayProgramExpertise.Service#
Clients:   #DisplayProgramClients.Service#
		  
</cfmail>