How can i insert only disticnct values??
Posted on 2003-03-29
i am using a xml parser which runs every 20 mins and automatically inserts the data into the database.
It inserts the Stock's symbol, name, price and time (stock market time)
The problem is the parser runs all weekend long and just keeps putting in the same info, as the market is closed, at 4:00pm.
How can make it so it will only insert it in if the time stamp is unique
Thanks in advance