Changeset 4857 for branches

Timestamp:

07/25/11 16:10:47 (13 years ago)

Author:

diogenesduarte

Message:

Ticket #2100 - utilizando prepared statement para inserir e-mail local.

File:

• branches/2.2/expressoMail1_2/js/local_messages.js (modified) (1 diff)

branches/2.2/expressoMail1_2/js/local_messages.js

@@ -711 +711 @@
             Element("check_box_message_" + msgs_to_set[i]).checked = false;
         
-        for (var n in mail.thumbs) { 
-                /*
-                 * Os thumbs contêm aspas simples que impactam na sql. 
-                 * Aqui eu substituo as aspas simples por duas simples(escape no sqlite),
-                 * Caso já venham duas juntas, elas continuam sem serem duplicadas.
-                 */
-                if(mail.thumbs[n])
-                        mail.thumbs[n] = mail.thumbs[n].replace(/([^'])'([^'])('?)/g,"$1''$2$3$3");
-        }
-        this.dbGears.execute("update mail set mail='"+connector.serialize(mail)+"',header='"+connector.serialize(header)+
-                                                                "',unseen="+unseen+" where rowid="+msgs_to_set[i]);
+
+        this.dbGears.execute("update mail set mail=?,header=?,unseen=? where rowid=?",[connector.serialize(mail),connector.serialize(header),unseen,msgs_to_set[i]]);
 
     }