Hi,When I execute a select statement which contains "FOR XML AUTO" against theADO command object, the return recordset data appears as hex.However, if I run the same query but exclude "FOR XML AUTO", the data isfine and not converted to hex.Is this correct behaviour??Does "FOR XML AUTO" only work if receiving the XML data back via the httpheader (ie. using IIS virtual directory for SQL Server)?? - I tried thisapproach and all worked fine!!Does ADO support the "FOR XML" syntax?I am using ADO v2.6, SQL Server 2000 on Windows 2000 AS.Please help!
"FOR XML" and ADO confusion
- Thread starter wxdqz
- Start date