Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldQueryNames (#ListLen(THIS.fieldNames)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldTypes (#ListLen(THIS.fieldTypes)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldLengths (#ListLen(THIS.fieldLengths)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of maxLengths (#ListLen(THIS.maxLengths)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldDefaults (#ListLen(THIS.fieldDefaults)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldRequired (#ListLen(THIS.fieldRequired)#)
Length of fieldDisplayNames (#ListLen(THIS.displayfields)#) does not match length of fieldValidation (#ListLen(THIS.fieldValidation)#)
You must have the variable application.rootpath defined in order for this to work. <CFOUTPUT>#THIS.pagename#</CFOUTPUT> Edit SELECT * FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT #THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT #THIS.tableid#, #THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.orderingfield#>#ordervalue# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#newcatorder# WHERE #THIS.tableid#=#ordervalue2# DELETE FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT * FROM #THIS.associatedDeleteTable# WHERE #THIS.associatedDeleteTableId#=#url.id# DELETE FROM #THIS.associatedDeleteTable# WHERE #THIS.associatedDeleteTableId#=#url.id# DELETE FROM #THIS.selectArray[k][6]# WHERE #THIS.selectArray[k][9]# = #url.id# SELECT * FROM #THIS.tablename# WHERE #THIS.tableid#=#Evaluate('form.#THIS.tableid#')# SELECT * FROM #THIS.tablename# WHERE #THIS.tableid#=#Evaluate("form.#ListGetAt(THIS.fieldnames, 1)#")# SELECT * FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT * FROM #THIS.tablename# a, #THIS.queryJoinTable# b WHERE a.#THIS.queryJoinMainTableField#=b.#THIS.queryJoinSecondaryTableField# AND a.#THIS.tableid#=#THIS.urlParms.id# SELECT * FROM #THIS.tablename# WHERE #THIS.tableid#=#THIS.urlParms.id# SELECT max(#THIS.tableid#) as maxid, count(#THIS.tableid#) as totalrecords FROM #THIS.tablename# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#tempQueryName.totalrecords# WHERE #THIS.tableid#=#tempQueryName.maxid# SELECT max(#THIS.tableid#) as maxid, count(#THIS.tableid#) as totalrecords FROM #THIS.tablename# DELETE FROM #THIS.selectArray[k][6]# WHERE #THIS.selectArray[k][9]# = #tableid# INSERT INTO #THIS.selectArray[k][6]# (#THIS.selectArray[k][9]#,#THIS.selectArray[k][8]#) VALUES(#tableid#,#listvalue#) SELECT #THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT #THIS.tableid#,#THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.orderingfield#=#previous# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#previous# WHERE #THIS.tableid#=#url.id# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#previous1# WHERE #THIS.tableid#=#previous2# SELECT #THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.tableid#=#url.id# SELECT #THIS.tableid#,#THIS.orderingfield# FROM #THIS.tablename# WHERE #THIS.orderingfield#=#next# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#next# WHERE #THIS.tableid#=#url.id# UPDATE #THIS.tablename# SET #THIS.orderingfield#=#next1# WHERE #THIS.tableid#=#next2# SELECT * FROM #THIS.selectArray[selectArrayindex][1]# ORDER BY #THIS.selectArray[selectArrayindex][5]# SELECT * FROM #THIS.radioArray[radioArrayindex][1]# ORDER BY #THIS.radioArray[radioArrayindex][5]#

ADD AN VIEW EDIT #UCASE(THIS.pagename)#


Field length cannot be zero for #displayname# Field length cannot be zero for #displayname# Field length cannot be zero for #displayname# Field length cannot be zero for #displayname# Field length cannot be zero for #displayname# Field length cannot be zero for #displayname#
#displayField#:  
#displayField#:  
#displayField#: #fieldvalue# 
#displayField# 
#displayField#:  
#displayField#:  
#displayField#:  
#displayField#:    
#displayField#:    
#displayField#:  
#displayField#: // Calculate basepath for FCKeditor. It's in the folder right above _samples // basePath = Left(cgi.script_name, FindNoCase('_samples', cgi.script_name)-1); basepath = "#application.fckbasepath#"; fckEditor = createObject("component", "#basePath#fckeditor"); fckEditor.instanceName = "#fieldname#"; fckEditor.value = '#fieldvalue#'; fckEditor.basePath = basePath; fckEditor.width = "#width#"; fckEditor.height = '#height#'; fckEditor.create(); // create the editor.
#displayField#: #fieldvalue#
#displayField#:
#displayField#:
checked> #Evaluate(THIS.selectArray[k][2])#  
    Currently selected items (only changes after edit complete):
       - #Evaluate("selectQuery.#THIS.selectArray[k][2]#")#
#displayField#: #displayvalue# #displayvalue#
Current File: #filenameClient#     (NONE)         Delete File
#displayField#: #filenameClient#     Add FileChange File
Current File:      #filenameClient#     You must have the variable application.rootpath defined in order for this to work.      #filenameClient#     (NONE)         Delete Image
#displayField#:      #filenameClient#     You must have the variable application.rootpath defined in order for this to work.      #filenameClient#     Add ImageChange Image
#displayField#: checked>
#displayField#:  
 
SELECT * FROM #THIS.selectArray[k][6]# WHERE #THIS.selectArray[k][9]# = #Evaluate("THIS.#THIS.queryname#.#ListGetAt(THIS.fieldnames, 1)#")#