Hi all
Can anyone tell me how to properly get a conditional in my select
statement? This is being used for an authorization scheme using a Radius
authentication server. What I'm trying to do in psuedo mysql is the
following with english where I'm stuck:
select password, ip_address, num_ips, idle_timeout, \
multlogin, cust_type, prepaid_secs from Radius where \
((username='%U')&&((realm='%{Realm}')||(realm='all'))&&
\
((ISNULL(on_hold))||(on_hold not in ('true')))&&
"If cust_type is 'prepay' or 'unlimited' then
prepaid_secs has to be > 0"
I don't even know if this is possible, but if so, I can't figure it out.
Griff Hamlin, III
---------------------------------------------------------------------
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
