July 29, 2005 at 4:14 pm
I have a table which stores xml strings in a text field. I have a stored procedure to which I want to pass the key to the table, have it read the xml from the textfield and then submit it to the sp_xml_preparedocument so that I can select the data from that xml document into a temporary table and work with it.
The xml strings are often longer than 8000 characters.
What is my best way of pasing them to the sp_xml_preparedocument?
August 1, 2005 at 8:00 am
This was removed by the editor as SPAM
August 1, 2005 at 8:39 am
See if this code helps...
August 1, 2005 at 9:51 am
Text data type manipulations are very cumbersome and should be avoided. Can you change it to let the client read the text and pass it back to the sever?
If you still have no choice then give this a try:
http://www.sqlxml.org/faqs.aspx?faq=42
* Noel
August 1, 2005 at 11:53 am
Thanks.. I had hoped for an sql server only solution.. but it all does look extremely cumbersome. It seems such a simple requirement: all it needs is the ability to store longer text into a memory variable.. Is this something that is going to be there in the next SQL Server release?
In the meantime, I'm going to just pull the xml back into the VFP middle tier and manipulate it there..
Thanks,
Ilmar
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply