AW: [Asterisk-Users] PGSQL app and pbx parsing :-(

[Thomas Haeger]

Please help.....

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

-----Ursprüngliche Nachricht-----
Von: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com]Im 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
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users