Ignore:
Timestamp:
May 13, 2006, 3:50:29 PM (15 years ago)
Author:
Dominic Hargreaves
Message:

Fix up.

Location:
wiki-toolkit-plugin-categoriser/trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • wiki-toolkit-plugin-categoriser/trunk/MANIFEST

    r261 r265  
    22MANIFEST
    33Makefile.PL
    4 README
    54lib/Wiki/Toolkit/Plugin/Categoriser.pm
    65t/categoriser.t

  • wiki-toolkit-plugin-categoriser/trunk/Makefile.PL

    r261 r265  
    22WriteMakefile( NAME         => "Wiki::Toolkit::Plugin::Categoriser",
    33               VERSION_FROM => "lib/Wiki/Toolkit/Plugin/Categoriser.pm",
    4                PREREQ_PM    => { 'Wiki::Toolkit',
     4               PREREQ_PM    => { 'Wiki::Toolkit' => 0,
    55                                 'Test::More' => 0,
    66                                 'Carp' => 0

  • 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;
Note: See TracChangeset for help on using the changeset viewer.