Databases
StackOverflow2013
Postsdbo
POInternet Explorer / jQuery / Javascript issues
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInternet Explorer / jQuery / Javascript issues
    primarykey
    data
    text
    <p>For some odd reason Internet Explorer won't run my queries properly. I designed this web application on Firefox, everything runs smooth over there, the only problem is in Internet Explorer. I have a Perl script which inserts status messages into a table called <code>tbl_messages</code>. Since the Perl script is being handled by an Ajax call, you won't see a thing of that. Now where it goes wrong is after the first message, it does update 'gezien' to 1, but yet it seems to show the same message over and over again.</p> <p>This is the status page</p> <pre><code>include('actions/classes.php'); mysql_select_db('st_beheer'); $dbres = mysql_query("SELECT id, message FROM tbl_messages WHERE uniekid=".$_GET['uniekid']." AND `gezien` = 0 ORDER BY id LIMIT 1") OR DIE (mysql_error()); $message = mysql_fetch_assoc($dbres); mysql_query("UPDATE tbl_messages SET gezien = '1' WHERE id='".$message['id']."'") OR DIE (mysql_error()); echo var_dump($message); </code></pre> <p>And over here the ajax calls</p> <pre><code>&lt;script&gt; $(document).ready(function(){ var post = $('#f_export').serialize(); $.ajax({ type: "POST", url: "export.pl", data: post }); var timer = setInterval(StatusUpdate, 1000); var uniekid = $('#uniekid').val(); function StatusUpdate() { $.ajax({ url: "status.php?uniekid="+uniekid, success: function(data){ $('#progressie').append(data); } }); }; }); &lt;/script&gt; </code></pre> <p>Mozilla (working) vardump:</p> <blockquote> <p>Import proces gestart... array(2) { ["id"]=> string(2) "27" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "28" ["message"]=> string(58) "Database met de naam stuftax_asdasdasdasd is aangemaakt..." } array(2) { ["id"]=> string(2) "29" ["message"]=> string(28) "Rechten worden bijgewerkt..." } array(2) { ["id"]=> string(2) "30" ["message"]=> string(34) "ST20 bron tabel word aangemaakt..." } array(2) { ["id"]=> string(2) "31" ["message"]=> string(46) "Een verbinding maken met de nieuwe database..." } array(2) { ["id"]=> string(2) "32" ["message"]=> string(31) "Import specificatie oproepen..." } bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) array(2) { ["id"]=> string(2) "33" ["message"]=> string(35) "Tabellen aanmaken in de database..." } bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) array(2) { ["id"]=> string(2) "34" ["message"]=> string(40) "Tabellen aanpassen, sleutels aanmaken..." } array(2) { ["id"]=> string(2) "35" ["message"]=> string(35) "Poging doen om bestand te openen..." } array(2) { ["id"]=> string(2) "36" ["message"]=> string(108) "Bestand C:/xampp/htdocs/projecten/Examen/files/delano_test_username_08112011_133230.asc succesvol geopend..." } array(2) { ["id"]=> string(2) "37" ["message"]=> string(23) "Bestand is ingelezen..." } array(2) { ["id"]=> string(2) "38" ["message"]=> string(31) "Regels verwerken in tabellen..." } array(2) { ["id"]=> string(2) "39" ["message"]=> string(28) "Import procedure afgerond..." } </p> </blockquote> <p>And over here the Internet Explorer one </p> <blockquote> <p>Import proces gestart... array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." } array(2) { ["id"]=> string(2) "40" ["message"]=> string(45) "Controleren of de database naam al bestaat..." }</p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKen Redler
    1. USDelano de Rooij
    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. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhich version of IE ?
      singulars
      1. POInternet Explorer / jQuery / Javascript issues
      1. USJohn
    2. COI am testing this in 9
      singulars
      1. POInternet Explorer / jQuery / Javascript issues
      1. USDelano de Rooij
    3. COShouldnt it return empty the second time, since it changes `gezien` to 1, and only selects it if its 0. Also REMEMBER to remove cache from calls, if you send the same parameters, IE will use a cached version - therefore giving you the same result.
      singulars
      1. POInternet Explorer / jQuery / Javascript issues
      1. USMarco Johannesen
 

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