Bill, >> record, but I need to do more processing and execute several SQL >> statements in order to do all the usage tracking I need.
I'm not informed about Radius in any way, but I guess what you want to do is have a middle-tier in form of an application, e.g. in PERL, PHP, or whatever. >> The RADIUS server can call a "stored procedure" and pass parameters to >> the procedure. This is what I need. I see that MySQL has a "batch >> mode", but I do not see any mention of how I could pass parameters to a >> MySQL batch file. Can I do this, if so, how? MySQL's batch mode is actually the MySQL Monitor's (mysql) capability to process data in a non-interactive way. You can feed it with as many SQL statements as you like, but there is no way to pass it parameters in the way you want to. You can go like mysql -e 'sql-statement', but then again you would have to have the parameters in place, in 'sql-statement'. >> I see that stored procedures are being added in a future release of >> MySQL, do I need to wait for this? Maybe others can tell you that you can solve your problem with UDF, but I guess Stored Procedures are the straightforward solution. They are planned for version 5.0: http://www.mysql.com/doc/en/News-5.0.x.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
