- Timestamp:
- 10/18/10 18:03:01 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.2/expressoMail1_2/js/local_messages.js
r3365 r3373 458 458 } 459 459 460 sql = 'select mail.rowid as rowid,mail.header as header,mail.size as size,mail.timestamp as timestamp,mail.unseen as unseen,substr(mail.body,1,300) as body,case when lower(mail.ffrom) like ? then ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') else ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') end as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? order by ' 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,' + 462 'case when lower(mail.ffrom) like ? then ' + 463 'case when ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') like \'5:%\' then ' + 464 'substr(ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\'),17) ' + 465 'else ' + 466 'ltrim(ltrim(substr(UPPER(fto),7,length(fto)),\':\'),\'"\') ' + 467 'end ' + 468 'else ' + 469 'case when ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') like \'5:%\' then ' + 470 'substr(ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\'),17) ' + 471 'else ' + 472 'ltrim(ltrim(substr(UPPER(ffrom),21,length(ffrom)),\':\'),\'"\') ' + 473 'end ' + 474 'end as order_from,mail.subject from mail inner join folder on mail.id_folder=folder.rowid where mail.uid_usuario=? and folder.folder=? order by '; 461 475 462 476 if(sort == 'SORTFROM') {
Note: See TracChangeset
for help on using the changeset viewer.