Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

category table tags

Aug 17, 2002, 6:51 PM
xpert
User (277 posts)
Aug 17, 2002, 6:51 PM
Post #1 of 14
Views: 3603
Shortcut
Quote Reply
category table tags
How can i display tags from my category table in the modify template?
Aug 17, 2002, 8:07 PM
katabd
Veteran (1187 posts)
Aug 17, 2002, 8:07 PM
Post #2 of 14
Views: 3534
Shortcut
Quote Reply
Re: [xpert] category table tags In reply to
Hi

The modify form is forthe links only...

What fields are you trying to implant?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Aug 17, 2002, 8:15 PM
xpert
User (277 posts)
Aug 17, 2002, 8:15 PM
Post #3 of 14
Views: 3522
Shortcut
Quote Reply
Re: [katabd] category table tags In reply to
It's a custom column i addd into the cat table!
Aug 17, 2002, 8:34 PM
katabd
Veteran (1187 posts)
Aug 17, 2002, 8:34 PM
Post #4 of 14
Views: 3495
Shortcut
Quote Reply
Re: [xpert] category table tags In reply to
Ok there is Links, category and relation tables...

The add.cgi handles additiont to the links and relation tables so changing or adding a field through the add form to the category links will not work...

Depedning on what you are trying to do...

If it is a custom tag per user you can use the users table... or else you will have to be more specific as to what kind of field it is...
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Aug 17, 2002, 8:36 PM
xpert
User (277 posts)
Aug 17, 2002, 8:36 PM
Post #5 of 14
Views: 3499
Shortcut
Quote Reply
Re: [katabd] category table tags In reply to
Alright let say the custom column is the description column of the Category table!
Aug 17, 2002, 9:40 PM
katabd
Veteran (1187 posts)
Aug 17, 2002, 9:40 PM
Post #6 of 14
Views: 3494
Shortcut
Quote Reply
Re: [xpert] category table tags In reply to
Ok if i understood correctly...

Editing the catgeory variables is not done through the modify template..

there is one of two ways I know of to do that:

1- To assign the user as an editor to the category you want them to edit.

2- To get a plug in similar to the Users plug in i have for the category editing...
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Aug 18, 2002, 12:52 AM
xpert
User (277 posts)
Aug 18, 2002, 12:52 AM
Post #7 of 14
Views: 3509
Shortcut
Quote Reply
Re: [katabd] category table tags In reply to
No I'm not trying the edit the description. I'm tryin to display the description of the the category the link is in on the modify templates!
Aug 18, 2002, 1:55 AM
yogi
Veteran / Moderator (2199 posts)
Aug 18, 2002, 1:55 AM
Post #8 of 14
Views: 3467
Shortcut
Quote Reply
Re: [xpert] category table tags In reply to
Use this global (use as <%get_category_tags%>)
Code:
sub {
my $tags = shift;
return $DB->table('Category')->get($tags->{'CatLinks.CategoryID'});
}

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Last edited by:

yogi: Aug 18, 2002, 1:56 AM
Aug 24, 2002, 4:36 AM
xpert
User (277 posts)
Aug 24, 2002, 4:36 AM
Post #9 of 14
Views: 3475
Shortcut
Quote Reply
Re: [yogi] category table tags In reply to
Hey Yogi,

Thanks for the help, however I can encounter another problem, once i start the get_category_tags global I couldn'y use the Description tag of Links table!
Aug 24, 2002, 11:59 AM
yogi
Veteran / Moderator (2199 posts)
Aug 24, 2002, 11:59 AM
Post #10 of 14
Views: 3438
Shortcut
Quote Reply
Re: [xpert] category table tags In reply to
That's because you have a namespace clash between 'Description' of the category and 'Description' of the link.

You could prefix the fields by something like 'category_'.
Code:
sub {
my $tags = shift;
my $cat = $DB->table('Category')->get($tags->{'CatLinks.CategoryID'});
return { map { 'category_' . $_ => $cat->{$_} } keys %$cat };
}

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Aug 24, 2002, 12:11 PM
Paul
Veteran (19537 posts)
Aug 24, 2002, 12:11 PM
Post #11 of 14
Views: 3491
Shortcut
Quote Reply
Re: [yogi] category table tags In reply to
>>
map { 'category_' . $_ => $cat->{$_} } keys %$cat
<<

Remember that will cause an error (you posted a thread on it a while back).

You need to change the context so you'd use:

map { +"category_$_" => $cat->{$_} } keys %$cat
Aug 24, 2002, 12:39 PM
yogi
Veteran / Moderator (2199 posts)
Aug 24, 2002, 12:39 PM
Post #12 of 14
Views: 3470
Shortcut
Quote Reply
Re: [Paul] category table tags In reply to
Actually, it will not.

map { "category_$_" => $cat->{$_} } keys %$cat

would cause an error, though.

Related question: is there a difference between

map +{ "category_$_" => .....

and

map { +"category_$_" => ....

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Aug 24, 2002, 1:01 PM
Paul
Veteran (19537 posts)
Aug 24, 2002, 1:01 PM
Post #13 of 14
Views: 3439
Shortcut
Quote Reply
Re: [yogi] category table tags In reply to
Yeah my bad I was thinking of the example you showed rather than the one that appends.

Regarding:

map +{ "category_$_" => .....

and

map { +"category_$_" => ....

....the difference is that the first example creates an anonymous hashref whereas the second one doesn't.

For example in a script Im writing at the moment, in order to generate a template loop (arrayref of hashrefs) I use:

Code:
my $array_ref = $something_from_mysql;
my $loop = [ map +{ tag => $_->[0] }, @$array_ref ];

If I left out the + I'd have an arrayref and with the + in the other place I'd get the same

Also note that with +{ you need the comma after the }

Last edited by:

Paul: Aug 24, 2002, 1:04 PM
Aug 24, 2002, 1:10 PM
yogi
Veteran / Moderator (2199 posts)
Aug 24, 2002, 1:10 PM
Post #14 of 14
Views: 3454
Shortcut
Quote Reply
Re: [Paul] category table tags In reply to
Paul, thanks for the explanation. I'll experiment with it.

Ivan
-----
Iyengar Yoga Resources / GT Plugins