Results 1 to 7 of 7

Thread: HTTP Post

  1. #1
    Join Date
    Nov 2003
    Posts
    17

    Unanswered: HTTP Post

    Hi,

    Is it possible to write a stored procedure which can post an XML file to a server using HTTP?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Well... Based on the way you chose to phrase your question, yes. Keep in mind that the web server (whatever is "cooking" your HTML) needs to explicitly execute the stored procedure, that processs doesn't happen "automagically", so I wouldn't exactly consider it a post, even though technically it does qualify as one.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by dhaliwam
    Hi,

    Is it possible to write a stored procedure which can post an XML file to a server using HTTP?

    Thanks!

    Maybe you can help me out....

    What are you talking about?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    At least the way that I read the question, they want to know if a stored procedure can return a result set as XML. This allows the web page to construct a generic page, then fill it with an XML result set without knowing/caring whether that XML came from SQL Server or another XML source.

    Unfortunately, I felt like I was dancing around knife blades, since I answered the question as it was asked, but I could see a thousand shades of meaning that could have colored my answer.

    -PatP

  5. #5
    Join Date
    Nov 2003
    Posts
    17

    HTTP Post

    Let me try to explain:

    I need to write a stored procedure that can read from an XML file which was created by antoher stored procedure and send this file to a web server over HTTP?

    Thanks!

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I guess you could load it to a table and interogate it...what do you need to "read"

    To move it you caould use xp_cmdsell and use dos commands...

    still kinda in a fog here though....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Couldn't you just use FOR XML ?

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •