INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, dlr_url, boxc_id) VALUES ('MT', 'DEMO', '919XXXXXXXXX', 'SQLBOX
TESTING SERVER', 2, 'test', 31,
'http%3A//10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
BatchID%3DXXXX123-5d1XXXXXa', 'smsbox-id' );
Where 'smsbox-id' is a random instance of any smsbox that you have
connected.
From: Ravindra Gupta // Viva [mailto:[email protected]]
Sent: Monday, 30 July, 2012 16:43
To: Rene Kluwen
Cc: [email protected]; [email protected]
Subject: Re: dlr-url call on sqlbox
Dear Rene,
Can send some sample example.
On Mon, Jul 30, 2012 at 8:08 PM, Rene Kluwen <[email protected]> wrote:
This is a FAQ.
Sqlbox doesnt call dlr-urls, since its sql based and not http based.
The workaround is as follows:
Insert as your boxc_id the smsbox id of your connected smsbox.
== Rene
From: [email protected] [mailto:[email protected]] On
Behalf Of Ravindra Gupta // Viva
Sent: Monday, 30 July, 2012 16:31
To: [email protected]; [email protected]
Subject: dlr-url call on sqlbox
Dear Team,
How to call dlr-url on sqlbox.
Kindly find the mysql query as given below.
INSERT INTO send_sms (momt, sender, receiver, msgdata, sms_type, smsc_id,
dlr_mask, dlr_url) VALUES ('MT', 'DEMO', '919XXXXXXXXX', 'SQLBOX TESTING
SERVER', 2, 'test', 31,
'http%3A//10.0.0.1/sms/dlrNEW.php%3Fdlr%3D%25d%26to%3D%25p%26smsID%3D%25A%26
BatchID%3DXXXX123-5d1XXXXXa' );
