(RADIATOR) calculating alive record

[Andy De Petter]

I would suggest using a REPLACE INTO.. that would update everything 
accordingly.  You just need to make sure your unique key(s) are well 
configured.

-Andy

Alex Symthe wrote:
> 
> hi All,
> 
> We are using Radiator 3 and need to do some processing on the accounting 
> records in RADONLINE. When ever we recieve an Alive Record when need to 
> update the TIMESTAMP field in RAODNLINE for the corresponding username. 
> Im not sure how to write this but here's what it should do...
> 
> -> Incoming Alive Record
> ++ UPDATE RADONLINE SET TIMESTAMP = %t WHERE username = %u
> 
> Does anyone have any similar code to do the above mentioned or some 
> ideas on how to do it?
> 
> THanks
> 
> 
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> 
> ===
> 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.

-- 
Andy De Petter - http://www.techos.be/andy - naql at gunvobk.or (ROT13)
Senior System Engineer - Skynet  IT & Network - http://www.skynet.be

===
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.