1 neenan 1.3
|
2 pKanel 1.4
3 <P>
|
4 neenan 1.3 <!--- <a href="../directories/programs.cfm" class="sublink2"> --->
|
5 pKanel 1.4 Agencies and Programs <img src="../images/siteimage/dart.gif" border="0"><!--- </a> --->
|
6 neenan 1.1 </p>
7
8
9 <cfquery name="dorg" datasource="#programsdb#">
10 Select * from Organization where Orgid = #URL.Orgid#
11 </cfquery>
12
|
13 pKanel 1.4 <!--- <cfquery name="InsertOrg" datasource="#programsdb#">
14 Update dOrganization
15 Set OrganizationName='#dorg.OrganizationName#',
16 Phone='#dorg.Phone#',
17 Extension='#dorg.Extension#',
18 Division='#dorg.Division#',
19 FaxNumber='#dorg.FaxNumber#',
20 TimeZone='#dorg.TimeZone#',
21 Address1='#dorg.Address1#',
22 EmailName='#dorg.EmailName#',
23 GeoServiceID='#dorg.GeoServiceID#',
24 Address2='#dorg.Address2#',
25 Hotline='#dorg.Hotline#',
26 City='#dorg.City#',
27 StateOrProvince='#dorg.StateOrProvince#',
28 URL='#dorg.URL#',
29 PostalCode='#dorg.PostalCode#',
30 Country='#dorg.Country#',
31 GraphicURL='#dorg.GraphicURL#',
32 Profile='#dorg.Profile#'
33 Where OrgID=#URL.OrgID#
34 pKanel 1.4
35 </cfquery> --->
36 <!---
|
37 neenan 1.1 <cfquery name="getorgid" datasource="#programsdb#">
38 Select max(orgid) as maxid from dorganization
|
39 pKanel 1.4 </cfquery> --->
|
40 neenan 1.1
|
41 pKanel 1.4 <!--- <cfset maxorgid = getorgid.maxid> --->
|
42 neenan 1.1 <!--- 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
43 associated with the program type.--->
44
45 <cfquery name="getcontacts" datasource="#programsdb#">
46 Select * from contacts where Orgid = #URL.Orgid#
47 </cfquery>
48
49
|
50 pKanel 1.4 <!--- Insert notepad Here --->
|
51 neenan 1.1
|
52 pKanel 1.4 <!--- changes to ORgid --->
|
53 neenan 1.1 <CFIF #URL.fuseaction# IS "GETORG">
54 <cfquery name="provider1" datasource="#programsdb#">
55 SELECT *
56 FROM dOrganization
|
57 pKanel 1.4 where orgID = #URL.Orgid#
|
58 neenan 1.1 </cfquery>
59
|
60 pKanel 1.4 <cflocation url="addeditprograms.cfm?FuseAction=Editorg&OrgID=#URL.Orgid#" addToken="No">
|
61 neenan 1.2 <!--- <cfoutput><input type="hidden" name="OrgID" value="maxorgid"></cfoutput>
|
62 neenan 1.1 <table width="100%" border="0" cellspacing="0" cellpadding="10" name="text">
63 <tr>
64 <td>
65 <p><span class="tableheading">Programs in Region 7</span> <br><br>
66 <p><cfoutput query="provider1"><a href="details.cfm?orgid=#maxorgid#" class="subheading">#organizationName#</a>
67 <a href="addeditprograms.cfm?FuseAction=Editorg&OrgID=#maxorgid#">Edit</a>
68
69 <br><br><!--- </cfoutput> --->
|
70 neenan 1.2 </cfoutput> --->
|
71 neenan 1.1
|
72 neenan 1.2 <!--- <a href="#top"><img src="../images/SiteImage/top.gif" border="0"></a><br><br>
|
73 neenan 1.1
74 </tr>
|
75 neenan 1.2 </table> --->
|
76 neenan 1.1
77
78 </CFIF>
|
Return to
act_insertPrograms.cfm
CVS log
Up to [Development] / p2rx-programs