|
version 1.1, 2005/03/09 03:18:14 UTC
|
version 1.2, 2005/09/27 18:30:53 UTC
|
|
|
|
| <cfelse> |
<cfelse> |
| <cfset FinalHotline='#form.Hotline_Area#-#form.Hotline_Prefix#-#form.Hotline_Num#'> |
<cfset FinalHotline='#form.Hotline_Area#-#form.Hotline_Prefix#-#form.Hotline_Num#'> |
| </cfif> |
</cfif> |
| <!--- <cfset urlvalue = #URL.orgId#> ---> |
|
| |
<Cfquery name="getstatus" datasource="#programsdb#"> |
| |
select updatestatus as ups |
| |
from dorganization |
| |
where OrgID=#URL.OrgID# |
| |
</CFQUERY> |
| <cfquery name="Updateorg" datasource="#programsdb#"> |
<cfquery name="Updateorg" datasource="#programsdb#"> |
| Update dOrganization |
Update dOrganization |
| Set OrganizationName='#form.OrganizationName#', |
Set OrganizationName='#form.OrganizationName#', |
|
|
|
| Address2='#form.Address2#', |
Address2='#form.Address2#', |
| Hotline='#FinalHotline#', |
Hotline='#FinalHotline#', |
| City='#form.City#', |
City='#form.City#', |
| StateOrProvince='#form.StateOrProvince#', |
StateOrProvince='#form.State#', |
| URL='#form.URL#', |
URL='#form.URL#', |
| PostalCode='#form.PostalCode#', |
PostalCode='#form.PostalCode#', |
| Country='#form.Country#', |
Country='#form.Country#', |
| GraphicURL='#form.GraphicURL#', |
GraphicURL='#form.GraphicURL#', |
| Profile='#form.Profile#' |
Profile='#form.Profile#', |
| |
updateStatus = <Cfif #getstatus.ups# is 0>'2'<cfelseif #getstatus.ups# is 1>'1'<cfelseif #getstatus.ups# is 2>'2'</CFIF> |
| Where OrgID=#URL.OrgID# |
Where OrgID=#URL.OrgID# |
| </cfquery> |
</cfquery> |
| |
|
| <!--- <cfoutput> <input type="hidden" name="OrgId1" value="#urlvalue#"> </cfoutput> ---> |
|
Return to
act_updateorganization.cfm
CVS log
Up to [Development] / p2rx-programs