Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: Annoying global :(

Gossamer Threads

Home : Products : Gossamer Links : Development, Plugins and Globals :

Annoying global :(

Jan 19, 2004, 4:42 AM

Andy

Veteran / Moderator (18441 posts)

Jan 19, 2004, 4:42 AM

Post #1 of 2

Shortcut

Annoying global :(

Hi. Can anyone see anything wrong with this global? I have the following;

Code:
sub { 

  my $table = $DB->table('Links'); 
  my $sth = $table->select( ['DISTINCT(State)'] ) || return $GT::SQL::error; 

  my $back; 
  while (my $hit = $sth->fetchrow_hashref) { 
     $back .= qq|<option>$hit->{State}</option>|; 
  }  

}

It doesn't return anything, BUT it doesn't give an error :-/

I'm trying to get a list of States from within the database (I think the DISTINCT is working ok).

Any ideas are much appreciated...I've been racking my brain on this one for quite a while :(

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 19, 2004, 7:09 AM

Andy

Veteran / Moderator (18441 posts)

Jan 19, 2004, 7:09 AM

Post #2 of 2

Shortcut

Re: [Andy] Annoying global :( In reply to

Duh... its because I wasn't returning $back Blush

(as well as the DISTINCT part not being correctly written).

The global now looks like this;

Code:
sub { 

  my $table = $DB->table('Links'); 
  my $sth = $table->select( 'DISTINCT(State)' ) || return $GT::SQL::error; 

  my $back; 
  while (my $hit = $sth->fetchrow_hashref) { 
     next if !$hit->{State}; 
     $back .= qq|<option>$hit->{State}</option>|; 
  }  

  return $back; 

}

Cheers

Andy (mod)
andy@ultranerds.co.uk

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676