kaostika

SQL to XML

Discussion created by kaostika on Sep 4, 2012
Latest reply on Sep 5, 2012 by kaostika

Here is my SQL command

 

 

SELECT id,firstname,lastname

FROM contacts

 

It returns

 

1,Oreste,Schiavone

2,John,Smith

3,Mark,Hunt

 

I want

 

<id>1</id><firstname>Oreste</firstname><Lastname>Schiavone</lastname> etc

 

I read this is possible in SQL, But I have not seen it work in FM

 

Oreste

Outcomes