This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Lisa Opboositheroopsi 19.Dec.03 08:55 PM a Web browser GeneralAll ReleasesAll Platforms
Here is a copy of the agent that I have been working on. The form that I have sends two values to the agent using webquerysave, "get", querystringdecoded and a saveoptions field.
I've been told I should: Let the document the user saves, continue saving, and THEN change the "Form" field and do a Print statement to redirect to that document.
How do I do this? Do I have to place code in the view as well? And what should it say? Thank you all in advance!
'---Code for sql query after parsing values and making odbc connection---
'retrieve parsed variables from user
torig2 = AgentArgs ("t_orig")
tdest2 = AgentArgs ("t_dest")
'Send query to SQL database
qry.SQL = "SELECT DISTINCT torig, tdest, tldest, tlorig, transoption, tlduration FROM Trans WHERE opt_num ='1' AND torig='" + torig2 + "' AND tdest='" + tdest2 + "'"
result.Execute
If Not result.Execute Then
result.GetErrorMessage
Print "No chance"
End If