Outputting XML

• adrian tether

  Newbie

  Points: 1

  More actions

  October 11, 2005 at 2:58 am

  #166242

   Trying to output XML useing sql query manager, and the output to file isnt true xml it outputs with html as well, is there anyway to get sql to output true xml without the html or is that just not the case ?!?.

   Also when i created a simple tempalte file to use with the query like so. .

   

  <?xml version="1.0" encoding="ISO-8859-1" ?>

   

  <USERS>

   <DETAILS>

    

    

  <user>

  <%begindetail%>  

  <state>

  <%insert_data_here%></state>

  <lname><%insert_data_here%></lname>

  <fname><%insert_data_here%></fname>

  <%enddetail%>

  </user>

  </DETAILS>

  </USERS>

   

  it dosnt seem to output correctly and looks all weird ..

   

  Can any 1 tell me where i am going wrong and what i can do to rectify it please....

• bledu

  SSChampion

  Points: 12335

  More actions

  October 12, 2005 at 4:11 am

  #596745

  select * from tbl for xml auto

  this will return an xml string

  refer to bol for more info

  ---

  Everything you can imagine is real.