Douglas Brantz wrote:
>
> This is probably not possible, but I would like to create a web form
> that would give a person the ability to choose whatever field they want
> with five drop down menus.
> and then get the results from the database, something like the ODBC
> query.
>
> example-Name="FIRST" the choices could be fields from the table such as
> <OPTION VALUE="dept">Department
> </SELECT>
>
This is not a difficult thing to do actually. Just write some logic that
will construct the query string from the user input. Something like
this:
cgiparse();
@fields = ();
push(@fiels, $env{field_1) if(env{field_1));
push(@fiels, $env{field_2) if(env{field_2));
...
$query = "select ".join(',',@fields)." from the_table";
--
Sasha Pachev
http://www.sashanet.com
