Iterating through the result of a multiple row sql statement

[kc]

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

[Former Community Member]

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

[kc]

Hi again,



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



Sincerely

Kim