I may not explain myself properly as I am a newby to xml & xsl so please
allow for this.
I am using HTTP Post to get a XML-RPC file from a remote server and need to
convert it to a string suitable to import into mssql server.
I have a vbscript that has a function where i have an xml file imported
into a string that i need to apply a xsl file against to transform the
elements, so I can import them into sql server using a sp and passing on a
new string.
My xml file is stored in sText as a string
I need to transform it and put transformed doc into a new string into
sTransText
Using 'ImportStockLis t.xsl' , can I put this xsl file into a string and just
call a function with a returned transformed string or do I need to keep
'ImportStockLis t.xsl' as a file.
I dont know something like sTransText = XMLDOM.Transfor m(sText)
You get my idea, can anyone off some help on this please.
Regards
Don Grover
allow for this.
I am using HTTP Post to get a XML-RPC file from a remote server and need to
convert it to a string suitable to import into mssql server.
I have a vbscript that has a function where i have an xml file imported
into a string that i need to apply a xsl file against to transform the
elements, so I can import them into sql server using a sp and passing on a
new string.
My xml file is stored in sText as a string
I need to transform it and put transformed doc into a new string into
sTransText
Using 'ImportStockLis t.xsl' , can I put this xsl file into a string and just
call a function with a returned transformed string or do I need to keep
'ImportStockLis t.xsl' as a file.
I dont know something like sTransText = XMLDOM.Transfor m(sText)
You get my idea, can anyone off some help on this please.
Regards
Don Grover