mozIStorageBindingParams

The mozIStorageBindingParams interface is used to bind values to parameters prior to calling mozIStorageStatement.executeAsync().

Please add a summary to this article.
  Last changed in Gecko 1.9.2 (Firefox 3.6 / Thunderbird 3.1 / Fennec 1.0)

Inherits from: nsISupports

You can only create mozIStorageBindingParams objects by calling the mozIStorageBindingParamsArray.newBindingParams().

Method overview

void bindByIndex(in unsigned long aIndex, in nsIVariant aValue);
void bindBlobByIndex(in unsigned long aIndex, [array, const, size_is(aValueSize)] in octet aValue, in unsigned long aValueSize);
void bindDoubleByIndex(in unsigned long aIndex, in double aValue); Native code only!
void bindInt32ByIndex(in unsigned long aIndex, in long aValue); Native code only!
void bindInt64ByIndex(in unsigned long aIndex, in long long aValue); Native code only!
void bindNullByIndex(in unsigned long aIndex); Native code only!
void bindStringByIndex(in unsigned long aIndex, in AString aValue); Native code only!
void bindUTF8StringByIndex(in unsigned long aIndex, in AUTF8String aValue); Native code only!
void bindByName(in AUTF8String aName, in nsIVariant aValue);
void bindBlobByName(in AUTF8String aName, [array, const, size_is(aValueSize)] in octet aValue, in unsigned long aValueSize);
void bindDoubleByName(in AUTF8String aName, in double aValue); Native code only!
void bindInt32ByName(in AUTF8String aName, in long aValue); Native code only!
void bindInt64ByName(in AUTF8String aName, in long long aValue); Native code only!
void bindNullByName(in AUTF8String aName); Native code only!
void bindStringByName(in AUTF8String aName, in AString aValue); Native code only!
void bindUTF8StringByName(in AUTF8String aName, in AUTF8String aValue); Native code only!

Methods

bindByIndex()

Binds a to the specified index.

void bindByIndex(
  in unsigned long aIndex,
  in nsIVariant aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

bindBlobByIndex()

Binds a to the specified index.

void bindBlobByIndex(
  in unsigned long aIndex,
  [array, const, size_is(aValueSize)] in octet aValue,
  in unsigned long aValueSize
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

aValueSize
The size of aValue.

Native code only!

bindDoubleByIndex

Binds a to the specified index.

void bindDoubleByIndex(
  in unsigned long aIndex,
  in double aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

Native code only!

bindInt32ByIndex

Binds a to the specified index.

void bindInt32ByIndex(
  in unsigned long aIndex,
  in long aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

Native code only!

bindInt64ByIndex

Binds a to the specified index.

void bindInt32ByIndex(
  in unsigned long aIndex,
  in long long aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

Native code only!

bindNullByIndex

Binds a to the specified index.

void bindNullByIndex(
  in unsigned long aIndex
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

Native code only!

bindStringByIndex

Binds a to the specified index.

void bindStringByIndex(
  in unsigned long aIndex,
  in AString aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

Native code only!

bindUTF8StringByIndex

Binds a to the specified index.

void bindStringByIndex(
  in unsigned long aIndex,
  in AUTF8String aValue
);
Parameters
aIndex

The zero-based numerical index for the parameter to be bound.  This will be one less than the number used in the SQL (?1 maps to 0, and so on).

aValue

to be bound to the specified index.

bindByName()

Binds a value to a parameter with the specified name.

void bindByName(
  in AUTF8String aName,
  in nsIVariant aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

bindBlobByName()

Binds a to the specified index.

void bindBlobByName(
  in AUTF8String aName,
  [array, const, size_is(aValueSize)] in octet aValue,
  in unsigned long aValueSize
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

aValueSize
The size of aValue.

Native code only!

bindDoubleByName

Binds a to the specified index.

void bindDoubleByName(
  in AUTF8String aName,
  in double aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

Native code only!

bindInt32ByName

Binds a to the specified index.

void bindInt32ByName(
  in AUTF8String aName,
  in long aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

Native code only!

bindInt64ByName

Binds a to the specified index.

void bindInt32ByName(
  in AUTF8String aName,
  in long long aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

Native code only!

bindNullByName

Binds a to the specified index.

void bindNullByName(
  in AUTF8String aName
);
Parameters
aName

The name of the named index for the parameter to be bound.

Native code only!

bindStringByName

Binds a to the specified index.

void bindStringByName(
  in AUTF8String aName,
  in AString aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

Native code only!

bindUTF8StringByName

Binds a to the specified index.

void bindStringByName(
  in AUTF8String aName,
  in AUTF8String aValue
);
Parameters
aName

The name of the named index for the parameter to be bound.

aValue

to be bound to the specified index.

See also

Document Tags and Contributors

Last updated by: sdwilsh,