Xquery retriving information (separate duplicate fields into individual values)

buddy123456

New Member
XML file result from food:food-item($food:fps-photo-atlas)\[code\]<portion><food-description unit="g">Spaghetti </food-description><food-number file-type="jpg">3 </food-number><portion-size><size tag="1">55 </size><size tag="2">108 </size><size tag="3">161 </size><size tag="4">214 </size><size tag="5">266 </size><size tag="6">319 </size><size tag="7">372 </size><size tag="8">425 </size></portion-size><size-increment eight-plus="478">52.86 </size-increment></portion>\[/code\]My XQUERY (XML to HTML section)\[code\]for $x in food:food-item($food:fps-photo-atlas)/portion/portion-sizereturn<i>{data($x/size)}</i>}\[/code\]Current Results from my current XQuery\[code\]<i>55 108 161 214 266 319 372 425</i>\[/code\]Preferred result..\[code\]<i>55</i><i>108</i><i>161</i><i>214</i><i>266</i><i>319</i><i>372</i><i>425</i>\[/code\]thanks!
 
Back
Top