Hello everyone,

I'm new to the AREV/OI world, I come from a ColdFusion / ASP background and been learning OI for the past month or so.

ASP has a lot of functionality that I would like to use with OI but if I try to process ASP vbscript/javascript code by doing a call like the following:

http://servername/cgi/oecgi.exe/INET_VALIDATE_AMOUNT

It does not work… for the IIS server to process ASP code the URL call needs to end with .ASP, is there a way to make a shell process that goes around the code so that I can use ASP on every page without having to create an ASP page on the server for each process?

I'm lost here, please help.

thanks

John

John,

This thread may help. However, it links to some discussion on the Works discussion board. You must be a Works subscriber to access these posts.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

The xrev.dll looks like the way to go. It's fast and reliable once you understand how to use it works great. I think it's a much better solution than using CGI.

Here is a sample of our ASP code:

set oInsight=server.CreateObject("RevSoft.Revelation")

Dim ReturnValue

Dim Engine

Dim Queue

Dim Result

Result=oInsight.CreateEngine(Engine, "\\10.102.0.2:777", "SYSTEM", 0, 0)

Engine.CreateQueue Queue, "777", "SYSTEM", "USERNAME", "PASSWORD"

myfilter=WITH CUSTOMER_NO=" & request("customerid") & "' BY DATE"

mytable=INVOICE_AUDIT"

myfields=INVOICE_NO,DATE,DESCRIPTION,EXTENSION,QUANTITY,INVOICE_TOTAL"

Result=Queue.CallFunction(ReturnValue, "SY_S_ASP_ARRAY", myfilter, mytable, myfields)

Engine.CloseEngine()

set oInsight=nothing

Bob,

Thanks for this info, now this xarev.dll, is there documentation for this somewhere? So I know how many options are available to use and what the parameters are… or is the following options all there is to know???

set oInsight=server.CreateObject("RevSoft.Revelation")

Result=oInsight.CreateEngine(Engine, "\\10.102.0.2:777", "SYSTEM", 0, 0)

Engine.CreateQueue Queue, "777", "SYSTEM", "USERNAME", "PASSWORD"

Result=Queue.CallFunction(ReturnValue, "SY_S_ASP_ARRAY", myfilter, mytable, myfields)

Engine.CloseEngine()

set oInsight=nothing

thanks

John

There is documentation I think it's in 4.1 New Features with the update to 4.1 but you need to be a works member to get it.

Bob

Ok,

So this is what I am doing:

I keep getting the following error:

Error Type:

Microsoft VBScript compilation (0x800A0414)

Cannot use parentheses when calling a Sub

/test.asp, line 9, column 53

Engine.CreateQueue(Queue, "", "EXAMPLES", "EXAMPLES", "")

I get the above error on the line I placed ←— This Line…

Any ideas???

John

This is more of an ASP question. You can't use parentheses when calling subs in ASP.

Engine.CreateQueue Queue, "777", "SYSTEM", "USERNAME", "PASSWORD"

View this thread on the forum...