Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Grab column form ID's

May 2, 2010, 2:12 AM

nir

User (396 posts)

May 2, 2010, 2:12 AM

Post #1 of 6

Shortcut

Grab column form ID's

How can I send a list if ID's like 345,4545,343,2,34,456,997 and grab from these ID's a specific column like City and get a list of all the city in this ID's.

May 2, 2010, 5:13 AM

Andy

Veteran / Moderator (18441 posts)

May 2, 2010, 5:13 AM

Post #2 of 6

Shortcut

Re: [nir] Grab column form ID's In reply to

Hi,

Something like this should work:

get_unique_cities_for_links

Code:
sub { 
   my $ids; 
   my $field = "City"; 
   foreach (split /,/, $_[0]) { 
     push @$ids, $_; 
  } 

  my $sth = $DB->table('Links')->select(  ["DISTINCT($field)"],   GT::SQL::Condition->new('ID','IN',$ids) ) || die $GT::SQL::error; 
  my @cities; 
  while (my $city = $sth->fetchrow) { 
      push @cities, { city_val => $city }; 
  } 

  return { city_loop => \@loop } 

}

..and call with:

Code:
<%get_unique_cities_for_links('1234,3234,243,6546,44365,434'')%> 
<%loop city_loop%> 
   <%city_val%><br /> 
<%endif%>

Untested, but should work Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

May 2, 2010, 6:03 AM

nir

User (396 posts)

May 2, 2010, 6:03 AM

Post #3 of 6

Shortcut

Re: [Andy] Grab column form ID's In reply to

Thanks Andy, Smile

There is a small error if in all the ID's there is value in the City column it is working good, but if there are ID's without value in the City columns the list that I get is wrong, it delete some of the City and give a small list.

May 2, 2010, 6:33 AM

Andy

Veteran / Moderator (18441 posts)

May 2, 2010, 6:33 AM

Post #4 of 6

Shortcut

Re: [nir] Grab column form ID's In reply to

Hi,

Are you saying there is a problem when one of the ID's doesn't have a value in the "City" field? If so, try this:

my $sth = $DB->table('Links')->select( ["DISTINCT($field)"], GT::SQL::Condition->new('ID','IN',$ids,"LENGTH($field)",'>','0') ) || die $GT::SQL::error;

Cheers

Andy (mod)
andy@ultranerds.co.uk