Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I've been looking over the <a href="http://docs.jquery.com/" rel="noreferrer">jQuery docs</a> and I think we can do this in one line using <a href="http://docs.jquery.com/Selectors" rel="noreferrer">selectors</a>:</p> <pre><code>$("#myForm :input[value!='']").serialize() // does the job! </code></pre> <p>Obviously #myForm gets the element with id "myForm" but what was less obvious to me at first was that the <strong>space character</strong> is needed between #myForm and :input as it is the <a href="http://docs.jquery.com/Selectors/descendant" rel="noreferrer">descendant</a> operator.</p> <p><a href="http://docs.jquery.com/Selectors/input" rel="noreferrer"><strong>:input</strong></a> matches all input, textarea, select and button elements.</p> <p><a href="http://docs.jquery.com/Selectors/attributeNotEqual" rel="noreferrer"><strong>[value!='']</strong></a> is an attribute not equal filter. The weird (and helpful) thing is that <strong>all :input</strong> element types have value attributes even selects and checkboxes etc.</p> <p>Finally to also remove inputs where the value was '.' (as mentioned in the question):</p> <pre><code>$("#myForm :input[value!=''][value!='.']").serialize() </code></pre> <p>In this case juxtaposition, ie <a href="http://docs.jquery.com/Selectors/attributeMultiple" rel="noreferrer">placing two attribute selectors next to each other</a>, implies an AND. <a href="http://docs.jquery.com/Selectors/multiple" rel="noreferrer">Using a comma</a> implies an OR. Sorry if that's obvious to CSS people!</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I use jQuery's form.serialize but exclude empty fields
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTom Viner
    1. USTom Viner
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I use jQuery's form.serialize but exclude empty fields
      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. VTAcceptedByOriginator
    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. CO[value] didn't work for me in jquery 1.7.2 , [value!=''] did
      singulars
      1. PO
      1. USMichiel Cornille
    2. CO@Mvision, that's because there's a small but significant omission in this answer. For normal/pure CSS selectors in jQuery 1.8 and earlier, `[value]` matches any element with the attribute `value` *present*, **including** those with empty values (or no) values. This is due to a bug in earlier jQuery versions that created an inconsistency between certain variations of `input[value]` and `:input[value]`. Take, for example, `<input value="foo"><input value=""><input value><input>`; the bug is illustrated in [this fiddle](http://jsfiddle.net/cxUux/).
      singulars
      1. PO
      1. USNoyo
    3. COthanks @Mvision I've altered the answer.
      singulars
      1. PO
      1. USTom Viner
 

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