Lotus Script agents and web forms

HCL Domino Domino Forum
1

I am accessing a SQL db via ODBC using a Lotus Script agent. I want to present the records through a browser. I can open the agent in the broswer (using ?OpenAgent) and get what I need but I want to be able to create my web forms then use computed text to call the agent from my page using:

@Command([RunAgent]; “TestAgent”)

However, the agent will not present the info.

Any ideas?

Thanks

2

Subject: Lotus Script agents and web forms

You will need a placeholder for the data on your form. Create fields on the web form, then use documentcontext to access thos placeholders and assign the values from the output of your agent. Call the agent from the WebQueryOpen form event or call it from a button (@Command([ToolsRunMacro]; “”))

Get a sessiondoc handle:

Dim session As New NotesSession

Dim db As NotesDatabase

Dim sesdoc As NotesDocument

Dim item As NotesItem

Set db = session.CurrentDatabase

Set sesdoc = session.DocumentContext

getvalue=sesdoc.GetItemValue( “webfield” )

Set item =doc.ReplaceItemValue_

“webfield”, “Hello”) 'this could also be the output of your agent

Hope this helps