Hi TIA, I think that somehow you will need to change the code, however there is a tutorial on stored procedures on mysql here: http://www.brainbell.com/tutorials/MySQL/Using_Stored_Procedures.htm
I woudl prefer to see the code as a patch in kannel if required to work rather than rely on a "specific" sql implementation of stored procedures.. Julien 2009/6/8 Benaiad <[email protected]>: > Thank you Nikos, But how can I configure kannel to call a stored procedure > in mysql, I think this will help non programmers users. > > TIA > > 2009/6/8 Nikos Balkanas <[email protected]> >> >> You don't need smsbox to push SMS, if you have sqlbox. But you need it for >> incoming SMS and sms services. >> >> BR, >> Nikos >> >> ----- Original Message ----- >> From: Benaiad >> To: users >> Sent: Saturday, June 06, 2009 10:05 PM >> Subject: Re: SQLBox with utf8 chars >> Correction: >> I've successfully implemented this scenario, But I need to know if I can >> use this without the need of smsbox. >> >> Thanks! >> >> >> On Sat, Jun 6, 2009 at 9:03 PM, Benaiad <[email protected]> wrote: >>> >>> I've found this: >>> 1- to convert from HEX to utf8 using mysql: >>> SELECT CONVERT(UNHEX(msgdata) USING ucs2 )Β FROM sent_smsΒ WHERE sql_id >>> = 14 AND coding = 2 >>> >>> 2- to convert from utf8 to HEX using mysql: >>> SELECT HEX(CONVERT(myutf8string USING ucs2)Β ) >>> >>> Now I want to use bearerbox with sqlbox only: >>> Every MO message will be saved in sent_sms table by sqlbox. >>> And every INSERT into sent_sms table will call a trigger, the trigger >>> will analyze the MO message and insert it's response into the send_sms >>> table. >>> I've successfully implemented this scenario, But I need to know if I can >>> use this with the need of smsbox. >>> >>> Thanks guys for your kind response and special thanks to Alejandro >>> Guerrieri for his great support and concern. >>> >>> Best Regards. >>> >>> Monim Benaiad >> > > -- Julien Buratto
