[Mydatabasepilot-cvs] MyDatabasePilot/dbProcessBody AddField.cfm,1.9,1.10
Status: Alpha
Brought to you by:
nanoface
From: <nan...@us...> - 2003-06-13 15:48:04
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv8443/dbProcessBody Modified Files: AddField.cfm Log Message: [ 754037 ] Moved Default FORM Values -length#i# -valueList#i# -numberOfDecimals#i# -default#i# From dbProcessBody/AddField.cfm To: dbProcessInit/AddField.cfm Index: AddField.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/AddField.cfm,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** AddField.cfm 12 Jun 2003 04:34:42 -0000 1.9 --- AddField.cfm 13 Jun 2003 15:47:51 -0000 1.10 *************** *** 1,520 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/AddField.cfm * ! * Purpose: Displays the Body Content for the AddField 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 * ! ********************************************************************************************---> ! ! <!---||| Initiate a Read Only lock to ensure the integrity of session variables |||---><cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> ! <!---||| Create AddField FORM |||---> [...1005 lines suppressed...] ! ! <!---||| Submit Request |||---> ! <fieldset class="Fancy"> ! <legend class="Fancy">Run Alter Table Query</legend> ! <!---***Insert a query box of the SQL that is about to be executed***---> ! <input name="ExecuteAlterTable" type="submit" value="Add Fields as Defined Above"> ! </fieldset> ! </cfform> ! </cflock> ! ! ! ! ! <h3>Quick Reference Notes</h3> ! <ul> ! <li>Note that if you specify ZEROFILL for a column, MySQL will automatically add the UNSIGNED attribute to the column.</li> ! <li>BLOB and TEXT field types can not have default values.</li> ! <li>A DEFAULT value has to be a constant, it cannot be a function or an expression.</li> ! <li>When putting an index on a BLOB or TEXT column, you MUST always specify the length of the index.</li> </ul> |