[Mydatabasepilot-cvs] MyDatabasePilot/Query fieldList.cfm,NONE,1.1

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

Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv13828

Added Files:
	fieldList.cfm 
Log Message:
Functionality Added: [ 720526 ] Create a New File Query/fieldList.cfm

--- NEW FILE: fieldList.cfm ---
<!---*******************************************************************************************
* Copyright:        MyDatabase Pilot is distributed under the terms of the GNU GPL license     *
* Template:         Query/fieldList.cfm                                                        *
* Purpose:          Creates a Record Set with a list of fields and their properties            *
*                   in the current database                                                    *
* Requiremets:      - Connection Variables must already be set                                 *
*                   - Table name must have been passed to current template as a URL Variable   *
********************************************************************************************--->

<!---||| Find out the list of Fields and their properties in the Current Table |||--->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
	<!--- Create Recordset with a List of field names and their properties --->
	<cfquery name="fieldList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
		SHOW FIELDS FROM #url.table#;
	</cfquery>
</cflock>