Thanks Martin, As soon as I find some time, I will update sqlbox with this patch. I think I need to add an UPGRADE.TXT document that indicates that the tables need to be adjused if using a previous version.
Also: Probably we need to update the other (Postgres?) sql drivers as well. Rene Kluwen Chimit -----Original Message----- From: Mi Reflejo [mailto:[EMAIL PROTECTED] Sent: maandag 29 mei 2006 10:01 To: Rene Kluwen Cc: [email protected] Subject: Re: [PATCH] SQLBOX Delivery Reports Insert Rene. How are you? I don't know if you have seen this mail. FYI. On 5/19/06, Mi Reflejo <[EMAIL PROTECTED]> wrote: > You can filter out dlr by sms_type with a statement like (..)WHERE > sms_type=3; if you want to keep delivery reports for any reason so i suggest > to ignore "ACK/" messages that bearerbox sends. These kind of msg are > useless. > > I'm attaching my suggested patch. (Tested and working) > > And of course if the table already exists you must to do: alter table > sent_sms modify momt enum('MO','MT','DLR'); > > Regards, > Martin >
