search for: dbquery

...t the variables I am not allow to pull manually ending up with a 'positive' definition of what I want, something I can use in a SQL SELCT statement (see my email on this list from yesterday for more on that). When I query the database for the variable names I get something similar to 'DBquery' in my working example below, but considerable longer with over 2400 hundred variables. As I only need to remove two or three variables I would like to define a lookup table (like the list 'lookup' in my example) and subtract that from my data base query. Now to my question. Is there a...

Hi! What is the preferred way to make database lookups from within the dialplan? I only know the MYSQL function from asterisk-addons. Are the other methods too? (e.g. for postgresql, unixodbc) thanks klaus

Has anyone tried to compile the current version of MySQLPool from http://www.yosd.at <http://www.yosd.at/> against Asterisk 1.4.4? It seems to not compile... [root@itsentinel res_mysqlpool]# make gcc -pipe -pipe -Wall -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -g -Iinclude -I../include -I/usr/local/mysql/include/mysql -D_REENTRANT -D_GNU_SOURCE -O6

Hi, Since I've upgraded to Asterisk 1.4 I can't use a MySQL database anymore for select queries :-( I'm using dbquery from MysqlPool Application 1.4 and selecting something from a table returns nothing even if I try to do a query like "SELECT 1;" Is anyone in the same troubles ? Do you advice me another solution to connect to my database ? For information, I'm using MySQL 5.1 (for xml) on a ubunt...