Dynamic SQL Statements in an XML Document

admin

Administrator
Staff member
I generated an XML document in VB:<STREAMDATA><VERSION>1.0</VERSION><SQL>SELECT RTRIM(LastName) + ', ' + RTRIM(FirstName) AS NAME FROM MyTableWHERE datediff(d, GETDATE()-1, EntryDate) < 10</SQL></STREAMDATA>I also created a function accepting a string parameter and inside the function,parse the XML using MSXML.DomDocument, but I got an error, stating that atag started with an invalid character???? Did this come from the '+' orthe '<'? Is there a fix to this? I REALLY want to be able to send the functionan XML data stream.Thanks in advance,Matt
 
Back
Top