Hi

i am trying to make a global that will return a list of the categories and their IDs in a select field







sub {
my $tags = shift;
my $cat_db = $DB->table('Category');
$cat_db->select_options("ORDER BY Full_Name");
my @root_cats = $cat_db->select (['Full_Name'], ['ID'])->fetchall_list;
my $output;
foreach my $cat (@cats) {
my $ID = $cat_db->as_id($cat);
$output .= qq~<option value="$ID">$cat~;
}
return $output;
}

The above global returns errors and suggestions to fix it..
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Try:

Hi Paul

I am getting:

Can't call method "fetchrow_hashref" on unblessed reference at (eval 10) line 9.


Any suggestions?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Hi,

>
$sth = $db->select( ['ID','Full_Name'] )->fetchrow_hashref;
>

Try this may work

$sth = $db->select( ['ID','Full_Name'] );

Cheers,

Dat

Programming and creating plugins and templates
Blog

Whoops my bad. I forgot to chop off fetchrow_hashref.

Hi

Thank you both..

the change does not fix the problem (actually does0 but still the ID is not being generated..

i change the layout so I do not need the ID anymore..

Thanks again for trying
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Does it build the list?

How is the ID being generated?...Im not sure what you mean.

Hi

I am trying to build a category list the same way add.cgi generates the category list when category is on..

But I want that category list to be through globals.

It will return each category (full name and ID).
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Take a look at Links::User::Add and scroll to the bottom. The category_list routine for add.cgi is there. You may be able to get some hints.

Thanks paul
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory