Hi again,
Another problem:
The following query returns nothing:
select id from xml where url="http://xoap.weather.com/search/search?where=Paris,Idaho,United States" and itemPath="search.loc"
(Though the url contains one result.)
But this query returns results:
select id from xml where url="http://xoap.weather.com/search/search?where=Paris" and itemPath="search.loc"
Please help...
Thanks
Yuval
Hi Yuval,
Try encoding the URL being passed in to the url field of the xml table. i.e the following; Encoded the space w/ a %20.
select id from xml where url="http://xoap.weather.com/search/search?where=Paris,Idaho,United%20States" and itemPath="search.loc"
-- Nagesh