Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>For markup, I would suggest HTML 4 or XHTML 1.0/1.1. However, if you want to use XHTML 1.1, you have to deliver it as application/xml, which does not work under Internet Explorer and you can't use some of the most used external tools that inject fragments on your page, like <a href="http://en.wikipedia.org/wiki/AdSense" rel="nofollow noreferrer">AdSense</a> for example. HTML 5 is not fully supported by any browser, and there's no official standard for it yet, so any support might change in future.</p> <p>For scripting, use ECMAScript 3. ECMAScript 4 was abandoned, and ECMA Script 5 is not yet supported by most of the implementations our there.</p> <p>For <a href="http://en.wikipedia.org/wiki/Ajax_%28programming%29" rel="nofollow noreferrer">Ajax</a>, stick with <a href="http://en.wikipedia.org/wiki/XMLHttpRequest" rel="nofollow noreferrer">XMLHttpRequest</a> Level 1. Level 2 is still a working draft and I am not sure which browsers have support for it.</p> <p><strong>Update</strong>: I don't know how you can force Aptana to a particular (X)HTML version through its settings, but if you have access to the raw document, you can add the proper DTD (<code>&lt;!DOCTYPE&gt;</code>) for the markup you want and Aptana should obey by it. THe DTDs for HTML 4.0 and XHTML 1.0 are as follow (pick only one):</p> <pre><code>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"&gt; </code></pre> <p>(I am sure that Aptana also has this as a choice somewhere in the dialogs/menus when you create a new document and it will add the proper DTD based on that choice.)</p> <p>To choose the proper version of ECMAScript, just put your scripts into a non-versioned script tag (<code>&lt;script type="text/javascript"&gt;</code> - see note). This MIME type is associated with JavaScript 1.5/ECMAScript 3.</p> <p>As for the proper XMLHttpRequest, I would suggest (as others did in their answers) using <a href="http://jquery.com/" rel="nofollow noreferrer">jQuery</a> or <a href="http://en.wikipedia.org/wiki/Comparison_of_JavaScript_frameworks" rel="nofollow noreferrer">any other JavaScript framework</a> (<a href="http://en.wikipedia.org/wiki/Dojo_Toolkit" rel="nofollow noreferrer">Dojo</a>, <a href="http://en.wikipedia.org/wiki/Prototype_JavaScript_Framework" rel="nofollow noreferrer">Prototype</a> and so on) to take care of doing the right thing on each browser. Aptana comes with most of these JavaScript frameworks out of the box, so you just have to choose the one you want to use. My personal preference is jQuery.</p> <p><em>Note</em>: according to IANA (<a href="http://www.rfc-editor.org/rfc/rfc4329.txt" rel="nofollow noreferrer">RFC4329</a>) the <code>text/javascript</code> MIME type on the <code>&lt;script&gt;</code> element is obsolete and should be replaced by <code>application/javascript</code> or <code>application/ecmascript</code>. However, the latter are not supported by Internet Explorer.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhich is the new recommended standard of HTML & JavaScript?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPeter Mortensen
    1. USFranci Penov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhich is the new recommended standard of HTML & JavaScript?
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONote that the HTML5 draft flatly and intentionally contradicts RFC4329 and says "text/javascript" *should* be used, on the not unreasonable grounds that that's what everybody uses anyway.
      singulars
      1. PO
      1. USAlohci
    2. CO@Alohci - yes, one of the few reasonable things in HTML5. :-)
      singulars
      1. PO
      1. USFranci Penov
    3. CO“HTML 5 is not fully supported by any browser” Umm, while this is true, neither is HTML4
      singulars
      1. PO
      1. USOli Studholme
 

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