Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is something I made another time for just numbers, it will allow all the formatters as well.</p> <h2>jQuery</h2> <pre><code>$('input').keypress(function(e) { var a = []; var k = e.which; for (i = 48; i &lt; 58; i++) a.push(i); if (!(a.indexOf(k)&gt;=0)) e.preventDefault(); });​ </code></pre> <h2>Try it</h2> <p><a href="http://jsfiddle.net/zpg8k/" rel="noreferrer">http://jsfiddle.net/zpg8k/</a></p> <p>As a note, you'll want to filter on submit/server side as well, for sake of pasting/context menu and browsers that don't support the paste event.</p> <h2>Edit to elaborate on multiple methods</h2> <p>I see you're bouncing around the 'accepted' answer, so I'll clear something up. You can really use any of the methods listed here, they all work. What I'd personally do is use mine for live client side filtering, and then on submit and server side use RegEx as suggested by others. However, <strong>no client side by itself will be 100% effective</strong> as there is nothing stopping me from putting <code>document.getElementById('theInput').value = 'Hey, letters.';</code> in the console and bypassing any clientside verification (except for polling, but I could just cancel the <code>setInterval</code> from the console as well). Use whichever client side solution you like, but be sure you implement something on submit and server side as well.</p> <h2>Edit 2 - @Tim Down</h2> <p>Alright, per the comments I had to adjust two things I didn't think of. First, keypress instead of keydown, which has been updated, but the lack of indexOf in IE (seriously Microsoft!?) breaks the example above as well. Here's an alternative </p> <pre><code>$('input').keypress(function(e) { var a = []; var k = e.which; for (i = 48; i &lt; 58; i++) a.push(i); if (!($.inArray(k,a)&gt;=0)) e.preventDefault(); });​ </code></pre> <p>New jsfiddle: <a href="http://jsfiddle.net/umNuB/" rel="noreferrer">http://jsfiddle.net/umNuB/</a></p>
    singulars
    1. This table or related slice is empty.
    1. POBest way to restrict a text field to numbers only?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRobert
    1. USRobert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. COHmm, I'm not sure this will work for me. It still seems to allow letters if you hold down the key. I want to prevent letters entirely, so that a form validation error is the last resort
      singulars
      1. PO
      1. USRobHardgood
    2. COIt's not allowing letters for me. As I said this was something I built before that had letters as well, but I removed that portion, make sure you're looking at the right jsfiddle.
      singulars
      1. PO
      1. USRobert
    3. COIt allows because someone messes around with his jsfiddle. Paste his javascript and you get what you want.
      singulars
      1. PO
      1. USsod
 

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