[ic] How to send input from a form page to a SQL query page???

Fred Pope [email protected]
Sun Jan 27 12:00:01 2002


I think what you need to do is look at the documentation on how to pass
variable between forms. 

You are missing some variables in your form that tell the interchange
server how to pass the form variables. 

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Sunday, January 27, 2002 3:36 AM
To: [email protected]
Subject: [ic] How to send input from a form page to a SQL query page???


I am trying to create a search form that will produce a list from a
large MySQL alternate products table.


In my search page:

PLEASE ENTER SEARCH KEY WORD:

<form action="[area results-sqltest]" method=post>
        <input type=hidden name=mv_session_id value="[data session id]">

                <INPUT NAME=keyword type=text size=8>

<input type="image" alt="Search Go" width="45" border="0"
src="__THEME_IMG_DIR__go.gif">
              </td>
          </tr>
        </table>
      </form>


--How do I get the keyword entered above into my SQL query result page
below?


The results-sqltest.html page:


   [query sql="select * from sqltestdatabase
               where prod_group = 'Toys'
and category = 'Beanie Baby'
and description = ??????????  <----WHAT DO I NEED TO PUT HERE FOR IT TO
WORK?????----
         type=list
       ml=1000]

      [list]
Product: <b>[sql-data sqltestdatabase description]</b> <br><i>Category:
[sql-data sqltestdatabase category]</i>Our Price: $[sql-data
sqltestdatabase price]
      [/list]

   [/query]





_______________________________________________
interchange-users mailing list [email protected]
http://interchange.redhat.com/mailman/listinfo/interchange-users