使用Geodata Web服务 [英] Consume Geodata web service
问题描述
我正在尝试使用
Access（2000-2003）应用程序从Google或Yahoo的网络服务获取地理数据。我在vb.net中运行正常但是
不知道如何在Access中执行此操作。
我正在寻找来自的任何示例代码在
Access中执行此操作的人，或者从Access使用HTTP POST的任何代码示例，所以我可以看看这是如何完成的。
这些Web服务直接返回XML并且不使用SOAP而不使用
使用公开WSDL。
任何帮助都表示赞赏。
lq
I''m trying to get geodata from Google or Yahoo''s web service using an
Access (2000-2003) application. I have this working fine in vb.net but
have no idea how to do this in Access.
I''m looking for any example code from someone who has done this in
Access, or for any code examples of using HTTP POST from Access so I
can see how this is done.
These web services return straight XML and do not use SOAP and do not
use expose a WSDL.
Any help is appreciated.
lq
推荐答案
Lauren Quantrell写道：
Lauren Quantrell wrote:
发布的代码中有错误：
更正如下：
公共属性获取PostalCode（）为字符串
PostalCode = _
GetNodeText（" // Placemark / AddressDetails / Country / AdministrativeArea /
SubAdministrativeArea // PostalCode / PostalCodeNumber"）
结束物业
There''s an error in the posted code:
Corrected as follows:
Public Property Get PostalCode() As String
PostalCode = _
GetNodeText("//Placemark/AddressDetails/Country/AdministrativeArea/
SubAdministrativeArea//PostalCode/PostalCodeNumber")
End Property
你学习的越多t XPath查询较短的所有路径
可以制作。
The more you learn about XPath queries the shorter all those paths
could be made.
Lauren Quantrell写道：
Lauren Quantrell wrote:
发布的代码中有错误：
更正如下：
公共属性获取PostalCode（）As String
PostalCode = _
GetNodeText（" // Placemark / AddressDetails / Country / AdministrativeArea /
SubAdministrativeArea // PostalCode / PostalCodeNumber"）
结束财产
There''s an error in the posted code:
Corrected as follows:
Public Property Get PostalCode() As String
PostalCode = _
GetNodeText("//Placemark/AddressDetails/Country/AdministrativeArea/
SubAdministrativeArea//PostalCode/PostalCodeNumber")
End Property
如果您实际上将该代码
插入应用程序，则需要知道其他事项。
第一：你不应该。你问了一个例子。这只是一个蹩脚的例子。
第二：如果有更多的
，那么可以返回多个Placement节点。请求。
如果发生这种情况，您将使用该代码获得奇怪的结果。
转到Google的Map Api信息页面并阅读。这就是我所做的。
Something else you need to know if you''re actually plugging that code
into an application.
First: You shouldn''t. You asked for an example. It''s just a lame example.
Second: More than one Placement node can be returned if there is more
than one hit for the address you make a request for.
If that ever happens you will get weird results using that code.
Go to Google''s Map Api information pages and read. That is what I did.
1月5日，11：02 * am，rkc< r ... @ rkcny.yabba.dabba.do.comwrote：
On Jan 5, 11:02*am, rkc <r...@rkcny.yabba.dabba.do.comwrote:
Lauren Quantrell写道：
Lauren Quantrell wrote:
发布的代码中有错误：
更正如下：
There''s an error in the posted code:
Corrected as follows:
Public Property Get PostalCode（）As String
* * PostalCode = _
* * GetNodeText（" // Placemark / AddressDetails / Country / AdministrativeArea /
Public Property Get PostalCode() As String
* * PostalCode = _
* * GetNodeText("//Placemark/AddressDetails/Country/AdministrativeArea/
rkc，
Freaky如何将XML字符串传递给vb.net中的sproc而不是来自
Access。我一定会遗漏一些东西。双倍双引号，三元
双重quates我试过......
lq
rkc,
Freaky how I can pass the XML string to a sproc in vb.net but not from
Access. I must be missing something. Double double quotes, triple
double quates I''ve tried...
lq
SubAdministrativeArea // PostalCode / PostalCodeNumber" ）
结束物业
SubAdministrativeArea//PostalCode/PostalCodeNumber")
End Property
如果你真的将代码
插入一个应用程序，你需要知道的其他事情。
第一：你不应该''吨。你问了一个例子。这只是一个蹩脚的例子。
第二：如果有更多的
，那么可以返回多个Placement节点。请求。
如果发生这种情况，您将使用该代码获得奇怪的结果。
转到Google的Map Api信息页面并阅读。这就是我做的。
Something else you need to know if you''re actually plugging that code
into an application.
First: You shouldn''t. You asked for an example. It''s just a lame example.
Second: More than one Placement node can be returned if there is more
than one hit for the address you make a request for.
If that ever happens you will get weird results using that code.
Go to Google''s Map Api information pages and read. That is what I did.
这篇关于使用Geodata Web服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
