(RADIATOR) Impliment a prepaid system with peak/offpeak rates by

Fri, 28 Jan 2000 12:52:15 -0800

hi

I need help from you all to run a stored procedure on MSSQL server my ultimate goal is to add peak / ecnomical / offpeak rate(rates are defined on a table and a particular pre paid amout) for login users depends on username and login time. In here user's session-timeout is calculated on time he logged in depend on time and rate.

I have written a SQL stored procedure to do this calculation but I can't intigrate it into single sql statement.
my sql statements are " execute proc_calsess %n " and " select PASSWORD,CHKATTR,REPLYATTR from SUBSCRIBERS where USERNAME='%n' "
here proc_calsess procedure calculate the Session-Timeout amout from Dollar amout he has when login time.

Pls can someone help me to do this...I was trying to do this in several ways. but that all gone fail attempts..Is there any better way to impliment this system.

thanks

lakmin


>
>Hello Lakmin -
>
>On Fri, 21 Jan 2000, S.K.D. Lakmin Premnath wrote:
>>
>> hi hugh
>>
>> I am connecting to MSSQL from BSDI unix box.
>> So before running the select SQL query I need to execute a stored procedure.
>> exec proc_calsess %n
>> select USERNAME, REPLYATTR from SUBSCRIBERS where USERNAME = %n'
>> When I run these two sql query from my cfg file  it gave an error " Error
>> processing tds packet.  Coulnd't get column information" . So please help
>> me to intigrate these two sql statements into one single AuthSelect
>> statement. These two query works fine in NT SQL Server Query Analyzer
>>
>
>The first thing to try is adding a delimiter between the two statements, but
>this may not work however. Otherwise, its probably easier to incorporate the
>select into your stored procedure. Perhaps you can explain in detail what you
>need to do and I can make a better suggestion.
>
>regards
>
>Hugh
>
>
>--
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
>Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
>NT, Rhapsody
>
>===
>Archive at http://www.thesite.com.au/~radiator/
>To unsubscribe, email '[EMAIL PROTECTED]' with
>'unsubscribe radiator' in the body of the message.
>
================================================
S.K.D. Lakmin Premnath.
(Systems Engineer)
Lanka Internet Services Limited.
( http://www.lanka.net )
Network Operating Center
No, 156 1/1 Walukarama Road,
Colombo 3,
Sri Lanka.
Tel : +94 1 565071
Fax : +94 75 335637
Email : [EMAIL PROTECTED]

=================================================
=== Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.

Reply via email to