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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.