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

[Craig Gittens]

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.