I didn't include users either. my bad.
From: Rene Kluwen [mailto:rene.klu...@chimit.nl] Sent: Thursday, 02 August, 2012 22:19 To: 'spameden' Subject: RE: schedule delivery of sms No, after sending the sms, the structure, including the time field is discarded. Either way, if need be, bearerbox can modify the time field at any time. Because we've already used it and after that the value is of no use anymore. According to Emmanuel, it works like a charm. But as you wish, post your comments on the list and let everybody know what you think of it. You are right if your opinion is that this is a cleaner solution. == Rene From: spameden [mailto:spame...@gmail.com] Sent: Thursday, 02 August, 2012 22:15 To: Rene Kluwen Subject: Re: schedule delivery of sms I thought time is used in bearerbox as a special field? Bearerbox inserts time of the sending there (it's not always the same as the time you wanted, especially if there is a big queue). I'd suggest creating another field, like CREATE_DATE with standard datetime format and altering query. 2012/8/3 Rene Kluwen <rene.klu...@chimit.nl> This is from an old post from Emmanuel Chanson: >in gw/sqlbox_mysql.h > something like: > SELECT sql_id, momt, sender, receiver, udhdata, \ >msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, coding, \ >compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \ >charset, boxc_id, binfo, meta_data FROM %S WHERE time < UNIX_TIMESTAMP(NOW()) LIMIT 0,1" Having done that, you can just insert a valid time in the "time" field and sqlbox will automatically send the sms at the desired time. == Rene From: users-boun...@vm1.kannel.org [mailto:users-boun...@vm1.kannel.org] On Behalf Of neo nortan Sent: Thursday, 02 August, 2012 18:12 To: users Subject: schedule delivery of sms dear list can i schedule delivery of sms. i am using sqlbox in kannel regards <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/sign atureline.htm@Middle?> Follow Rediff Deal ho jaye! to get exciting offers in your city everyday. <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/sign atureline.htm@Middle?>