List of peer sections

[RogerCoathup]

Is there any (simple) way to generate a list of peer sections in Actinic?

i.e. if I'm a subsection of a parent, can I generate a list of section links to the other children of that parent?

Thanks, Roger

[gabrielcrowe]

Interestingly, i'm just working on this. Here is an ugly solution.

<actinic:block php="true" >
    $connect = odbc_connect("ActinicCatalog8","","");
    $query = "SELECT [nParentSectionID] FROM [Catalog Section] WHERE [nSectionID]=<actinic:variable name="SectionID" /> AND [bHideOnWebSite]=0 ORDER BY [Catalogue Section Sequence] ASC";
    $result = odbc_exec($connect, $query);
        while(odbc_fetch_row($result)){
            $nParentSectionID = odbc_result($result, 1);
        }

    $query2 = "SELECT [sPageName], [Section text], [nSectionID] FROM [Catalog Section] WHERE [nParentSectionID]=".$nParentSectionID." AND [bHideOnWebSite]=0 ORDER BY [Catalogue Section Sequence] ASC";
    $result2 = odbc_exec($connect, $query2);
    @odbc_fetch_row($result2, 0);

        echo "SiblingSections:<ul>";
        while(odbc_fetch_row($result2)){
        
        $sPageName = odbc_result($result2, 1);
            $Sectiontext = odbc_result($result2, 2);
            $nSectionID = odbc_result($result2, 3);
            echo "<li><a href='".$sPageName."'>".$Sectiontext."</a></li>";
        }
        echo "</ul>";
</actinic:block> 

[RogerCoathup]

Thanks Gabriel, but unfortunately that's giving me a list of the parents (sections at a level above my current section).

What I want is a list of all the sections at my level who share the same parent as me.

[gabrielcrowe]

try again.
lol.

i left an extra upstream hop in there

[gabrielcrowe]

who share the same parent as me.

your brothers?

[gabrielcrowe]

hmmm, i'm sure that there is a better way to do this...

[leehack]

Yahoo section tree probably but it pains me to say it.

[RogerCoathup]

Hi ... revised code still just shows the parents (rather than the siblings) and is also throwing SQL errors. Thanks, Roger

[RogerCoathup]

What's the Yahoo section tree?

Thanks, Roger

[gabrielcrowe]

you basically want the other members of the current parent. this is what it gives you.

the errors are a result of a bug in actinic. press the single page preview button on the toolbar and turn the preview off, its crap-tacular.

works for me: http://www.asylumunlimited.co.uk/acatalog/Shoes.html

(white box)

[RogerCoathup]

Hi Gabriel...

Yes, that's working for me now. Thanks, your help is much appreciated.

Best regards, Roger

[gabrielcrowe]

a recent error i found prohibits some php content type shops from snapshotting.

try to take a snapshot to a fresh filename. and let me know what happens.

[RuralWeb]

What's the Yahoo section tree

You dont want to go there

[gabrielcrowe]

becasue this solution causes my system to crash wth some odd error when i exit actinic, exporting your catalog when you attempt it, due to some odd locking semnatics on the database.

dont use this in a production shop. please.

[dallen]

close the odbc connection.
add

odbc_Close($connect);

at the very end before closing the php block.
that should fix it