[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowFields.cfm,1.1.1.1,1.2
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-04-13 06:35:27
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv23671 Modified Files: ShowFields.cfm Log Message: Header comment changed Index: ShowFields.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowFields.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ShowFields.cfm 23 Mar 2003 03:44:33 -0000 1.1.1.1 --- ShowFields.cfm 13 Apr 2003 06:35:24 -0000 1.2 *************** *** 1,35 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowFields.cfm * ! * Purpose: Displays the Body Content for the ShowFields Database Process * ! * Requiremets: -fieldList Query must be run on same page prior to including this template * ! * -url.table (table name) must have been passed from calling template * ! * Todo: * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!---||| Show Fields in Current Table |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <!--- Show table name ---> ! <tr><th colspan="6">Fields in Table <cfoutput>#url.table#</cfoutput></th></tr> ! <!--- Column Headers ---> ! <tr> ! <th>Field Name</th> ! <th>Key</th> ! <th>Data Type</th> ! <th>Null Value Allowed</th> ! <th>Default Value</th> ! <th>Extra Properties</th> ! </tr> ! <!--- Create List of Fields ---> ! <cfoutput query="fieldList"> ! <tr> ! <td>#FIELD#</td> ! <td><cfif KEY IS NULL OR KEY IS ""> <cfelse>#KEY#</cfif></td> ! <td>#TYPE#</td> ! <td><cfif NULL IS "">NO<cfelse>#NULL#</cfif></td> ! <td><cfif DEFAULT IS NULL OR DEFAULT IS ""> <cfelse>#DEFAULT#</cfif></td> ! <td><cfif EXTRA IS NULL OR EXTRA IS ""> <cfelse>#EXTRA#</cfif></td> ! </tr> ! </cfoutput> </table> --- 1,33 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowFields.cfm * ! * Purpose: Displays the Body Content for the ShowFields Database Process * ! * Requiremets: -fieldList Query must be run on same page prior to including this template * ! * -url.table (table name) must have been passed from calling template * ! ********************************************************************************************---> ! ! <!---||| Show Fields in Current Table |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <!--- Show table name ---> ! <tr><th colspan="6">Fields in Table <cfoutput>#url.table#</cfoutput></th></tr> ! <!--- Column Headers ---> ! <tr> ! <th>Field Name</th> ! <th>Key</th> ! <th>Data Type</th> ! <th>Null Value Allowed</th> ! <th>Default Value</th> ! <th>Extra Properties</th> ! </tr> ! <!--- Create List of Fields ---> ! <cfoutput query="fieldList"> ! <tr> ! <td>#FIELD#</td> ! <td><cfif KEY IS NULL OR KEY IS ""> <cfelse>#KEY#</cfif></td> ! <td>#TYPE#</td> ! <td><cfif NULL IS "">NO<cfelse>#NULL#</cfif></td> ! <td><cfif DEFAULT IS NULL OR DEFAULT IS ""> <cfelse>#DEFAULT#</cfif></td> ! <td><cfif EXTRA IS NULL OR EXTRA IS ""> <cfelse>#EXTRA#</cfif></td> ! </tr> ! </cfoutput> </table> |