want to make the select boxes selected in perl

Question

i want to make the select boxes selected based on the values from the database.

code :

my $bug_id = $cgi->param('id');

#query for fetching the datas from the table category_bug_map for updating the select box
my $selectboxcategoryQuery = "SELECT os,cp,service FROM category_bug_map WHERE     bug_id=$bug_id";


my $statusQuery2 = $dbslave -> prepare($selectboxcategoryQuery);
$statusQuery2 -> execute();
my($OS,$CP,$ser) = $statusQuery2 -> fetchrow_array();

$vars->{'select_os'} = $OS;
$vars->{'select_cp'} = $CP;
$vars->{'select_ser'} = $ser;

I want to use the variables in template file to make the select boxes selected(updated).How can i perform this?

It usually helps if you want more than 30 seconds for an answer… — Quentin, May 20 '13 at 13:44
Also, you haven't told us what kind of template you're using. But the process is simple: pass `$vars` to the template, then in the template inspect `$vars` and vary your output based on it. — cjm, May 20 '13 at 14:38
i tried with the following code : [% FOREACH category IN sub_category1 %] [% END %] And got the desired result. — Jenifer_justin, May 20 '13 at 14:46

score 1 · Accepted Answer · answered Jun 05 '13 at 04:21

1

Jenifer try this:-

[% FOREACH category IN sub_category1 %] [% category %] [% END %]

answered Jun 05 '13 at 04:21

Monisha

429
2
6
22

want to make the select boxes selected in perl

1 Answers1