Changeset 3512 for branches/2.2/expressoMail1_2/js/local_messages.js
- Timestamp:
- 11/17/10 13:17:16 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.2/expressoMail1_2/js/local_messages.js
r3502 r3512 459 459 460 460 sql = 'select mail.rowid as rowid,mail.header as header,mail.size as size,' + 461 'mail.timestamp as timestamp,mail.unseen as unseen,mail.body as body, ' +461 'mail.timestamp as timestamp,mail.unseen as unseen,mail.body as body, mail.mail as mail, ' + 462 462 'case when lower(mail.ffrom) like ? then ' + 463 463 'case when ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') like \'5:%\' then ' + … … 501 501 var head = rs.field(1); 502 502 var codigoMail = rs.field(0); 503 var mail = rs.field(6); 503 504 504 505 var msg_body = rs.field(5);//recebe o conteudo da coluna "body" do banco de dados; … … 506 507 var rs2 = this.dbGears.execute('select count(*) from anexo where id_mail = '+codigoMail); 507 508 var head_unserialized = connector.unserialize(head); 508 head_unserialized.Size = rs.field(2); 509 var mail_unserialized = connector.unserialize(mail); 510 511 head_unserialized.Size = rs.field(2); 509 512 if(rs.field(4)==1) 510 513 head_unserialized.Unseen = 'U'; … … 516 519 retorno[cont] = head_unserialized; 517 520 retorno[cont]['msg_number'] = codigoMail; 518 521 retorno[cont]['msg_day'] = mail_unserialized.msg_day; 522 retorno[cont]['msg_hour'] = mail_unserialized.msg_hour; 519 523 //declaracao do array() para receber o body de cada mensagem encontrada na busca sql realizada; 520 524
Note: See TracChangeset
for help on using the changeset viewer.