Templates (.xml) for URL querying

[vanAtteveldt]

According to the documentation, instead of stating

http://localhost/vroot?sql=SELECT+*+FROM+Table1+FOR+XML+AUTO

it should be possible to use a template such as:

<root><sql:query xmlns:sql=&quot;urn:schemas-microsoft-com: xml-sql&quot;>SELECT * FROM Table1 FOR XML AUTO</sql:query></root>

Storing this as template.xml and then running the template using

http://localhost/vroot/template.xml

causes my browser (IE5) to output the xml rather than pass the query to SQL server.

Any help greatly appreciated,

Wouter van Atteveldt