UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> HTTP POST    
 
   
highwayrob
post Apr 23 2009, 01:47 PM
Post #1

UtterAccess Enthusiast
Posts: 96
From: North Florida, USA



VB.NET in Visual Studio 2005 has the HTTPWebRequest HTTPWebResponse functions for Post\Get built in to the language. Do these same functions exist in Access 2007?

I am trying to POST a query to a webserver that will return XML data and this is the specified method to 'POST" the data request.

Thanks,

Rob
Go to the top of the page
 
+
 
Start new topic
Replies
schroep
post Apr 24 2009, 06:09 PM
Post #2

UtterAccess VIP
Posts: 5,200
From: Denver, Colorado [USA]



This isn't exactly what you are looking for, but perhaps you can build on it (this is taken from a routine that looks up UPS Time in Transit information):
CODE
    If objXMLDOC.parseError.errorCode = 0 Then ' If no errors:
        Set objNodes = objXMLDOC.documentElement.selectNodes("TransitResponse/ServiceSummary") ' Look for ServiceSummary nodes in response
        If objNodes.length > 0 Then ' If any exist:
            Set objNode = objXMLDOC.documentElement.selectSingleNode("TransitResponse/TransitFrom/AddressArtifactFormat") ' Check returned FROM values
            strFromCity = objNode.selectSingleNode("PoliticalDivision2").Text
            strFromState = objNode.selectSingleNode("PoliticalDivision1").Text
            strFromZip = objNode.selectSingleNode("PostcodePrimaryLow").Text
            Set objNode = objXMLDOC.documentElement.selectSingleNode("TransitResponse/TransitTo/AddressArtifactFormat") ' Check returned TO values
            strToCity = objNode.selectSingleNode("PoliticalDivision2").Text
            strToState = objNode.selectSingleNode("PoliticalDivision1").Text
            strToZIP = objNode.selectSingleNode("PostcodePrimaryLow").Text
            If (strFromCity = pstrFromCity) And (strFromState = pstrFromState) And (strFromZip = pstrFromZip) And (strToCity = pstrToCity) And (strToState = pstrToState) And (strToZIP = pstrToZip) Then ' If returned values match passed-in values (no correction took place with UPS)
                For Each objNode In objNodes ' Cycle through them
                    If objNode.selectSingleNode("Service/Code").Text = "GND" Then ' Look for a Ground entry
                        gfncUPS_TimeInTransit = CLng(objNode.selectSingleNode("EstimatedArrival/BusinessTransitDays").Text) ' Return the Ground days in transit
                        Exit For
                    End If
                Next
            End If
            Set objNode = Nothing
        End If
        Set objNodes = Nothing
    End If
Go to the top of the page
 
+

Posts in this topic
- highwayrob   HTTP POST   Apr 23 2009, 01:47 PM
- - datAdrenaline   Re: HTTP POST   Apr 23 2009, 02:02 PM
- - highwayrob   Re: HTTP POST   Apr 23 2009, 02:05 PM
- - datAdrenaline   Re: HTTP POST   Apr 23 2009, 02:40 PM
- - schroep   Re: HTTP POST   Apr 23 2009, 08:38 PM
- - datAdrenaline   Re: HTTP POST   Apr 24 2009, 07:33 AM
- - schroep   Re: HTTP POST   Apr 24 2009, 06:09 PM
- - datAdrenaline   Re: HTTP POST   Apr 24 2009, 06:24 PM
- - schroep   Re: HTTP POST   Apr 25 2009, 06:03 PM
- - BananaRepublic   Re: HTTP POST   Apr 25 2009, 06:15 PM
- - schroep   Re: HTTP POST   Apr 25 2009, 07:41 PM
- - mishej   Re: HTTP POST   Apr 25 2009, 08:01 PM
- - datAdrenaline   Re: HTTP POST   Apr 27 2009, 10:04 AM
- - BananaRepublic   Re: HTTP POST   Apr 27 2009, 10:11 AM
- - mateo333   Re: HTTP POST   May 1 2009, 10:54 AM


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 20th June 2013 - 03:10 AM