Creating correct XML output?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi. I'm running a SELECT query (consisting of UNIONS) with FOR XML AUTO
in a string using EXEC(EXEC(@QUERY)). I want to be able to save the
output to a file with a .xml extension but I'm having difficulty
attaching a parent node to the output.
I cannot get away from running the query as a string since it is built
dynamically. This is driving me crazy so any help would be greatly
appreciated.
*** Sent via Developersdex
http://www.developersdex.com ***
.
Relevant Pages
- Re: Problems with Delete Command
... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
(microsoft.public.access.tablesdbdesign) - Re: Need help with Code Please!!!
... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
(microsoft.public.access.formscoding) - Re: Need help with Code Please!!!
... putting the query SQL itself in here maybe it will help you understand what I ... the actual string that gets built at the end of the SQ1 build process. ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ... Dim qd As QueryDef 'object ref to query item ...
(microsoft.public.access.formscoding) - Re: Need help with Code Please!!!
... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
(microsoft.public.access.formscoding) - Re: Error using " in .open with ADODB.Recordset
... recordset but I'm getting hung up on the SQL statement. ... query that has a string as a condition. ... Dim mrk As String ...
(microsoft.public.data.ado) |
|
