Sending Message Via Updatind a DB

2007-09-18 Thread Jins
hello, i heard it is possible to sent sms by updating db and by using sqlbox... i have installed standalone sqlbox with kannel.can someone please tell me about the table design for the sqlbox to work

Sending Message Via Updatind a DB

2007-09-18 Thread Jins
hello, i heard it is possible to sent sms by updating db and by using sqlbox... i have installed standalone sqlbox with kannel.can someone please tell me about the table design for the sqlbox to work -- Jinson Abraham, Torque Technology Solutions, T-BIC, Park Center, Technopark, Trivandrum. w

Re: Sending Message Via Updatind a DB

2007-09-18 Thread preeteesh kakkar
Hi, Below is table format for send_sms table CREATE TABLE IF NOT EXISTS %S (sql_id bigint(20) not null auto_increment primary key, momt enum('MO', 'MT', 'DLR') null, sender varchar(20) null, receiver varchar(20) null, udhdata blob null, msgdata text null, time bigint(20) null, smsc_id varchar(2

Re: Sending Message Via Updatind a DB

2007-09-18 Thread Jins
Thanks a lot..But the table will be there already in the DB..Now the issue is when i update the send_sms table,the entered field will be transferred to sent_sms table but my sqlbox is getting terminated giving a log as below... 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version 4.1.22-sta