Walter, in the for-each attribute you are missing the rde-id "10", so you say rde-id but there is no reference to which one exactly. The attribute should be something like "rde-id:10:attributeValues.item".
If possible I would use xml/xslt or xpath to access the values. Best, Hilmar Am Mittwoch, 4. Januar 2017 01:34:39 UTC+1 schrieb Walter: > > Hi All, > > I'm trying to do the following with Delivery Server Dynaments: > > > 1. Retrieve data from SQL Server [done] > 2. Loop through the resulting nodes [at-my-wit's-end] > > How do you loop through the nodes with the for-each dynament? Here is > what I have so far: > > > 1. <rde-dm:rdb mode='statement' alias='externalDB' operation= > 'getAttributeValues' rde-id='10' row="item" tag="attributeValues" > cachingtime="60"> > 2. <rde-rd:param type="string">EN</rde-rd:param> > 3. <rde-rd:param type="string">cb_friction</rde-rd:param> > > 4. </rde-dm:rdb> > 5. > 6. <rde-dm:attribute mode="for-each" source="rde-id" attribute= > "attributeValues.item" type="node"> > 7. <p>Test</p> > 8. </rde-dm:attribute> > > > I would expect "Test" to be outputted for as many "item" nodes in the > result... But I must not be accessing it correctly. > > Below is the result of the prepared statement when I test it in Delivery > Server: > > > 1. <debug xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:rdf=" > http://www.w3.org/TR/REC-rdf-syntax/" xmlns:xsl=" > http://www.w3.org/1999/XSL/Transform"> > 2. > 3. > 4. <attributeValues chunk="1" chunksize="1000" description= > "Connector for externalDB" hits="99" lastchunk="1" maxchunk-ca="1" > maxhits="0"> > 5. <item> > 6. <Key>bore</Key> > 7. <Value>0.125 in</Value> > 8. </item> > 9. <item> > 10. <Key>bore</Key> > 11. <Value>0.187 in</Value> > 12. </item> > 13. <item> > 14. <Key>bore</Key> > 15. <Value>0.25 in</Value> > 16. </item> > 17. <item> > 18. <Key>bore</Key> > 19. <Value>0.3125 in</Value> > 20. </item> > 21. <item> > 22. <Key>bore</Key> > 23. <Value>0.375 in</Value> > 24. </item> > 25. </attributeValues> > 26. </debug> > > I would be grateful for any help. Thanks! > > Walter > > > -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to reddot-cms-users+unsubscr...@googlegroups.com. To post to this group, send email to reddot-cms-users@googlegroups.com. Visit this group at https://groups.google.com/group/reddot-cms-users. For more options, visit https://groups.google.com/d/optout.