Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Iterating through the result of a multiple row sql statement

Avatar

Level 8
Level 8
Hi all,



I would like to access the results of a multiple row sql-statement. However I can't find out how to do this, can you help me here?



I have tried using the "node-set" functions in xpath, but I can't seem to get it right.



How should I approach this scenario?



Sincerely

Kim
2 Replies

Avatar

Level 10
The jdbc service has the option of returning xml back to you ...if you do it this way then you can interogate the xml

Avatar

Level 8
Level 8
Hi again,



I figured this one out, thanks for your input Paul.



Sincerely

Kim