Create xml code from database lists

[tim12]

I have 2 lists in my bubble database: firstname & lastname

for example:

I need these lists to output as xml code like this :

<people>
<person>
<firstname>Pete</firstname>
<lastname>Johnson</lastname>
</person>
<person>
<firstname>Scott</firstname>
<lastname>Smith</lastname>
</person>
<person>
<firstname>Neil</firstname>
<lastname>Williams</lastname>
</person>
</people>

Or next to each other like this:
<people><person><firstname>Pete</firstname> etc. etc.

Note: The number of names is variable. So I can’t use “item #”

Anyone has a clue how to do this?

[tim12]

I tried with “format as text”, and it works with the firstname or lastname only, not both. But maybe I’m missing something.