I have a form on the web composed of a single edit line and button.

The FORMS "submit" quick event "executes a procedure" with the message

"SYSPROG*STPROCEXE**INET_GET_M204_DATA" and no parameters.

The Published HTML for the form is below. I want the info in the

edit line "E_SCHOOL_NO" to be passed to the OI SP. As it is the

info passed to the SP is a large amount of info including the

form type, SAMBAR server info… etc…etc…. What do I need to

do so that when I press the "READ_BUTTON" button only the text from

the edit line "E_SCHOOL_NO" is passed to the OI SP.

Thanks…

Steve C.

ST_ODBCW "ST_SCHOOL_ODBC_WEB"

School No.: 

Steve:

In your INET_GET_M204_DATA program, I presume that it is a function and has at least 1 parameter, called request.

In the FORM tag, you need to set the action to call your Inet function. The syntax you describe presumes that the HTML document is in the same subdirectory as OICGI- and this is probably not true. Try changing the action to where OICGI.EXE lives on your web server- e.g. http:\\127.0.0.1\cgi-bin\oicgi.exe

In your program, declare function Inet_QueryParam. To get the value of that the user has entered into the E_SCHOOL_NO 'field', use the syntax:

School_No=Inet_QueryParam(Request, 'E_SCHOOL_NO')

Inet_QueryParam can be used to Get or Set an item in a HTTP request.

Hope it helps-

Mike Ruane

Steve,

What's the problem really?

Your Inet SP gets a Request - an array with all kinds of stuff - including form type, SAMBAR server info, etc. Didn't know you could avoid that.

One of the elements of Request is special. It contains the "query parameters", i.e a string containing the names of the fields of your form, and the values of those fields. The syntax is

name1=value1&name2=value2&… etc.

If your Inet SP knows the names of the field of the form (which is usually the case for an Inet SP) it can pick out the values with

Value=Inet_QueryParam( Request, Name )

Your form has only one field, but you can still use Inet_QueryParam:

Value=Inet_QueryParam( Request, "E_SCHOOL_NO" ).

- Oystein -

Thanks to both of ya'll.

Inet_QueryParam is just what I needed.

I'm struggling with both Web access and ODBC access to a mainframe

all at the same time.

Mike… your example "Inet_Get_SQL_Data"code for the ODBC really helped also.

I'm glad there's so many programmers/consultants/users out

there in the REV/OI community that are so willing take there time

to help those of us a little less fortunate in knowledge or the

funds to gain that knowledge.

Thanks again

Steve Carlson

Don't want to leave out Don Bakke on his help too.

Thanks Guys.

Steve C.

View this thread on the forum...