WebDB - dynamic pages & parameter passing to forms?

From: Benjamin L May <blm14_at_merhaba.cc.columbia.edu>
Date: 22 Aug 2000 15:50:10 GMT
Message-ID: <8nu7fi$2je$2_at_newsmaster.cc.columbia.edu>


        Hi! I'm writing an application in WebDB, and I'm having a problem. We decided not to use the built in webdb "website" wizard. Instead we just have a dynamic page as our main page. This main page has three functional points. One: it has a search function. The search function is designed to search a table called "candidates" by either last name, first name, or status. Unfortunately, any search will always return ALL the rows in candidates. Here is the source code for one of the search buttons:

<form action="RECRUIT_DB.CANDIDATE_LIST.show" method=post>
<tr><td align=left>
<input type=hidden name=p_arg_names value=candidates.last_name>
<input type=text name=p_arg_values>
</td>
<td align=left>
<input type=hidden name=p_arg_names value=_candidates_last_name_cond>
<input type=hidden name=p_arg_values value=">=">
<input type=hidden name=p_arg_names vlaue=_show_header>
<input type=hidden name=p_arg_values value=YES>
<input type=hidden name=p_arg_names value=_max_rows>
<input type=hidden name=p_arg_values value=20>
<input type=hidden name=p_arg_names value=_format_out>
<input type=hidden name=p_arg_values value=HTML>
<input type=hidden name=p_arg_names value=_font_size>
<input type=hidden name=p_arg_values value=%2B0>
<input type=hidden name=p_arg_names value=_orderby_col_1>
<input type=hidden name=p_arg_values value=last_name>
<input type=hidden name=p_arg_names value=_orderby_ord_1>
<input type=hidden name=p_arg_values value=ASC>
<input type=hidden name=p_arg_names value=_orderby_col_2>
<input type=hidden name=p_arg_values value=first_name>
<input type=hidden name=p_arg_names value=_orderby_ord_2>
<input type=hidden name=p_arg_values value=ASC>
<input type=hidden name=p_arg_names value=_orderby_col_3>
<input type=hidden name=p_arg_values vlaue=NULL>
<input type=hidden name=p_arg_names value=_orderby_ord_3>
<input type=hidden name=p_arg_values value=ASC>
<input type=hidden name=p_arg_names vlaue=_orderby_col_4>
<input type=hidden name=p_arg_values value=NULL>
<input type=hidden name=p_arg_names value=_orderby_ord_4>
<input type=hidden name=p_arg_values vlaue=ASC>
<input type=hidden name=p_arg_names vlaue=_orderby_col_5>
<input type=hidden name=p_arg_values vlaue=NULL>
<input type=hidden name=p_arg_names value=_orderby_ord_5>
<input type=hidden name=p_arg_values value=ASC>
<input type=hidden name=p_arg_names vlaue=_orderby_col_6>
<input type=hidden name=p_arg_values vlaue=NULL>
<input type=hidden name=p_arg_names value=_orderby_ord_6>
<input type=hidden name=p_arg_values value=ASC>
<input type=submit value="Search Candidates by Last Name">
</td></tr>
</form>

        That's problem number one. Problem number two, now is that we also would like the following functionality: On the same page as these search options, we would also like to have four fields for inputting a first name, last name email, and phone number. When these fields are filled, and a button clicked, a page should come up that is now called CANDIDATE_ADD and is a query on tables form. The gist is that the four values from the front page be passed to this addition page.

        The problem becomes HOW do we pass these values from a DYNAMIC HTML type of page to a form?

        The third type of functionality we'd like is to have selections of reports based on values of several drop down boxes. Again, this would be easy to do if I could do it with a form, but forms can only be on one table at a time as I understand it. Below is a basic interface to the system that I'm talking about. Any help on how to do this would be greatly appreciated...

[Quoted] [Quoted] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>

        <title>Untitled</title>
</head>

<body background="images/bg_ffff99.gif">
<TABLE border=0 cellspacing=0>

  <TR >         

    <TD background="images/search.gif" height="39" >&nbsp;</TD>

        <TD>&nbsp; </TD>  

        <TD background="images/reports.gif" width=263>&nbsp; </TD>     

        <TD>&nbsp;</TD>    

        <TD background="images/add.gif" >&nbsp; </TD>         

  <TR>
    <TD valign="top" >

	<table border=1 bordercolor="666699"><tr>
          <td width="100%" >  
      <TABLE bgcolor="#9999ff" background="images/bg_666699.gif" >
        
        <TR>
          <TD><FONT face=Arial><INPUT name=""></FONT></TD></TR>
        <TR>
          <TD  align="right"><FONT face=Arial><INPUT align=right type=submit value="last 

name"></FONT></TD></TR>
        <TR>
          <TD></TD></TR>
        <TR>
          <TD><FONT face=Arial><INPUT name="a"></FONT></TD></TR>
        <TR>
          <TD align="right"><FONT face=Arial><INPUT type=submit value="first 

name"></FONT></TD></TR>
        <TR>
          <TD></TD></TR>
        <TR>
          <TD ><FONT face=Arial><INPUT name=""></FONT></TD></TR>
        <TR>
          <TD align="right"><FONT face=Arial><INPUT type=submit 

value=recruiter></FONT></TD></TR></TABLE></td></tr></table></TD>

    <TD></TD>
    <TD align="center">

	 <table border=1 bordercolor="9999ff">
	 <tr><td>
      <TABLE background="images/bg_9999ff.gif" align="center" width="253">
        
        <TR>
          <TD colspan=2><STRONG><FONT 
            face=Arial>Region</FONT></STRONG></TD>
 
          <TD><FONT face=Arial><INPUT name="ad" type=checkbox>Select All</FONT> </TD></TR>
        <TR>
          <TD></TD>
          <TD><FONT face=Arial><INPUT name="" type=checkbox>East</FONT></TD>
          <TD></TD></TR>
        <TR>
          <TD></TD>
          <TD><FONT face=Arial><INPUT name="" type=checkbox>Central</FONT></TD>
          <TD></TD></TR>
        <TR>
          <TD></TD>
          <TD><FONT face=Arial><INPUT name="" type=checkbox>West</FONT></TD>
          <TD></TD></TR>
        <TR>
          <TD></TD>
          <TD> </TD>
          <TD><INPUT type=submit value=Search></TD></TR></TABLE>
		  </td></tr></table>
		  </TD>

    <TD></TD>
    <TD valign="top" >
      <TABLE border=1 bordercolor="ccccff">
        
        <TR>
          <TD>
            <TABLE background="images/bg_ccccff.gif">
              
              <TR>
                <TD><FONT face=Arial>First Name</FONT> </TD>
                <TD><FONT face=Arial><INPUT name=""></FONT></TD></TR>
              <TR>
                <TD></TD>
                <TD></TD></TR>
              <TR>
                <TD><FONT face=Arial>Last Name</FONT> </TD>
                <TD><FONT face=Arial><INPUT name=""></FONT></TD></TR>
              <TR>
                <TD></TD>
                <TD></TD></TR>
              <TR>
                <TD><FONT face=Arial>E-mail</FONT></TD>
                <TD><FONT face=Arial><INPUT name=""></FONT></TD></TR>
              <TR>
                <TD></TD>
                <TD></TD></TR>
              <TR>
                <TD><FONT face=Arial>Phone 
                Number</FONT> </TD>
                <TD><FONT face=Arial><INPUT name=""></FONT></TD></TR>
              <TR>
                <TD> </TD>
                <TD><INPUT type=submit value="Add 

Candidate"></TD></TR></TABLE></TD></TR></TABLE></TD></TR>   <TR>

    <TD ></TD>
    <TD></TD>
    <TD ></TD>
    <TD></TD>
    <TD></TD></TR>

</TABLE>

</body>
</html>

--
"A lot of people just want free music. But there is a philosophy that
justifies that kind of instinct. Copyright is predicated on assumption
that information is property. I would contest that assumption."

	-Ian Clark, Founder of Freenet

 ::::::::::::::::::::::::::::::::::::::::::::::
 /~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\::
::| Ben May  Perm. Email: blm14_at_iname.com    |::  
::| 	     Curr. Email: blm14_at_columbia.edu |:: 
::|	     ICQ: 58421181		     |::
::|   	     phone:718-783-1406		     |::
::|  	     cell: 646-489-3509		     |:: 
 \_________________________________________/::	
  :::::::::::::::::::::::::::::::::::::::::::::	
Received on Tue Aug 22 2000 - 17:50:10 CEST

Original text of this message