Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A couple of issues there:</p> <ol> <li><p><code>getJSON</code> does an ajax request. Ajax requests are subject to the <a href="http://en.wikipedia.org/wiki/Same_origin_policy" rel="noreferrer">Same Origin Policy</a>. Unless your page is loaded from <code>http://test.com</code> (or a couple of other caveats), it won't work. You're probably looking for <a href="http://en.wikipedia.org/wiki/JSONP#JSONP" rel="noreferrer">JSON-P</a> (which jQuery also supports), provided the server supports it.</p></li> <li><p><code>getJSON</code>, like all ajax requests, is <em>asynchronous</em> by default, so your second alert (with the user list) will happen <em>before</em> the request completes. Although you can make ajax requests synchronous, it's a very bad idea (locks up the UI of most browsers during the request). Instead, just use the user list after you've received it in the callback, rather than trying to use it in the function calling <code>getJSON</code>.</p></li> </ol> <p><strong>Edit</strong>: You've said below that you're trying to use the Twitter search API. That API <strong>does</strong> support JSON-P, so if you use JSON-P to do your request, it should work. e.g.:</p> <pre><code>$(document).ready(function(){ $("#inputForm").submit(function(event){ $(":text").each(function() { var inputText = $(this).val(); var userList = []; var weblink = 'http://search.twitter.com/search.json?q=&amp;ands=google'; // problem is from here. $.ajax({ url: weblink, dataType: "jsonp", // &lt;== JSON-P request success: function(data){ alert(weblink); // this statement doesn't show up $.each(data.result, function(entryIndex, entry){ // &lt;=== Note, `data.results`, not just `data` userList.push(entry['from_user']); // &lt;=== Or `entry.from_user` would also work (although `entry['from_user']` is just fine) }); alert(userList); // &lt;== Note I've moved this (see #2 above) } }); }); }); }); </code></pre> <p>...but surely you don't want to do that for <em>each</em> text field in the form?</p> <p><a href="http://jsbin.com/ihija5" rel="noreferrer">Here's a live example</a> but without a form (and only doing one request, not a request for each field).</p>
    singulars
    1. This table or related slice is empty.
    1. PO$.getJSON not working
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UST.J. Crowder
    1. UST.J. Crowder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO$.getJSON not working
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COActually, the website is [Twitter Search API](http://search.twitter.com/search.json?q=&ands=google).
      singulars
      1. PO
      1. USJimmy Lin
    2. CO@Jimmy: Unless your page is being loaded from search.twitter.com, then, you can't request that data via ajax (because of the SOP). See the link for more. But I bet Twitter offers a JSON-P interface you could use. In fact, a quick search on "twitter json-p interface" suggests that it does. :-)
      singulars
      1. PO
      1. UST.J. Crowder
    3. CO@Jimmy: In fact, that specific API page supports JSON-P, so you just have to change your call (and deal with the second issue). Updated with example.
      singulars
      1. PO
      1. UST.J. Crowder
 

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