DEar Please help me, i am making an application on kannel and using only bearerbox and sqlbox. problem is that when i submit message in send_sms table, my application has a trackid for every message, which i have to use for collecting delivery report from sent_sms table but i have no option to insert the record in send_sms table with this trackid and collecting delivery report on the basis of this trackid from sent_sms table. Is there any other way to do this. presently i am inserting a trackid variable in dlr_url field of the send_sms table. but when i get this in sent_sms table it is encoded. and when i collect deliery report from sent_sms table, first it decodes dlr_url and fetch trackid field then match it , it is taking too much time and increasing load of the server too much. Is there any other way to do it or can i hit any API to update my database when delivery report updated in sent_sms table.
Please help, thanks. abhi
