All,
I am having troubles retrieving XML from SQL Server using
the FOR XML RAW option appended to
an T-SQL Query
statement.
What is the best way to go about getting an XML document
containing data from a database?
-
should I be using
SQL to perform the query with the FOR XML RAW option?
-
or should I
construct the XML object myself using CF's XML functions from a regular
ODBC query?
-
is there a
better way?
I am using SQL Server 2000 and ColdFusion MX Updater 3.
Ben Reid
Web Application
Developer
Advanced ColdFusion Certified
Systematics
Phone: 07 3221 0075
Mobile: 0425 779 999
mailto:[EMAIL PROTECTED]
http://www.systematics.com.au/
Legal Information and technology partnerships since
1978
This email and any attachments are
confidential and may contain copyright material of Systematics.
They are supplied for the information of the addressee only and may not be used
by any other person/s
without the approval of Systematics. If you are not the intended recipient,
please notify us and delete
all copies of this email. Unless otherwise indicated, the views expressed in
this message are those of
the individual transmitting them and not the views of Systematics. While all
care has been taken to
ensure that this email and any attachments do not contain computer viruses,
Systematics does not
represent or warrant that they are free from computer viruses or other defects.
It is the recipient's
responsibility to scan this email and any attachments for viruses. Systematics
accepts no liability
for any loss, damage or consequence resulting directly or indirectly from their
use.
---