Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>updated on March 2012.</h2> <p>So, two years after I originally answered this question I come back to see that it has pretty much turned into a big mess. I feel it's about time I come back to it and make my answer truly correct since it is the most upvoted + accepted.</p> <p>For the record, Titi's answer is wrong as it is not what the original poster asked for - it is correct that it is possible to reset a form using the native reset() method, but this question is trying to clear a form off of remembered values that would remain in the form if you reset it this way. This is why a "manual" reset is needed. I assume most people ended up in this question from a Google search and are truly looking for the reset() method, but it does not work for the specific case the OP is talking about.</p> <p>My <strong>original</strong> answer was this:</p> <pre><code>// not correct, use answer below $(':input','#myform') .not(':button, :submit, :reset, :hidden') .val('') .removeAttr('checked') .removeAttr('selected'); </code></pre> <p>Which might work for a lot of cases, including for the OP, but as pointed out in the comments and in other answers, will clear radio/checkbox elements from any value attributes.</p> <p>A more <strong>correct</strong> answer (but not perfect) is:</p> <pre><code>function resetForm($form) { $form.find('input:text, input:password, input:file, select, textarea').val(''); $form.find('input:radio, input:checkbox') .removeAttr('checked').removeAttr('selected'); } // to call, use: resetForm($('#myform')); // by id, recommended resetForm($('form[name=myName]')); // by name </code></pre> <p>Using the <code>:text</code>, <code>:radio</code>, etc. selectors by themselves is considered bad practice by jQuery as they end up evaluating to <code>*:text</code> which makes it take much longer than it should. I do prefer the whitelist approach and wish I had used it in my original answer. Anyhow, by specifying the <code>input</code> part of the selector, plus the cache of the form element, this should make it the best performing answer here.</p> <p>This answer might still have some flaws if people's default for select elements is not an option that has a blank value, but it is certainly as generic as it is going to get and this would need to be handled on a case-by-case basis.</p>
    singulars
    1. This table or related slice is empty.
    1. POResetting a multi-stage form with jQuery
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStfmontague
    1. USPaolo Bergantino
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POResetting a multi-stage form with jQuery
      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. COThat :input is handy... now I know I'll use. Thanks Paolo :) +1
      singulars
      1. PO
      1. USalex
    2. COVery nice, cheers, but will this clear the values of my buttons too? Can't test until later.
      singulars
      1. PO
      1. USda5id
    3. CO@da5id, it may as the docs state it will match 'all input, textarea, select and button elements'. My selectors from my .find() in my answer should remedy this :)
      singulars
      1. PO
      1. USalex
 

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