Thanks everyone for answers. Found the problem. Note to myself: when you work with oxid3 and oxid4 systems, always check which version database scheme you are analyzing.
Respectfully, Darius Tumas On Thu, Sep 10, 2009 at 10:43 AM, anzido GmbH <[email protected]>wrote: > 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 > _______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
