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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. -- Andy De Petter - http://www.techos.be/andy - [EMAIL PROTECTED] (ROT13) Senior System Engineer - Skynet IT & Network - http://www.skynet.be === 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.
