AW: [Asterisk-Users] Bug in PGSQL

[Thomas Haeger]

The whole extenstr is as follows:

	exten => ....Connect etc.

	exten => _XXXX,2,"Query resultid ${connid} SELECT count(*) from tbltest
where fldtest='${EXTEN}'";

	exten => .....

It works with

	exten => _XXXX,2,"Query resultid ${connid} SELECT fldtest from tbltest
where fldtest='${EXTEN}'";



Regards,

Thomas
-----Ursprüngliche Nachricht-----
Von: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com]Im Auftrag von Steven
Critchfield
Gesendet: Montag, 26. Mai 2003 16:09
An: asterisk-users at lists.digium.com
Betreff: Re: [Asterisk-Users] Bug in PGSQL


Did you quote the string?

Granted I haven't used mine in a while, but I have a similar query that
has worked just fine in extensions.conf.

On Mon, 2003-05-26 at 08:46, Thomas Haeger wrote:
> Hi all,
>
> i use the PGSQL App, and i have found out, if you use a "(" or a ")" in
your
> query the query crashes...
>
> My sample query was :
>
> 	SELECT count(*) from tbltest where fldtest='xxx'
>
> can somebody fix this ...??
>
> Regards,
>
> Thomas.
>
>
> *******************************************
> beroNet technologies GmbH
> Dipl.- Ing. Thomas Häger
> Potsdamer Str. 18 A
> 14513 Teltow
>
> FON:    +49 (0) 3328 3077731
> FAX:    +49 (0) 3328 334779
> Email:  thomas.haeger at beronet.com
> *******************************************
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
--
Steven Critchfield <critch at basesys.com>

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users