Passing text fields to sp_xml_preparedocument

  • 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?

  • This was removed by the editor as SPAM

  • See if this code helps...

    http://www.msusenet.com/archive/index.php/t-1791190.html


    Two muffins are sitting in an oven. The first one turns to the second and says "pretty hot in here, huh?"
    The second muffin glances at the first and then shrieks in fear,
    "AAAAAAHH!!! A TALKING MUFFIN!!!"

  • 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

  • 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