Re: How to execute TWO OR MORE Sql statement?

2006-07-27 Thread Alan DeKok
Duane Cox [EMAIL PROTECTED] wrote: Wouldn't it be possible to have freeradius call different sql sections depending on other attributes. Yes. But I get this error... Failed to link to module 'rlm_sql1': rlm_sql1.so: cannot open shared object file: No such file or directory See the

Re: How to execute TWO OR MORE Sql statement?

2006-07-26 Thread Alan Lumb
Create a stored procedure in the database that contains all of the SQL queries necessary. Then call that stored procedure via sql.conf. This works fine with Postgres. MySQL 5 supports stored proceedures and functions, however I know that mysql proceedures can cause problems as they can/will

RE: How to execute TWO OR MORE Sql statement?

2006-07-26 Thread Jurgen van Vliet
,var3) Regards, Jurgen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Alan Lumb Verzonden: woensdag 26 juli 2006 14:08 Aan: FreeRadius users mailing list Onderwerp: Re: How to execute TWO OR MORE Sql statement? Create a stored procedure in the database

How to execute TWO OR MORE Sql statement?

2006-07-25 Thread 王世彦
Oh, my have another question about Freeradius. I see when the Freeradius receives whatever a request, Freeradius will execute ONE SQL statement which is defined in the sql.conf. My question is how to make Freeradius to execute TOW OR MORE SQL statement when Freeradius receives a request. I am

Re: How to execute TWO OR MORE Sql statement?

2006-07-25 Thread Dan O'Neill
王世彦 wrote: Oh, my have another question about Freeradius. I see when the Freeradius receives whatever a request, Freeradius will execute ONE SQL statement which is defined in the sql.conf. My question is how to make Freeradius to execute TOW OR MORE SQL statement when Freeradius receives