(RADIATOR) Can you use SQL if statements in radiator?

[Hugh Irvine]

Hello Craig -

What operating system and SQL database are you using?

If your database supports stored procedures it would probably be 
simplest to do it that way. Otherwise you could write a hook to 
implement the same processing inside Radiator. It may also be possible 
to use a clever SQL statement, but that is outside my area of 
expertise.

regards

Hugh



On 27/11/2003, at 8:51 AM, Craig Gittens wrote:

> Hey guys,
>
> I am trying to get a new product to work where when the username and
> password is used and is valid then it would update the SQL database 
> with an
> end date for the product. So I need this logic to work in a SQL 
> statement in
> Radiator:
>
> User is a valid user and is allowed online,
> User entry gets update in SQL with a date I set (today + 30 days)
>
> If not then it would not update the user entry of course....
>
> Is this possible? I have tried SQL Functions but they can't update a
> permanent table.
>
> Regards,
>
> Craig.
>
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.