My Assistant
|
|
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 |
|
|
|
![]() |
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 |
|
|
|
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
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![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 03:10 AM |