Hi folks. Can anyone recommend a good CPAN module that will take info
about a (my)sql table and some arguments and turn it into an html form
for searching/selecting, and then take the results of that form and turn
it into a SQL statement?
I have done similar things previously with HTML::Template and
Class::DBI, but that is a little too heavyweight for what I would like.
print htmlform($dbh->selectall_hashref("desc mytable"),{ name => {size
=> 20,label => "Name to search for",operator=>'like'}, gender =>
{options => [ qw/male female/ ]} });
...
my $sql = params2sql($apache->...->param);
my $rows = $dbh->selectall_hashref($sql);
Something like that.
- Alex
_______________________________________________
Boston-pm mailing list
[email protected]
http://mail.pm.org/mailman/listinfo/boston-pm
