List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:March 26 1999 12:42pm
Subject:Re: Mysql/Perl Question?
View as plain text  
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
Thread
Mysql/Perl Question?Douglas Brantz26 Mar
  • Re: Mysql/Perl Question?Sasha Pachev26 Mar
Re: Mysql/Perl Question?Douglas Brantz26 Mar
  • Re: Mysql/Perl Question?Micheal Mc Evoy26 Mar
Re: Mysql/Perl Question?Alexander Keremidarski28 Mar