[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessInit AddField.cfm,1.1,1.2

[<nan...@us...>]

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessInit
In directory sc8-pr-cvs1:/tmp/cvs-serv12920/dbProcessInit

Modified Files:
	AddField.cfm 
Log Message:
Functionality Added:
[ 749311 ] Added Call to Custom Tag Query/alterTable.cfm 
- The call is either in execution mode or in view mode 
only, depending on how dbProcess "AddField" was called

Index: AddField.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessInit/AddField.cfm,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** AddField.cfm	27 May 2003 04:03:14 -0000	1.1
--- AddField.cfm	5 Jun 2003 04:08:50 -0000	1.2
***************
*** 5,12 ****
  ********************************************************************************************--->
  
- <!---||| Get List of Field Names and Their Properties |||--->
  <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
  <cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 	<!--- Invoke fieldList Custom Tag via CFModule --->
  	<cfmodule template="../Query/fieldList.cfm"
  		queryName="fieldList"
--- 5,11 ----
  ********************************************************************************************--->
  
  <!--- Initiate a Read Only lock to ensure the integrity of session variables --->
  <cflock timeout=20 throwontimeout="no" type="readonly" scope="SESSION">
! 	<!--- Get List of Field Names and Their Properties --->
  	<cfmodule template="../Query/fieldList.cfm"
  		queryName="fieldList"
***************
*** 15,17 ****
--- 14,43 ----
  		password="#SESSION.password#"
  		table="#URL.table#">
+ 
+ 	<!--- Create alterSpec array or structures --->
+ 	
+ 	<!--- If execution of Alter Table was requested by the form ... --->
+ 	<cfif IsDefined("FORM.ExecuteAlterTable")>
+ 		<!--- Get Generated SQL and execute it --->
+ 		<cfmodule template="../Query/alterTable.cfm"
+ 			datasource="#SESSION.dataSource#"
+ 			username="#SESSION.userName#"
+ 			password="#SESSION.password#"
+ 			table="#URL.table#"
+ 			execute="TRUE"
+ 			sqlOutputType="BOTH"
+ 			rawOutput="rawOutput"
+ 			htmlOutput="htmlOutput">
+ 		</cfmodule>
+ 	<!--- Otherwise ... --->
+ 	<cfelse>
+ 		<!--- Get Generated SQL, but do not execute it --->
+ 		<cfmodule template="../Query/alterTable.cfm"
+ 			table="#URL.table#"
+ 			execute="FALSE"
+ 			sqlOutputType="BOTH"
+ 			rawOutput="rawOutput"
+ 			htmlOutput="htmlOutput">
+ 		</cfmodule>
+ 	</cfif>
  </cflock>