SELECT DISTINCT T.TABNAME AS TABLE_NAME FROM SYSCAT.Tables T JOIN SYSCAT.Columns C ON T.TABNAME = C.TABNAME WHERE T.TABSCHEMA = 'LAWINFO' ORDER BY TABLE_NAME SELECT C.*, T.TABNAME AS TABLE_NAME, Upper(C.COLNAME) AS COLUMN_NAME, CASE C.NULLS WHEN 'Y' THEN 'no' WHEN 'N' THEN 'yes' END AS IS_REQUIRED, C.TYPENAME AS DATA_TYPE, C.LENGTH AS CHARACTER_MAXIMUM_LENGTH, C.COLNO FROM SYSCAT.Tables T JOIN SYSCAT.Columns C ON T.TABNAME = C.TABNAME WHERE T.TABNAME = '#arguments.table_name#' ORDER BY C.COLNO, C.NULLS ASC <cfoutput>#strPageTitle#</cfoutput>
#strPageTitle#
#strPageTitle#
	Assumption: Table Names use the following naming convention: JSCT_CMSN_TBL
	
	

Schema name:
Table Name:
Object name:
Table PK:
Create Files?
"> "> ">
#strRequiredIndicator##tableMetaDataQry.column_name#?
>Yes
>No ">
#strRequiredIndicator##tableMetaDataQry.column_name#?
##form.#tableMetaDataQry.column_name### ">
#strRequiredIndicator##tableMetaDataQry.column_name#:
">
"> "> "> SELECT " & strColumnList & " FROM #form.txtSchemaName#.#form.txtTableName# ORDER BY #form.txtTablePK# SELECT " & strColumnList & " FROM #form.txtSchemaName#.#form.txtTableName# WHERE #form.txtTablePK# = DELETE FROM #form.txtSchemaName#.#form.txtTableName# WHERE #form.txtTablePK# = " & strSaveRecordArguments & " INSERT INTO #form.txtSchemaName#.#form.txtTableName# ( " & strColumnListForInsert & " ) VALUES ( " & strInsertValues & " ) SELECT IDENTITY_VAL_LOCAL() AS last_id FROM SYSIBM.SYSDUMMY1 UPDATE #form.txtSchemaName#.#form.txtTableName# SET " & strUpdateValues & " WHERE #form.txtTablePK# = "> " & strCFParams & " " & strDataFromDB & "
##DateFormat(url.savetime, 'MM/DD/YYYY')## ##TimeFormat(url.savetime, 'hh:mm:ss tt')##

" & strFormFields & "
 
"> "> "> .cssFormLabel { color: black; background-color: ##dddddd; line-height: 20px; font-familly: verdana; font-weight: bold; font-size: 10px; } .cssAdminFormContainerTable { background-color: ##eeeeee; width: 1000px; } .cssSaveButton { width: 150px; } .cssOnMouseOverBG { background-color:whiteSmoke; cursor:pointer; }
Name
Action
###strObjectName#Qry.#Right(txtTableName, 3)#_Name## Edit | Delete
">

#strObjectName#

List | New
">
Object Code

[+] #strObjectName#.cfc


CMS code

[+] dsp_#LCase(strObjectName)#.cfm

[+] dsp_list.cfm

[+] dsp_form.cfm

[+] act_save.cfm

[+] act_delete.cfm


CF Code Builder