Please help.....

        this is generally a problem with arguments that contain "," or "(", i
think.

-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Auftrag von Thomas
Haeger
Gesendet: Sonntag, 29. Juni 2003 15:18
An: Asterisk User
Betreff: [Asterisk-Users] PGSQL app and pbx parsing :-(


Hi all,

i try to use PGSQL app effectively, but there are two problems:

        1. If i use PGSQL like

        exten => s,3,PGSQL,"Query resultid ${connid} SELECT count(*) FROM credit
WHERE callerid=${callerid}";

        an error occurs with breaking query string at "(" (first bracket).

        ....then somebody told me that i should use PGSQL like follow:

        exten => s,3,PGSQL,(Query resultid ${connid} SELECT coun(*) FROM credit
WHERE callerid=${callerid})

        this works BUT,

        2. If i use PGSQL like

        exten => s,3,PGSQL,(Query resultid ${connid} SELECT username,credit FROM
credit WHERE callerid=${callerid})

        the query string will be broken at the first ",".


        I think this is a parsing problem in pbx.c
        this prog exchange "," into "|" and parse string for "(" to affect the
beginning from arguments for the app.


How can i solve this problem, is there a trick i can use ?

Or ist this just a BUG ?


Thanks for Help,

Thomas.

_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users

_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to