Hi Darius, the "is null" in your query is wrong. Try with: "where oxparentid = ''
Gruß! Andreas Ziethen Geschäftsführer -- Besuchen Sie unsere PHP- und OXID-Schulungen in der anzido Akademie: http://www.anzido-akademie.de anzido GmbH Kirchhörder Str. 12 44229 Dortmund Tel.: 0231 - 60 71 079 Fax.: 0231 - 60 71 081 Mobil:0176 - 8325 1488 Email: [email protected] Web: http://www.anzido.com USt-ID: DE257982972 Geschäftsführung: Andreas Ziethen Amtsgericht Dortmund HRB 20883 -----Ursprüngliche Nachricht----- Gesendet: 10.09.2009 09:37:02 Von: Darius Tumas <[email protected]> An: <[email protected]> Betreff: [oxid-dev-general] [Creating xml listing] getting articles from category object Vorgang: 2D3GZCX8S6 > Hello, > > I'm writing simple module which will output xml list with all products and > variants in the shop. > > Module is extending start class. > > In first time i wanted to fetch all root products with SQL query. SELECT > oxid FROM oxarticles WHERE oxparentid IS NULL; Interesting thing, that > always i got empty result. It seems that adodb dont want to work with "IS > NULL". > > So then i decided to fetch all information i need by using oxid objects. > > $cats = $this->_oCategoryTree; //as i mentioned with module i'm expanding > start object. > > I can get article IDs in categories subcat with ??->getSubCats(); > > but how to get root category articles? > > Respectfully, > > Darius Tumas > _______________________________________________ > dev-general mailing list > [email protected] > http://dir.gmane.org/gmane.comp.php.oxid.general
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
