sqlite_bind_field

mIRC SQLite

sqlite_bind_field
Binds a column to a variable.
Syntax
$sqlite_bind_field ( result, column, var ) [ .name ]
/sqlite_bind_field result column var
Parameters
result
The result identifier.
column
The column number of name to bind for. Must exist in the result set.
var
The variable or binary variable to bind the column for.
Properties
name
Forces column to be treated as name.
Return Value
1 on success, or $null if there was an error.
Remarks
The columns bound to variables with $sqlite_bind_field are used when fetching rows with $sqlite_fetch_bound or $sqlite_current_bound.

If column is numeric it is treated as an ordinal index for the column, first column being 1, otherwise it is treated as the column's name. You can use the .name property to force the field to be treated as column name even if it's a number.

The var parameter is considered as a binary variable if it starts with a &. Otherwise it's considered as a regular variable. You should not prefix the var with a %; otherwise mIRC will evaluate the variable right away.

The bound variables are set as global variables when fetched, because mSQLite has no access to local variables. You should be very careful that you don't override any existing global variables.

For more information about parameter binding, see Prepared Statements.

If you want to use the .name property to force the column to act as a column name, you must use the first form of the syntax. If you don't care about the return value, you can use the mIRC's built-in command /noop