Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Does your non-ajax version also have to be non-jQuery? If not then I also suggest (as @nnnnnn did) that you do away with the onxyz attributes and use jQuery throughout.</p> <p>As other posters have suggested, inline events are inadvisable and should be done away with.</p> <p>If your non-ajax version has to use onxyz then I'd suggest the following:</p> <p>Setup a variable that will store whether this version is to be ajax or not (how you determine this is down to you and your app context):</p> <p>var is_ajax = true;</p> <p>Then if it is an ajax version try this:</p> <pre><code>$(function(){ if(is_ajax){ //Unbind the change event from the village select box $('select[name="village"]').unbind('change'); //As an extra measure, remove the onchange attribute $('select[name="village"]').removeAttr('onchange'); //Re-bind the click event to execute your new ajax functionality $(document).on('change','select[name="village"]',function(){ //Do ajax stuff for on-change event here }); } }); </code></pre> <p>Because it sits in the document.ready function of jQuery this code should fire after the html dom (and it's associated onchange attributes) have been rendered. Therefore I'd imagine it'd effectively strip off the old event and re-bind a new one.</p> <p>Demo:</p> <p><a href="http://jsfiddle.net/foxwisp/hdL5R/" rel="nofollow">http://jsfiddle.net/foxwisp/hdL5R/</a></p> <p>If you can do away with the inline events then I imagine you'd want to do this in your initial javascript file:</p> <pre><code>$(document).on('change','select[name="village"]',function(){ document.submit_village.submit(); }); </code></pre> <p>And then the following in your ajax file to be included later:</p> <pre><code>$('select[name="village"]').removeAttr('onchange'); $(document).on('change','select[name="village"]',function(){ //Do ajax stuff here }); </code></pre> <p>As long as both are in the same scope and timeframe such that they're executed one after the other then the above should work.</p>
    singulars
    1. This table or related slice is empty.
    1. POOverride default javascript functionality with jQuery
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBrad Barrow
    1. USBrad Barrow
    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. COI have done away with the onxyz and replaced it with jQuery as the above shows. The main version works awesome, however the ajax version is only accepting every other option for change.
      singulars
      1. PO
      1. USOpensaurusRex
    2. COWhat version of jQuery are you using? Yours may not have support for the .on() method. If you don't have the latest, perhaps try $('select[name="village"]').live('change',function(){ })
      singulars
      1. PO
      1. USBrad Barrow
    3. COI am using jQuery latest
      singulars
      1. PO
      1. USOpensaurusRex
 

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