0

Weather related

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

by
2 Replies
  • QUOTE (Yuval Kesten @ Dec 20 2008, 01:20 PM) <{POST_SNAPBACK}>
    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
    0
  • QUOTE (Nagesh Susarla @ Dec 21 2008, 10:36 AM) <{POST_SNAPBACK}>
    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


    Thanks! I got so used to Firefox doing that for me so I forgot that the console text bar is not the Address bar....
    0

Recent Posts

in YQL