Top Query Functions, MOX Keywords

 

Abs%

Has one parameter, a numeric value.

Read more...

 

AmPm$

Takes one parameter

Read more...

 

AnsiToUtf16$

Has one parameter.

Read more...

 

AnsiToUtf8$

Has one parameter.

Read more...

 

AntiCsrf$

Has no params

Read more...

 

ApplyLang$

Takes one parameter

Read more...

 

ATn%

Takes one parameter

Read more...

 

Bin$

Takes one parameter

Read more...

 

CFApi$

Takes three parameters Method, URL, Body

Read more...

 

CheckPw$

Takes two parameters, User and Password

Read more...

 

Chr$

Takes one parameter

Read more...

 

Compress$

Compress any value/table

Read more...

 

Cos%

Takes one parameter

Read more...

 

CsvStream$

Takes one parameter bNoHeaders and returns the result to an assigned variable

Read more...

 

Ctid$

Has no params

Read more...

 

Cuid$

Has no params

Read more...

 

Currency$

Takes one parameter, a numeric value

Read more...

 

Date$

Takes one parameter, a string containing a date time

Read more...

 

DateAmPm$

Takes one parameter, a string containing a date and time

Read more...

 

DateTime$

Takes one parameter, a string containing a date and time

Read more...

 

Day$

Takes one parameter, a date

Read more...

 

DayOfWeek$

Takes one parameter, a date

Read more...

 

Decrypt$

Takes two parameters, an encrypted value and the decryption key

Read more...

 

Dir$

Takes one parameter, a path-mask

Read more...

 

DnsIp$

Takes one parameter, a domain name

Read more...

 

DnsName$

Takes one parameter, an IPv4 Address

Read more...

 

Encrypt$

Takes two parameters, SourceValue, EncryptionKey

Read more...

 

Exists$

Takes two parameters, DBTableName, DBTableRecordAlias

Read more...

 

Exp%

Takes one parameter, an ExponentValue

 

Exp10%

Has one parameter, any numeric value.

Read more...

 

Exp2%

Takes one parameter, any numeric value.

Read more...

 

Extract$

Takes two parameters, Source, Search

Read more...

 

ExtractAny$

Takes two parameters, Source , Search 

Read more...

 

FieldDef$

Takes one parameter, FieldName

Read more...

 

FileExists$

Takes one parameter, the path where the file is located.

Read more...

 

FileSize$

Takes one parameter, a value in number of bytes.

Read more...

 

FirstAlias$

Takes one parameter, TableName

Read more...

 

FolderExists$

Takes one parameter, the path of the folder

Read more...

 

Format$

Takes two parameters, a source value, and a formatting mask.

Read more...

 

GeoDistance$

Takes five parameters, Lat1, Long1, Lat2, Long2, Options

Read more...

 

Greg$

Takes one parameter, a gregorian number

Read more...

 

Greg%

Takes one parameter, a date of the form yyyy-mm-dd

Read more...

 

Guid$

Takes no parameters

Read more...

 

Hash$

Takes one parameter, a source value

Read more...

 

Hex$

Takes one parameter, a source value

Read more...

 

HtmlToText$

Takes a single parameter, Source

Read more...

 

Http$

Takes 9 parameters, ServerName, Port, bSecure, Mode, Path, ContentType, extraHeader, body, rtnHeaders

Read more...

 

HttpHeader$

Has one parameter

Read more...

 

HttpHeaders$

Has no parameters

Read more...

 

HttpSoap$

Takes 8 parameters, ServerName, Port, bSecure, Path, ExtraHttpHeaders, Envelope, ExtraBody, xml

Read more...

 

 

InStr$

Takes two parameters, Source, Match

Read more...

 

InStr%

Takes two parameters, Source, Match

Read more...

 

InStrAny$

Takes two parameters, Source, Match

Read more...

 

InStrAny%

Takes two parameters, Source, Match

Read more...

 

IsGroupType$

Takes two parameters: Username, GroupTypes

Read more...

 

IsValidAlias$

Takes one parameter, a Source value

 

Read more...

 

IsValidDBField$

Takes one parameter, a Source value

Read more...

 

IsValidTable$

Takes one parameter, a Source value

Read more...

 

Json$

Has two parameters: Source, Name

Read more...

 

JsonDecode$

Has two parameters: Source, Options

Read more...

 

JsonEncode$

Has two parameters: Source, Options

Read more...

 

JsonStream$

Has one parameter, Options

Read more...

 

Keywords$

Has one parameter.

Read more...

 

Lang$

Takes one parameter, Source

Read more...

 

Last$

Takes two parameters, Source , Search 

Read more...

 

LastAlias$

Takes one parameter, TableName

Read more...

 

LastAny$

Takes two parameters, Source, Search 

Read more...

 

LCase$

Takes a single Source parameter

Read more...

 

Left$

Takes two parameters, Source, Value

Read more...

 

Len$

Takes one parameter, a Source value

Read more...

 

Len%

Takes one parameter, a Source value

Read more...

 

LoadFile$

Takes one parameter, PathToFile

Read more...

 

Log%

Takes one parameter, Source value

Read more...

 

Log10%

Takes one parameter, a Source value

Read more...

 

Log2%

Takes one parameter, a Source value

Read more...

 

Login$

Takes three parameters, Login, Password, bRememberMe

Read more...

 

LongDate$

Takes one parameter, a Date value

Read more...

 

Lookup$

Takes one parameter, in the form of: Table|{Alias}|Field

Read more...

 

LTrim$

Takes two parameters, Source, Search

Read more...

 

LTrimAny$

Takes two parameters, Source, Search

Read more...

 

MakeValidAlias$

Takes one parameter, a Source value

Read more...

 

MakeValidDBField$

Takes one parameter, Source value

Read more...

 

MakeValidTable$

Takes one parameter, Source

Read more...

 

 

MCase$

Takes one parameter, Source

Read more...

 

Month$

Takes one parameter, Source

Read more...

 

NbSp$

Takes no parameters

Read more...

 

NulStream$

Takes one parameter, bNoHeader

Read more...

 

Parse$

Takes four parameters, Source, bAny, Search, Item

Read more...

 

ParseCount$

Takes two parameters, Source and Match

Read more...

 

ParseCount%

Takes two parameters, Source and Match

Read more...

 

ParseCountAny$

Takes two parameters, Source and Match

Read more...

 

ParseCountAny%

Takes two parameters, Source and Match

Read more...

 

Path$

Takes one parameter, Index

Read more...

 

Plus8Decode$

Takes one parameter, Source

Read more...

 

Plus8Encode$

Takes one parameter, Source

Read more...

 

PWHash$

Takes three parameters, TableName, Alias, Password

Read more...

 

RawStream$

Takes one parameter, a top query destination variable

Read more...

 

RecoverHtml$

Takes one parameter, EscapedHTMLString, and returns the Unescaped Version of this string

Read more...

 

RecoverHtmlObj$

Takes one parameter, EscapedHTMLString, and returns the Unescaped Version of this string

Read more...

 

RecoverMOX$

Takes one parameter, HtmlEscapedString, and returns the Unescaped Version of this string

Read more...

 

RecoverTmpl$

Takes one parameter, EscapedTemplate, and returns the Unescaped Version of this string

Read more...

 

Remain$

Takes two parameters, Source and Search

Read more...

 

RemainAny$

Takes two parameters, Source and Search

Read more...

 

Remove$

Takes two parameters, Source and Search

Read more...

 

RemoveAny$

Takes two parameters, Source and Search

Read more...

 

Repeat$

Takes two parameters, Source, Count

Read more...

 

Replace$

Takes one existing Source value, and two parameters, Search, NewVal

Read more...

 

ReplaceAny$

Takes one existing Source value, and two parameters of equal length, SearchVals, NewVals

Read more...

 

RetainAny$

Takes two parameters, Source, Search

Read more...

 

Reverse$

Takes one parameter, Source

Read more...

 

Right$

Takes two parameters, Source, Value

Read more...

 

Rnd%

Takes two parameters, Low, High

Read more...

 

RTrim$

Takes two parameters, Source, Search

Read more...

 

RTrimAny$

Takes two parameters, Source, Search

Read more...

 

Session$

Takes one parameter, Name

Read more...

 

SessionIsGroupType$

Takes one parameter, a List of possible group types

Read more...

 

Setup$

Takes one parameter, Name

Read more...

 

Sgn%

Takes one parameter, Value

Read more...

 

Similar$

Takes 2 parameters, pString1, pString2

Read more...

 

Similar%

Takes 2 parameters, pNum1, pNum2

Read more...

 

Sin%

Takes one parameter, Value

Read more...

 

Sqr%

Takes one parameter, Value

Read more...

 

SSColAlpha$

Takes one parameter, Source

Read more...

 

SSColNum$

Takes one parameter, Source

Read more...

 

TabStream$

Takes one parameter, bNoHeaders

Read more...

 

Tally$

Takes two parameters, Source, Match

Read more...

 

Tally%

Takes two parameters, Source, Match

Read more...

 

TallyAny$

Takes two parameters, Source, Match

Read more...

 

TallyAny%

Takes two parameters, Source, Match

Read more...

 

Tan%

Takes one parameter, Value

Read more...

 

Tcp$

Takes three parameters, ServerName, Port, bSecure, Send

Read more...

 

TextToHtml$

Takes one parameter, Source

Read more...

 

Time$

Takes one parameter, Source

Read more...

 

TimeAdd$

Takes two parameters, Source, Value

Read more...

 

TimeDif$

Takes two parameters, Source, Value

Read more...

 

TimeSub$

Takes two parameters, Source, Value

Read more...

 

TimeZone$

Takes two parameters, Source, Value

Read more...

 

Trim$

Takes two parameters, Source, Search

Read more...

 

TrimAny$

Takes two parameters, Source, Match

Read more...

 

Truncate$

Takes two parameters, Source, MinLength

Read more...

 

UCase$

Takes one parameter, Source

Read more...

 

 

UrlDecode$

Takes one parameter, Source

Read more...

 

UrlEncode$

Takes one parameter, Source

Read more...

 

Utf16ToAnsi$

Takes one parameter, Source

Read more...

 

Utf16ToUtf8$

Takes one parameter, Source

Read more...

 

Utf8ToAnsi$

Takes one parameter, Source

Read more...

 

Utf8ToUtf16$

Takes one parameter, Source

Read more...

 

ValidDate$

Takes one parameter, a Source value.

Read more...

 

Verify$

Takes two parameters, Source, AllowedCharacters (case sensitive)

Read more...

 

Verify%

Takes two parameters, Source, AllowedCharacters (case sensitive)

Read more...

 

WebSafe$

Takes one parameter, Source

Read more...

 

Year$

Takes one parameter, Source

Read more...