RE: Using STORED PROCEDURE with Freeradius

2006-02-08 Thread Saeed Ahmed
. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Agus Supriyadi Sent: Wednesday, February 08, 2006 3:55 AM To: FreeRadius users mailing list Subject: Re: Using STORED PROCEDURE with Freeradius 2006/2/7, Saeed Ahmed [EMAIL PROTECTED]: Hi, For some reasons I've to use Stored

Re: Using STORED PROCEDURE with Freeradius

2006-02-08 Thread data zone
I do not know about mysql, but i have used stored procedures just fine with postgresql. it can look something along the lines of: authorize_check_query = SELECT * FROM someproc('%{SQL-User-Name}', '%{Client-IP-Address}') HAVING id IS NOT NULL for the record, I have been using stored procedures

RE: Using STORED PROCEDURE with Freeradius

2006-02-08 Thread Saeed Ahmed
appreciate your help Thanks Saeed Ahmed. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Saeed Ahmed Sent: Wednesday, February 08, 2006 12:53 PM To: 'FreeRadius users mailing list' Subject: RE: Using STORED PROCEDURE with Freeradius Thanks

Using STORED PROCEDURE with Freeradius

2006-02-07 Thread Saeed Ahmed
Title: Using STORED PROCEDURE with Freeradius Hi, For some reasons I've to use Stored procedure With Freeradius but I am getting following error from mysql: Error: 1312 SQLSTATE: 0A000 (ER_SP_BADSELECT) Message: PROCEDURE %s can't return a result set in the given context You can

Re: Using STORED PROCEDURE with Freeradius

2006-02-07 Thread Agus Supriyadi
2006/2/7, Saeed Ahmed [EMAIL PROTECTED]: Hi, For some reasons I've to use Stored procedure With Freeradius but I am getting following error from mysql: Error: 1312 SQLSTATE: 0A000 (ER_SP_BADSELECT) Message: PROCEDURE %s can't return a result set in the given context You can