search for: dbqueri

Dear R experts, I've realized that it might not be possible to define a negative SELCET statement in a SQL call so now I'm looking for the smoothest way to generate a list of what I would like from my large database by first pulling all the names with a query like this "SELECT top 1 * FROM your_table" (thank you Bart Joosen for the idea) and then subtract the variables I am not

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