1. System Functions (Common utility functions)

USAGE: <FunctionName>

Function Name Description
ew_IsNotEmpty(val) (v10+) Return if value is not empty
Parms
 val - value
ew_IsEmpty(val) (v10+) Return if value is empty
Parms
 val - value
ew_InArray(val, ar) (v10+) Return if value is in array
Parms
 val - value
 ar - array
ew_FormObj(ctlid) (v10+) Return form object name
Parms
 ctlid - control id
ew_GetLanguageFields(tbl, fld, name) (v10+) Return field array for multi-language
Parms
 tbl - table object
 fld - field object
 name - field property name
ew_SelectFieldName(arflds, idx) (v10+) Return SELECT field from language field array
Parms
 arflds - field array
 idx - language index
ew_AddSelectField(ar, tbl, arflds, cnt, alias) (v10+) Add SELECT fields to field array
Parms
 ar - field array
 tbl - table object
 arflds - language field array
 cnt - language count
 alias - field alias
ew_SelectFields(ar, idx, sep) (v10+) Return SELECT field list from language field array
Parms
 ar - field array
 idx - language index
 sep - field separator
ew_SqlSelect(sSelectLimit, sDistinct, sSelect, sFrom) (v10+) Return SQL SELECT statement
Parms
 sSelectLimit - SELECT LIMIT part
 sDistinct - use SELECT DISTINCT
 sSelect - SELECT part
 sFrom - FROM part
ew_CustomScriptRowCnt() (v10+) Return custom template script id
ew_CustomScriptRowStartVar() (v10+) Return custom template row start variable
ew_CustomScriptRowVar() (v10+) Return custom template row variable
ew_CustomScriptVar() (v10+) Return custom template control variable
ew_CustomScriptId(name, type ,idx) (v10+) Return custom template script id
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_CustomScriptTag(name, type, idx) (v10+) Return custom template script tag
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_GetJsScript(html) (v10+) Return JavaScript from HTML
Parms
 html - source HTML
ew_RemoveJsScript(html) (v10+) Remove JavaScript from HTML
Parms
 html - source HTML
ew_Like(pat) (v10+) Return SQL LIKE pattern
Parms
 pat - source field pattern
ew_CastFieldForLike(fld, type) (v10+) Return SQL that cast non-string field for LIKE statement
Parms
 fld - field SQL
 type - field type
ew_ContainText(str, find) Return if source string contains find string
Parms
 str - source string
 find - find string
ew_HasTagValue(fld, val) (v9.0+) Return if field contains tag value
Parms
 fld - field object
 val - tag value
ew_FldTagValues(fld) (v9.0+) Return field tag values
Parms
 fld - field object
ew_SplitTagValues(str) Split tag values to array
Parms
 str - field tag values
ew_IsBinaryField(fld) Return if field is binary field
Parms
 fld - field object
ew_ImageViewUrl(tblvar, fld, bQuoted) Return image view url
Parms
 tblvar - table variable
 fld - field object
 bQuoted - return as quoted string
ew_CssInherit(val) Return "inherit" if no value. Otherwise return original value.
Parms
 val - Css Value
ew_RowCntVar(v) (v8.0+) Return row object name (using lRowCnt)
Parms
 v - object name
ew_RowVar(v) Return row object name (using lRowIndex)
Parms
 v - object name
ew_RowVarQuoted(v) Return row object name (usinjg lRowIndex with quote)
Parms
 v - object name
ew_PageObj() Return page object
ew_GetPageObjByCtrlId(ctlid) (v9.0+) Return page object name based on control id
Parms
 ctlid - control id
ew_GetCtrlById(id) (v9.0+) Return control object based on control id
Parms
 ctlid - control id
ew_Val(v) (v8.0+) Return ASP boolean ("True"/"False")
Parms
 v - value
ew_JsVal(v) (v8.0+) Return javascript boolean ("true"/"false")
Parms
 v - value
ew_BtnCaption(name) Return button caption name
Parms
 name - original caption name
ew_SecurityCheck(sId, bSecurity, bAnonymous, bUserlevel) Return Security Checking codes
Parms
 sId - control id
 bSecurity - security is enabled
 sAnonymous - page is anonymous
 bUserLevel - user level is enabled
ew_AspCode(asp, typ) Return codes in ASP tags (i.e. <% ... %>)
Parms
 asp - original ASP codes
 typ - return codes in ASP tags if = 0
ew_RandomKey() Return random key
ew_FolderPath(id) Return folder path based on control id
Parms
 id - control id
ew_GetFileNameByCtrlID(id) Return file name based on control id
Parms
 id - control id
ew_RelFolder(f) Return relative folder to current output folder
Parms
 f - folder path
ew_RelPath(f1, f2) Return relative folder of f1 to f2
Parms
 f1 - folder path 1
 f2 - folder path 2
ew_EscapeString(sSrc, sEsc) Return escaped string
Parms
 sSrc - source string
 sEsc - escape type (double quote for VB, back slash for js)
ew_DoubleQuote(str, cnt) Return string with correct number of double quotes
Parms
 str - source string
 cnt - number of double quotes (0,1)
ew_Quote(str) Escape double quote in string with two double quotes
Parms
 str - source string
ew_Dequote(str) Replace embracing double quote or single quote
Parms
 str - source string
ew_UnformatName(name) Unformat "=" and "," in name
Parms
 name - name to be unformatted
ew_HtmlValue(str) Return value for proper display in html
Parms
 str - source string
ew_JsEncode(val) Encode value properly for js
Parms
 val - source value
ew_HtmlEncode(str) Encode value properly for html
Parms
 str - source string
ew_AspValue(str) Encode value properly for ASP
Parms
 str - source string
ew_GetFieldType(ftype) Return FIELD type based on ADO field type
Parms
 ftype - ADO Field Type
Output
 1 - Numeric
 2 - Date
 3 - String
 4 - Boolean
 5 - GUID
 6 - Others
 7 - Time
ew_SetDefaultValue(ftype, defvalue) Return default value
Parms
 ftype - ADO Field Type
 defvalue - default value
ew_BoolFieldTagValues(ftype, tagvalues) Return tag values for Boolean field
Parms
 ftype - ADO Field Type
 tagvalues - original tag values
ew_SQLPart(sSQL, sId) Return part of the SQL
Parms
 sSQL - original SQL
 sId - token for different part of SQL
(SELECT,FROM,WHERE,GROUP BY,HAVING,ORDER BY)
ew_RecPerPageList(sList, iRec) Return record per page list (comma separated)
Parms
 sList - original record per page list
 iRec - default record per page
ew_GetEditDateFormat(dateformat) (v10+) Return edit date format
Parms
 dateformat - original date format
ew_IsFldVirtualLookup(fld) (v8.0+) Return if field is a virtual lookup field
Parms
 fld - field object
ew_IsFldForceSelect(fld) (v8.0+) Return if field is force select (auto suggest)
Parms
 fld - field object
ew_VirtualLookupFldSql(fld, idx) (v10+) Return the SQL for the virtual lookup field
Parms
 fld - field object
 idx - language index
ew_VirtualLookupFldName(fld) (v8.0+) Return the field name for the virtual lookup field
Parms
 fld - field object
ew_QuotedName(name) (v8.0+) Return the properly quoted sql name
Parms
 name - table/field name
ew_SqlConcatName(name1, name2, fld, idx) (v9+) Return the concat sql name
Parms
 name1 - field name 1
 name2 - field name 2
 fld - field object
 idx - language index
ew_FieldSqlName(fld) (v8.0+) Return the sql name for the field
Parms
 fld - field object
ew_VirtualTableInCustomView(CustomSQL, TblName) (v9+) Return if virtual table is in the custom view
Parms
 CustomSQL - custom view SQL
 TblName - table name

 

2. System Functions (Overridable)

USAGE: SYSTEMFUNCTIONS.<FunctionName>

Function Name Description
CharSet() Return <meta> tag for charset specified
FavIcon() (v8.0+) Return <link> tags for favicon specified
CssFile() Return <link> tag for css file specified
GetScript(ScriptType, CodeType, ScriptName) Return Server/Client Scripts
Parms
 ScriptType - script type (Server / Client)
 CodeType - code type (Global / Table / Other)
 ScriptName - script name
GetTemplateScript(Type,Name) (v9+) Return source custom template
Parms
 Type - template type (Table / Other)
 Name - template name
GetServerScript(CodeType, ScriptName) Return Server Scripts
GetClientScript(CodeType, ScriptName) Return Client Scripts
ScriptExist(ScriptType, CodeType, ScriptName) Return if Script Exists
Parms
 ScriptType - script type (Server / Client)
 CodeType - code type (Global / Table / Other)
 ScriptName - script name
ServerScriptExist(CodeType, ScriptName) Return if Server Script Exists
ClientScriptExist(CodeType, ScriptName) Return if Client Script Exists
CustomTemplateExist() (v10+) Return if custom template exists
CustomMultiPageTemplateExist() (v10+) Return if multi-page custom template Exists
CustomListOptions() (v10+) Return custom template list option type (block/blocknotd/single)
CustomTemplateSearchExist() (v10+) Return if list page custom search template exists
GetCustomTemplate() (v10+) Return translated custom template
GetCustomTemplatePage(pageid) (v10+) Return translated custom template for page (multi-page layout)
Parms
 pageid - page id (1/2/3/...)
ParseTemplate(template,id) (v10+) Return translated template
Parms
 template - source template
 id - template id
GetCustomTemplateSearch() (v10+) Return translated list page custom search template
RenderCustomTemplate() (v10+) Return rendering codes for custom template
RenderCustomTemplateSearch() (v10+) Return rendering codes for list page custom search template
GetCustomViewTemplate(fld) (v10+) Return custom view template for field
Parms
 fld - field object
ScriptTimeout() Return ASP script timeout codes
IsBoolFld() Return if field is boolean
ASPDirective() Return ASP Directives (CodePage, LCID)
SessionTimeout() Return ASP Session Timeout codes
NoCache() Return ASP No Cache codes
IncludeFile(fn, parm) Return ASP Include file statement
Parms
 fn - file control id
 parm - extra parameter
ConnectionString() Return Database Connection String
Security() Return ASP Security checking codes
ScriptInsert() Return ASP codes for inserting a record
ScriptUpdate() Return ASP codes for updating a record
Script(ctlid) Return ASP codes for inserting/updating a record
Parms
 ctlid - "insert" / "update"
ScriptUpdateFile() Return ASP codes for file upload to folder
ScriptUpdateSpecial() Return ASP codes for updating detail key/parent/user id field
ScriptCommon() Return ASP codes for rendering field (common)
ScriptViewRefer() Return ASP codes for rendering field for VIEW (HREF)
ScriptEditRefer() Return ASP codes for rendering field for EDIT (HREF)
ScriptView() Return ASP codes for rendering field for VIEW
ScriptViewCall(cv, vv) Return ASP codes for rendering field for VIEW
Parms
 cv - Current Value
 vv - View Value
ScriptViewNo(cv, vv) Return ASP codes for rendering field for VIEW (AutoNumber field)
ScriptViewText(cv, vv) Return ASP codes for rendering field for VIEW (TEXT field)
ScriptViewHighlightSearch(cv, vv) Return ASP codes for rendering field for search highlight
ScriptViewFormat(fld,parm) (v10+) Return ASP codes to format field for VIEW
Parms
 fld - field object
 parm - field to be formatted
ScriptViewPassword(cv, vv) Return ASP codes for rendering field for VIEW (PASSWORD field)
ScriptViewRadio(cv, vv) Return ASP codes for rendering field for VIEW (RADIO field)
ScriptViewTable(cv, vv) Return ASP codes for rendering field for VIEW (Link to Table field)
ScriptViewValues(cv, vv) Return ASP codes for rendering field for VIEW (Lookup Value field)
ScriptViewCheckbox(cv, vv) Return ASP codes for rendering field for VIEW (CHECKBOX field)
ScriptViewSelect(cv, vv) Return ASP codes for rendering field for VIEW (SELECT field)
ScriptViewTextarea(cv, vv) Return ASP codes for rendering field for VIEW (TEXTAREA field)
ScriptViewHidden(cv, vv) Return ASP codes for rendering field for VIEW (HIDDEN field)
ScriptViewFile(cv, vv) Return ASP codes for rendering field for VIEW (FILE field)
ScriptViewHref(cv, vv) Return ASP codes for rendering field for VIEW (HREF field)
ScriptAdd() Return ASP codes for rendering field for ADD
ScriptEdit() Return ASP codes for rendering field for EDIT
ScriptEditCall(cv, ev, ctlid) Return ASP codes for rendering field for ADD/EDIT/SEARCH
Parms
 cv - Current Value
 ev - Edit Value
 ctlid - Control ID
ScriptEditFormat(ctl) (v10+) Return ASP codes to format field for EDIT
Parms
 ctl - control
ScriptSearch() Return ASP codes for rendering field for SEARCH (Search Field 1)
ScriptSearch2() Return ASP codes for rendering field for SEARCH (Search Field 2)
ScriptEditDefaultValue() Return ASP codes for rendering field for Default Value
ScriptEditNo(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (AutoNumber field)
ScriptEditText(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (TEXT field)
ScriptEditPassword(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (PASSWORD field)
ScriptEditRadio(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (RADIO field)
ScriptEditTable(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (Link to Table field)
ScriptEditUserID(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (User ID field)
ScriptEditValues(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (Lookup Value field)
ScriptEditCheckbox(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (CHECKBOX field)
ScriptEditSelect(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (SELECT field)
ScriptEditTextarea(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (TEXTAREA field)
ScriptEditHidden(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (HIDDEN field)
ScriptEditFile(cv, ev, ctlid) Return ASP codes for rendering field for EDIT (FILE field)
ScriptAggregate() Return ASP codes for rendering field for Aggregation
FieldList() Return field control for LIST
FieldAggregate() Return field control for AGGREGATE
FieldView() Return field control for VIEW
FieldViewCall(cv, vv) Return field control for VIEW
Parms
 cv - Current Value
 vv - View Value
FieldViewCheckbox(cv, vv) Return field control for VIEW (CHECKBOX field)
FieldViewFile(cv, vv) Return field control for VIEW (FILE field)
FieldViewFileConfirm(cv, vv) Return field control for VIEW (FILE field confirm page)
FieldViewText(cv, vv) Return field control for VIEW (TEXT field)
FieldViewHref(ctl) Return field control for VIEW (HREF field)
Parms
 ctl - Control to be HREF
FieldUpdate() Return field control for UPDATE
FieldEdit() Return field control for EDIT
FieldEditPrimaryKey() Return field control for EDIT (Primary Key field)
FieldEditDetailKey() Return field control for EDIT (Detail Key field)
FieldAdd() Return field control for ADD
FieldSearch() Return field control for SEARCH (Search field 1)
FieldSearch2() Return field control for SEARCH (Search field 2)
FieldEditCall(ctl, cv, ev, ctlid) Return field control for EDIT
Parms
 ctl - Control
 cv - Current Value
 ev - Edit Value
 ctlid - Control ID
FieldEditNo(ctl, cv, ev, ctlid) Return field control for EDIT (AutoNumber field)
FieldEditHidden(ctl, cv, ev, ctlid) Return field control for EDIT (HIDDEN field)
FieldEditRadio(ctl, cv, ev, ctlid) Return field control for EDIT (RADIO field)
FieldEditCheckbox(ctl, cv, ev, ctlid) Return field control for EDIT (CHECKBOX field)
FieldEditPassword(ctl, cv, ev, ctlid) Return field control for EDIT (PASSWORD field)
FieldEditSelect(ctl, cv, ev, ctlid) Return field control for EDIT (SELECT field)
FieldEditDynamicSelect(ctl, cv, ev, ctlid) Return field control for EDIT (Dynamic SELECT field)
FieldEditAjaxSelect(ctl, cv, ev, ctlid) Return field control for EDIT (Ajax SELECT field)
FieldEditAutofill(ctl, cv, ev, ctlid) Return field control for EDIT (Auto Fill field)
FieldEditFile(ctl, cv, ev, ctlid) Return field control for EDIT (FILE field)
FieldEditText(ctl, cv, ev, ctlid) Return field control for EDIT (TEXT field)
FieldEditTextarea(ctl, cv, ev, ctlid) Return field control for EDIT (TEXTAREA field)
FieldOperator() Return field control for Search operator 1
FieldOperator2() Return field control for Search operator 2
FieldOperatorCall(ctl, val, opr) Return field control for Search operator
Parms
 ctl - Control
 val - Search Value
 opr - Operator
FieldSearchCondition() Return field control for Search Condition (BETWEEN or 2nd Opr enabled)
OrderByFieldSources() Return Order By Field sources (comma separated)
JsReqValidator() Return js validator for required field
JsReqErrMsg() Return js error message for required field
JsReqDefaultMsg() Return default js error message for required field
JsValidator() Return js validator
JsFileTypeValidator() Return js validator for file type
JsErrMsg() Return js error message
JsDefaultMsg() Return default js error message
AspReqValidator() Return ASP validator for required field
AspSearchValidator() Return ASP validator for search field
AspValidator() Return ASP validator
AspFileValidator() Return ASP validator for file type
AspValidatorCommon(fld, msg) Return ASP validator
Parms
 fld - field
 msg - message
AspErrMsg() Return ASP error message
IsAggregate() Return if Aggregate is enabled
HasFileField() Return if Has File Field
IsMultiPage() Return if MultiPage is enabled
IsAutofillMasterField(ctlid) Return if field is auto fill master field
Parms
 ctlid - control id
IsFileRelatedField(fldname) Return if field is file related field
Parms
 fldname - field name
LookupSql(bDistinct, arFields, sFilter, sRunTimeFilterVar, bAddUserIDFilter, sSelectLimit) Return codes for lookup SQL
Parms
 bDinstinct - use DISTINCT
 arFields - field array
 sFilter - filter SQL
 sRunTimeFilterVar - run time filter variable
 bAddUserIDFilter - add user id filter
 sSelectLimit - SELECT LIMIT
SelectionList(ctlid) Return selection list in JSON
Parms
 ctlid - control id

 
 ©2001-2012 e.World Technology Ltd. All rights reserved.