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>
|
