MOTOBIT.COM - ASP upload, IIS utility Dictionary usage

Article | Member of Multi.Dictionary | Changes | Purchase | Download

1. Identities

Library name: ASP/VBS MultiDictionary library 1.1.0
Library code: Multi
Library CLSID: 9BF370AA-3869-4F11-82FB-04017F65BF51
ProgID: Multi.Dictionary
Library file name: mDict.DLL

2. Scripting engines without types (VB Script, JavaScript, JScript, WSH, ASP)

You can create the object using CreateObject function:

Dim Dictionary
Set Dictionary = CreateObject("Multi.Dictionary")
Dictionary.SomeMethod SomeParameters
Dictionary.SomeProperty = SomeValue

You can also use CreateObject method method of Server object (ASP) to put the Dictionary object to page scope or CreateObject method of WScript object in WSH.

You can also put the object to Application or Session scope using <object ...> tag in global.asa

<object runat="server" scope="application" id="Dictionary"
 progid="Multi.Dictionary">
</object>

Please use ActivexObject object in JScript/JavaScript to create Dictionary object:

var Dictionary;
Dictionary = new ActiveXObject("Multi.Dictionary");
Dictionary.SomeMethod(SomeParameters)
Dictionary.SomeProperty = SomeValue
...

3. VBA (VBA 5, VBA 6, Visual Studio, Word, Excel, MS Access, ...)

VBA 5/6: You can reference the library using menu Project -> References -> select 'ASP/VBS MultiDictionary library 1.1.0' in the listbox (or Project -> References -> Browse -> select mDict.DLL file).
MSAccess, Word, Excel: Tools -> Macro -> Visual Basic Editor, then Tools -> References
Then you can write:

Dim Dictionary As New Multi.Dictionary
Dictionary.SomeMethod SomeParameters
Dictionary.SomeProperty = SomeValue
    ...

Dim Dictionary As Multi.Dictionary
...
Set Dictionary = New Multi.Dictionary
Dictionary.SomeMethod SomeParameters
Dictionary.SomeProperty = SomeValue
...

You can use CreateObject function also, of course:

Dim Dictionary As Multi.Dictionary
...
Set Dictionary = CreateObject("Multi.Dictionary")
Dictionary.SomeMethod SomeParameters
Dictionary.SomeProperty = SomeValue
...

4. Visual Studio .NET (ASP.Net, VB.Net, C#, J#)

You can reference the library using menu Project -> Add reference -> COM tab -> select 'ASP/VBS MultiDictionary library 1.1.0' in the listbox -> click Select. Then you can write (C#, J#):

 //create  a new Dictionary object
 Multi.Dictionary Dictionary = new Multi.DictionaryClass(); 
 Dictionary.set_String("Some text value"); 
 





 String SQL; 
 SQL = "Insert Into Table (BinaryColumn) values (0x" + Dictionary.get_HexString() + ")"; ...

or (VBA)

Dim Dictionary As New Multi.Dictionary 
Dictionary.SomeMethod(SomeParameters)
Dictionary.SomeProperty = SomeValue

5. T-SQL, MS SQL stored procedures and functions

DECLARE @Dictionary INT, @OLEResult INT 
EXECUTE @OLEResult = sp_OACreate 'Multi.Dictionary', @Dictionary OUT
IF @OLEResult <> 0 PRINT 'Error create component Dictionary'

--Set a property of Dictionary.
EXECUTE @OLEResult = sp_OASetProperty @Dictionary, 'PropertyName', @SomeSQLValue
IF @OLEResult <> 0 PRINT 'PropertyName set problem'

--Get a value of a property of Dictionary.
EXECUTE @OLEResult = sp_OAGetProperty @Dictionary, 'PropertyName', @SomeSQLValue OUTPUT
IF @OLEResult <> 0 PRINT 'PropertyName get problem'

--Call some method of Dictionary.
EXEC @OLEResult = sp_OAMethod @Dictionary, 'MethodName', 
 @ReturnValue OUTPUT, @parameter1, @parameter2

5. Other programming environments

Please see documentation of your programing environment, work with COM objects (OLE objects, ActiveX objects). Dictionary is a standard COM object, it can work with other environments, such are Delphi or PowerBuilder.

Other Motobit links: IISTracer, real-time IIS monitor ASP file upload - upload files to ASP.
ActiveX/VBSScript registry editor ActiveX NT User account manager Export MDB/DBF from ASP Active LogFile Email export ActiveX/ASP Scripting Dictionary object