[Asterisk-Users] Using ',' character in applications data

[GUSTAVO GARCIA BERNARDO]

Thank you very much. 

1. The problem with ',' is worked around using the syntax:
exten => 1,1,MYSQL,"INSERT INTO services user,service VALUES ${callerid},voicemail"
instead of
exten => 1,1,MYSQL(INSERT INTO services (user,service) VALUES (${callerid},voicemail)

2. About using SQL statements in extensions.conf, i would like to hear your proposed to improve the application. In first instance, I choose SQL statemens to offer maximum flexibility, because current postgres application allow it too and to avoid the administrator the learning of other syntax.

Best regards.

G.

----- Mensaje original -----
De: Jeremy McNamara <jj at nufone.net>
Fecha: Martes, Abril 27, 2004 9:03 pm
Asunto: Re: [Asterisk-Users] Using ',' character in applications data

> GUSTAVO GARCIA BERNARDO wrote:
> 
> >I'm developping an application for asterisk and i need to pass SQL 
> querys with ',' character as data.
> >exten => 1,1,Sql(SELECT info,user FROM.....
> >  
> >
> 
> Come on....build the application properly. There is absolutely no 
> need 
> for one to have SQL statements in your extensions.conf file. Just 
> pass 
> in the required info to your application and build the SQL 
> statement in 
> the application, then set channel variable(s) if necessary.
> 
> 
> You have to be smarter than what your working on.
> 
> 
> 
> Jeremy McNamara
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>