in reply to Filtering out replies in Everything Engine

If I were you, I'd join the nodetype table on type_nodetype from the node table and filter based on the name of the nodetype you actually want. You could do this in two queries, but I'd do it in one.

Replies are listed 'Best First'.
Re^2: Filtering out replies in Everything Engine
by Plankton (Vicar) on Sep 01, 2004 at 16:23 UTC
    Thanks chromatic,

    Sorry if I am a little slow. Does nodetype mean mysql table? I mean if I had a table called front_page_nodes would that mean I could do ... 
    my $ref = getNodeWhere( {}, "front_page_nodes" );

    [download]
    ... and get all the nodes from the front_page_nodes table?

    How can I use getNodeWhere to execute a join between two tables? Or do I have to use DBI or the $DB Everything Engine var somehow? Or should I use Everything::NodeBase Functions ?

    Plankton: 1% Evil, 99% Hot Gas.
[reply]
[d/l]

In Section Seekers of Perl Wisdom