Help for this page

Select Code to Download


  1. or download this
    sub GetNodes {
      my $meta = shift;
      my $sql = buildMetaQuery( scalar keys %$meta );
    ...
      $sth->execute( %$meta );
      $sth->fetchrow_array  
    }
    
  2. or download this
    SELECT md1.node_id
     FROM `meta_data` as md1,`meta_data` as md2,`meta_data` as md3
     WHERE md1.name = ?
    ...
       AND md3.name = ?
       AND md3.value = ?
       AND md1.node_id = md2.node_id = md3.node_id;