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

[Fred Pope]

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: interchange-users-admin@interchange.redhat.com
[mailto:interchange-users-admin@interchange.redhat.com] On Behalf Of
music@labyrinth.net.au
Sent: Sunday, January 27, 2002 3:36 AM
To: interchange-users@interchange.redhat.com
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 interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users