Show
Ignore:
Timestamp:
05/13/06 15:50:29 (6 years ago)
Author:
dom
Message:

Fix up.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • wiki-toolkit-plugin-categoriser/trunk/lib/Wiki/Toolkit/Plugin/Categoriser.pm

    r262 r265  
    125125    my ($self, %args) = @_; 
    126126    my $dbh = $self->datastore->dbh; 
    127     my $sth = $dbh->prepare( " 
    128 SELECT metadata.metadata_value FROM metadata, node WHERE node.name = ? AND metadata.node = node.name AND metadata.version = node.version AND metadata.metadata_type = 'category' 
    129     " ); 
     127    my $sth = $dbh->prepare( "SELECT metadata_value FROM node INNER JOIN metadata ON (node_id = id) WHERE name = ? AND metadata_type = 'category'" ); 
    130128    $sth->execute( $args{node} ); 
    131129    my @categories;