$root.$sessions.MYSQL

Parent: $root.$sessions

Properties

Object specific
$bytesreceived The number of bytes received through the session object since logon. Assigning to this property resets the value to zero.
$bytessent The number of bytes sent through the session object since logon. Assigning to this property resets the value to zero.
$clientflags Flags that affect the behavior of the connection
$codepage The code page used to interpret non-Unicode character data, a kUni… constant (see codepage constants)
$commitdelay The delay (in milliseconds) between each commit retry
$commitretries The number of times a commit operation will retry before conceding
$database Name of the session database
$debugfile If assigned, the DAM writes debug information to the specified file
$debuglevel Specifies the level of debug information required
$debugsize The maximum size of debug file generated before truncation occurs. Assigning zero disables truncation.
$encoding The Unicode encoding used by the database (see encoding constants)
kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8
$fetch64bitints If kTrue, 64-bit integers are fetched into 64-bit Integer fields. If kFalse, they are fetched as 32-bit Integers and truncated accordingly
$hostinfo The type of connection in use, including the server host name
$logontimeout Number of seconds before a connection attempt times out
$port The port number for the TCP/IP connection
$protoversion Version of the protocol in use
$quotedidentifier If kTrue, table instances and session methods will generate quoted column & table name identifiers
$socket The socket or named pipe that should be used for the connection
$sslcipher The cipher being used for current SSL connection. (read-only)
$threadid The thread ID of the current connection
$threadsafe kTrue if the client library was compiled as thread-safe
$unicode If kTrue, Unicode data types/mappings are used. If kFalse, DAM reverts to ANSI behavior
$validateutf8 If set to kTrue, received UTF-8 data is checked and assumed to be ANSI data on failure
Standard $allowstransactions $apiversion $autobegintran $blobsize $charmap $commitmode $damname $defaultdate $emptydateisnull $errorcode $errortext $hostname$ident $lobchunksize $lobthreshold $maptable $name $nativeerrorcode $nativeerrorpending $nativeerrortext $password $rollbackmode $sessionobject$sessionobjref $sqldecimalseparator $sqlstripspaces $sqlthousandseparator $state $transactionmode $username $version

Methods

Object specific
$changeuser Changes the user and causes the specified database to become the default (current) database on the connection
$characterset Returns the name of the default character set for the current connection
$connectoption Used to set extra connect options and affect behavior for a connection
$getdatatypemapping Gets a data type mapping table in use by the session
$insertid Returns the ID of an AUTO_INCREMENT column generated by the most recently executed query
$newstatement $newstatement([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session; typically used to return a new statement object to an object variable with no subtype specified
MYSQL statement object
$newstatementref $newstatementref([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session, to be used with an Object reference variable; typically used to return a new statement to an object reference variable
MYSQL statement object
$ping Checks whether the connection to the server is working. If it has gone down, an automatic reconnection is attempted
$query Executes a SQL statement directly on the connection
$queryinfo Information about the most recently executed query
$queryresult Returns the result set generated by the last call to $query()
$serverdebuginfo Instructs the server to write some debug information to the log
$servershutdown Asks the database server to shut down
$serverstatus Returns information about the database server's current status
$setdatatypemapping Sets a new data type mapping table for the session
$sslset Used for establishing secure connections using SSL
Standard $begin $clear $coltext $commit $createnames $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames$updatenames $wherenames