<cfoutput>#strPageTitle#</cfoutput>

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#

	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

				#strCode#

CMS code

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

				#strCFMLObject#

[+] dsp_list.cfm

				#strCFMLList#

[+] dsp_form.cfm

				#strCFMLForm#

[+] act_save.cfm

				#strCFMLSave#

[+] act_delete.cfm

				#strCFMLDelete#

CF Code Builder