[ic] Problem with passing stacked variable

Swe Than swe@endpoint.com
Wed, 20 Dec 2000 15:38:32 -0500


We are using Interchange Search to produce a selection_result page
which uses combined YMD pulldown list values in the search condition.
The search works. It uses the "stacked variable feature, which is
very useful here. The code for the search is:

<form action="[process-search]" method="post">

<input type=hidden name=mv_coordinate value=1>
<INPUT TYPE="hidden" NAME="mv_search_file" VALUE="emp">

<INPUT TYPE=hidden NAME="mv_search_map" VALUE="
        mv_searchspec=search1
        mv_searchspec=search2
        mv_searchspec=search3
        mv_searchspec=search4
        ">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="company_code">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="XYZ">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="anniv_date">
<INPUT TYPE="hidden" NAME="mv_search_field" VALUE="anniv_date">
<INPUT TYPE=hidden NAME="mv_column_op" VALUE="eq">
<INPUT TYPE=hidden NAME="mv_column_op" VALUE="ne">
<INPUT TYPE=hidden NAME="mv_column_op" VALUE="ge">
<INPUT TYPE=hidden NAME="mv_column_op" VALUE="le">
<INPUT TYPE="hidden" NAME="search2" VALUE="XXXX">
<INPUT TYPE=hidden NAME="mv_searchtype" VALUE="sql">
<INPUT TYPE=hidden NAME=ml VALUE=100>
<INPUT TYPE=hidden NAME=sp VALUE=selections_result>

...
This is how search3 is specified and search4 is similar to this
(both consist of year, month, day pulldown menus):

<SELECT name="search3">
                <OPTION VALUE="2000-"> 2000
                <OPTION VALUE="2001-"> 2001
                     ...
        </SELECT>
        <SELECT name="search3">
                <OPTION VALUE="01-"> January
                <OPTION VALUE="02-"> February
                      ...
        </SELECT>
        <SELECT name="search3">
                <OPTION VALUE="01"> 1
                      ...
        </SELECT>

On the selection_result.html page we put a download button (a form
with hidden variables calling a non-Interchange CGI program) which
uses the search3 and search4 values to produce a tab-delimited
download file. sd and ed are search3 and search4 respectively.

The relevant code on the selection_results.html page is:

<form action="/cgi-bin/textreport.cgi" method="post">
<input type="hidden" name="cc" value="[value search1]">
<input type="hidden" name="sd" value="[value search3]">
<input type="hidden" name="ed" value="[value search4]">
<input type="hidden" name="s" value="[value mv_sort_field]">
<input type="submit" value="Download">

MSIE produces the following code and the download is ok,
even though an extra space is introduced in the sd and ed
values as below, since our CGI program can handle this:

<form action="/cgi-bin/textreport.cgi" method="post">
<input type="hidden" name="cc" value="ABCD">
<input type="hidden" name="sd" value="2000- 01- 01">
<input type="hidden" name="ed" value="2000- 03- 02">
<input type="hidden" name="s" value="last_name,first_name">
<input type="submit" value="Download">
</form>

With Netscape, sd and ed were chopped off as below:

<form action="/cgi-bin/textreport.cgi" method="post">
<input type="hidden" name="cc" value="ABCD">
<input type="hidden" name="sd" value="2000-">
<input type="hidden" name="ed" value="2000-">
<input type="hidden" name="s" value="last_name,first_name">
<input type="submit" value="Download">
</form>

Has anyone experienced this? It looks like a delimiter is separating
the stacked variable components and that IE pass the delimiter as
a space while Netscape just says "fuggedaboutit."

My question is how to get the correct values passed for Netscape or
how to do the YMD values for the search so that these values will be
correctly passed to the download code. We've tried various things but
without success. Help will be greatly appreciated!

We are using Interchange 4.6, MySQL, and Apache on Linux.

Thank you,
Swe