[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody ShowFields.cfm,1.3,1.4
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-05-27 03:47:38
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv9945 Modified Files: ShowFields.cfm Log Message: Functionality Added: [ 744003 ] Added Form "Request Add Field(s)" to dbProcessBody/ShowFields.cfm Index: ShowFields.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowFields.cfm,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** ShowFields.cfm 25 May 2003 04:46:01 -0000 1.3 --- ShowFields.cfm 27 May 2003 03:47:20 -0000 1.4 *************** *** 7,34 **** ********************************************************************************************---> ! <!---||| 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"> ! <!--- Alternate the Row Colours from class style Odd to class style Even ---> ! <tr class="#IIF(fieldList.currentrow MOD 2, DE('Odd'), DE('Even'))#"> ! <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> \ No newline at end of file --- 7,72 ---- ********************************************************************************************---> ! <!------------------------------------> ! <!--- 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> ! ! <!---||| Show 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> ! ! <!---||| Show List of Fields |||---> ! <cfoutput query="fieldList"> ! <!--- Alternate the Row Colours from class style Odd to class style Even ---> ! <tr class="#IIF(fieldList.currentrow MOD 2, DE('Odd'), DE('Even'))#"> ! <td>#fieldList.FIELD#</td> ! <td><cfif fieldList.KEY IS NULL OR fieldList.KEY IS ""> <cfelse>#fieldList.KEY#</cfif></td> ! <td>#fieldList.TYPE#</td> ! <td><cfif fieldList.NULL IS "">NO<cfelse>#fieldList.NULL#</cfif></td> ! <td><cfif fieldList.DEFAULT IS NULL OR fieldList.DEFAULT IS ""> <cfelse>#fieldList.DEFAULT#</cfif></td> ! <td><cfif fieldList.EXTRA IS NULL OR fieldList.EXTRA IS ""> <cfelse>#fieldList.EXTRA#</cfif></td> ! </tr> ! </cfoutput> ! </table> ! ! <!----------------------------------------> ! <!--- Show Form "Request Add Field(s)" ---> ! <!----------------------------------------> ! <!---||| Initiate a Read Only lock to ensure the integrity of session variables |||---> ! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> ! <!---||| Create Form that links to AddField dbProcess |||---> ! <cfform action="#currentPath#?#SESSION.URLToken#&dbProcess=AddField&table=#URL.table#" method="post" name="FORM_RequestAddField" enablecab="yes" class="Fancy"> ! <fieldset class="Fancy"> ! <legend class="Fancy">Add New Field(s)</legend> ! ! <!---||| Allow User to Specify the Number of New Fields |||---> ! <label for="numberOfFields" class="Fancy">Number of New Fields:</label> ! <cfinput name="numberOfFields" type="text" value="1" size="2" maxlength="2" range="1,99" required="yes" message="You must enter an interger between 1 and 99 for the number of records field." validate="integer" class="Fancy" /> ! <br /> ! ! <!---||| Allow User to Specify the Location for the New Fields |||---> ! <label for="locationOfFields" class="Fancy">Location of New Fields:</label> ! <cfselect name="locationOfFields" size="1" required="yes" class="Fancy"> ! <!--- Create options for adding the new field(s) at the beginning and at the end of the current table ---> ! <option value="End" selected class="Fancy">At End of Table <cfoutput>#URL.table#</cfoutput></option> ! <option value="Beginning" class="Fancy">At Beginning of Table <cfoutput>#URL.table#</cfoutput></option> ! <!--- Create options for adding the new field(s) after each of the current fields ---> ! <cfoutput query="fieldList"> ! <option value="#fieldList.FIELD#" class="Fancy">After #fieldList.FIELD#</option> ! </cfoutput> ! </cfselect> ! <br /> ! ! <!---||| Submit Request |||---> ! <input name="DefineNewFields" type="submit" value="Define New Fields"> ! </fieldset> ! </cfform> ! </cflock> \ No newline at end of file |