My deal is that I want to create my own XML response envelope with xmlized (I love this job I can make up words and folks know what I mean) cursor rows inside. So right now I have to do a CursorToXML(), StrTran twice (once to get the big fat declaration out and a second time to change "VFPData" to "Cursor(n)", and take the result text and TextMerge/concatenate it to my final result.
It would be much cleaner to just make a fragment and let me go straight to the textmerging.
I ran away from FOR XML AUTO in SQLXML once I understood what was going on; it became much easier to to FOR XML RAW and then I could format/massage the result from there.
>
>Note that without the XML declaration, it's not well-formed XML. I see what the FOR XML AUTO clause is doing in SQL Server, but still...
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement