Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Global for additional tables

Mar 9, 2004, 2:44 PM

Coyu

User (100 posts)

Mar 9, 2004, 2:44 PM

Post #1 of 8

Shortcut

Global for additional tables

Hi,

when i use this <%Name%> i get directly the value of the Name in Table "Users" where Username is the logged in user!

Which global i need, if i use additional tables and want to ask the value?
e.g.:
Table Users-Profile: Username | Age | Birthday | ...

And i need the value "Age" from the logged in User!

What should i do?

Thanks in advance!

Coyu

Mar 10, 2004, 12:44 AM

pugdog

Veteran / Moderator (6956 posts)

Mar 10, 2004, 12:44 AM

Post #2 of 8

Shortcut

Re: [Coyu] Global for additional tables In reply to

Actually, the variables are available in the $USER hash, which is the Field=>value pair just like the links table.

They *should* be passed into the templates by default. Have you tried using <%Age%> and see if it works?

If you need to use the value in a global, (ie: perl code), it should be available as $USER->{'Age'}

PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Mar 10, 2004, 1:07 AM

Coyu

User (100 posts)

Mar 10, 2004, 1:07 AM

Post #3 of 8

Shortcut

Re: [pugdog] Global for additional tables In reply to

Hi,

i get an error "Unknown Tag" when i am using a field, that is not in Users!

What i need exact for a global, when i wish use the following syntax:

<%global_name('table_name','field_name')%>
e.g.:
<%global_name('Users_Profile','Age')%>

Thanks in advance!

Coyu

Mar 11, 2004, 12:23 AM

el noe

User (434 posts)

Mar 11, 2004, 12:23 AM

Post #4 of 8

Shortcut

Re: [Coyu] Global for additional tables In reply to

Hi,

if you want to use another table as far as I know you have to create a new .def file for your table and then you can create a global like:

Code:

my $results; 
my $sth = $db->select ( { Name => "query" }, ['value']); 
my $list = $sth->fetchall_hashref; 
foreach my $value (@$list) { 
   $results .= "$valu\n"; 
} 
return $results;

Regards

Niko

Mar 11, 2004, 3:03 AM

Andy

Veteran / Moderator (18441 posts)

Mar 11, 2004, 3:03 AM

Post #5 of 8

Shortcut

Re: [el noe] Global for additional tables In reply to

Not sure if that actually answers what Coyu is asking for (I was talking to him via emails). If it is, then you would need to define $db too ;)

Code:
my $db = new GT::SQL '/path/to/defs/';

... or just use $DB, which already holds the LinksSQL GT::SQL object Wink

What I think Coyu is trying to do, is be able to pass ANY kind of query in via a tag... i.e;

Code:
<%GT::SQL::Condition->new('Field','>','5','another_field','LIKE','%foo%')%>

AFAIK, this isn't possible.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Mar 11, 2004, 5:21 AM

el noe

User (434 posts)

Mar 11, 2004, 5:21 AM

Post #6 of 8

Shortcut

Re: [Andy] Global for additional tables In reply to

Hi Andy,

it should be possible to some extent by passing variables to a routine like:

Code:

<%routine($table,$col,$value,$condition)%>

what do you think?

Regards

n || i k o

Last edited by:

el noe: Mar 11, 2004, 5:22 AM

Mar 11, 2004, 6:08 AM

Andy

Veteran / Moderator (18441 posts)

Mar 11, 2004, 6:08 AM

Post #7 of 8

Shortcut

Re: [el noe] Global for additional tables In reply to

Sure its possible... but it would be a huge global Wink

Not something I would have the patience to write :p

Cheers

Andy (mod)
andy@ultranerds.co.uk

Mar 11, 2004, 8:18 AM

el noe

User (434 posts)

Mar 11, 2004, 8:18 AM

Post #8 of 8

Shortcut

Re: [Andy] Global for additional tables In reply to

And I think it makes no sense unless you access a lot of different tables with different qeries. Otherwise it would be easy to use something like the above... only neater Smile

Regards

Niko