Databases
StackOverflow2013
Postsdbo
POjQuery + JSONP + Yahoo Query Language
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjQuery + JSONP + Yahoo Query Language
    primarykey
    data
    text
    <p>I want to get live currency rates from an external source, so I found this great webservice:</p> <p><a href="http://www.webservicex.net/ws/WSDetails.aspx?CATID=2&amp;WSID=10" rel="nofollow noreferrer">Currency Convertor</a></p> <p>This service is working like a charm, the only downside is that it does not provide JSONP results, only XML. Therefore we have a cross browser problem while trying to consume this webservice using jQuery $.ajax().</p> <p>So I found <a href="http://developer.yahoo.com/yql" rel="nofollow noreferrer">Yahoo Query Language</a> which returns results as JSONP and also mangae to consume other webservices and return me the results. This is also working, here is an example URL:</p> <pre><code>http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20xml%20where%20url%3D'http%3A%2F%2Fwww.webservicex.net%2FCurrencyConvertor.asmx%2FConversionRate%3FFromCurrency%3DNOK%26ToCurrency%3DEUR'&amp;format=json&amp;diagnostics=true&amp;callback=cbfunc </code></pre> <p>This URL return JSONP result and is working like a charm, but the problem appears when I use this in my code:</p> <pre><code> $.ajax({ type: "GET", url: urlToWebservice, contentType: "application/json; charset=utf-8", dataType: "jsonp", success: function(data) { $("#status").html("OK: " + data.text); }, error: function(xhr, textStatus, errorThrown) { $("#status").html("Unavailable: " + textStatus); } }); </code></pre> <p>When I try to run this code nothing happens, and I can see this error message in my Firebug javascript debugger:</p> <pre><code>cbfunc is not defined </code></pre> <p>cbfunc is the name of the container which surrounds the JSON response, but why does it say not defined?</p> <p><strong>EDIT:</strong></p> <p>This is my new code, but I still get the <code>cbfunc is not defined</code></p> <pre><code> $.ajax({ url: "http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20xml%20where%20url%3D'http%3A%2F%2Fwww.webservicex.net%2FCurrencyConvertor.asmx%2FConversionRate%3FFromCurrency%3DNOK%26ToCurrency%3DEUR'&amp;format=json&amp;callback=cbfunc", dataType: 'jsonp', jsonp: 'callback', jsonpCallback: 'cbfunc' }); function cbfunc(data) { alert("OK"); } </code></pre> <p>And the "OK" message is never fired...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMartin
    1. USMartin
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjQuery + JSONP + Yahoo Query Language
      1. USmicmcg
      1. VTFavorite
    2. VO
      singulars
      1. POjQuery + JSONP + Yahoo Query Language
      1. USAivan Monceller
      1. VTFavorite
    3. VO
      singulars
      1. POjQuery + JSONP + Yahoo Query Language
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODoh.. stupid me, the `function cbfunc(data)` was inside another function, when I put it outside this function as a separate function it seams to work!
      singulars
      1. POjQuery + JSONP + Yahoo Query Language
      1. USMartin
    2. COWhy explicitly specify callback as `cbfunc` and have a hard dependency on the existence of that function when you can let jQuery handle things, and proceed normally within your `success` callback as you would do for non-JSONP calls?
      singulars
      1. POjQuery + JSONP + Yahoo Query Language
      1. USAnurag
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload