Using ASP with OI??? (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Using ASP with OI??? (OpenInsight 32-bit Specific) ====
=== At 24 JUN 2003 04:28:35PM John Bello wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 24 JUN 2003 07:48PM Donald Bakke wrote:  ===

<QUOTE>John,



This [url=http://www.revelation.com/WEBSITE/DISCUSS.NSF/f12696d31000b22a8525652b00831bb2/50f51daa12d682cc85256cf40073d586?OpenDocument]thread[/url] 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

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 25 JUN 2003 10:08AM Bob Yerkes wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 25 JUN 2003 12:34PM John Bello wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 25 JUN 2003 01:07PM bobyerkes wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 25 JUN 2003 03:59PM John Bello wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 25 JUN 2003 04:45PM Bob Yerkes wrote:  ===

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



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



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=303E6665A00FFC6885256D4F00707B3B|View this thread on the  forum...]]