Changeset 3373


Ignore:
Timestamp:
10/18/10 18:03:01 (13 years ago)
Author:
eduardoalex
Message:

Ticket #1239 - Correcao do erro narrado no ticket em questão

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.2/expressoMail1_2/js/local_messages.js

    r3365 r3373  
    458458    } 
    459459                 
    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 '; 
    461475                 
    462476    if(sort == 'SORTFROM') { 
Note: See TracChangeset for help on using the changeset viewer.