MOTOBIT.COM - ASP upload, IIS utility CompareMethod usage

Article | Member of Multi.CompareMethod | 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.CompareMethod
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 CompareMethod
Set CompareMethod = CreateObject("Multi.CompareMethod")
CompareMethod.SomeMethod SomeParameters
CompareMethod.SomeProperty = SomeValue

You can also use CreateObject method method of Server object (ASP) to put the CompareMethod 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="CompareMethod"
 progid="Multi.CompareMethod">
</object>

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

var CompareMethod;
CompareMethod = new ActiveXObject("Multi.CompareMethod");
CompareMethod.SomeMethod(SomeParameters)
CompareMethod.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 CompareMethod As New Multi.CompareMethod
CompareMethod.SomeMethod SomeParameters
CompareMethod.SomeProperty = SomeValue
    ...

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

You can use CreateObject function also, of course:

Dim CompareMethod As Multi.CompareMethod
...
Set CompareMethod = CreateObject("Multi.CompareMethod")
CompareMethod.SomeMethod SomeParameters
CompareMethod.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 CompareMethod object
 Multi.CompareMethod CompareMethod = new Multi.CompareMethodClass(); 
 CompareMethod.set_String("Some text value"); 
 





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

or (VBA)

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

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

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

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

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

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

5. Other programming environments

Please see documentation of your programing environment, work with COM objects (OLE objects, ActiveX objects). CompareMethod 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