Skip to main content
October 5, 2010
Question

How to avoid multiple copies of data in page refresh

  • October 5, 2010
  • 2 replies
  • 587 views

How to avoid multiple copies of data in page refresh

    This topic has been closed for replies.

    2 replies

    Inspiring
    October 5, 2010

    If you are talking about a page with an insert query, ignore the fact that it's a page refresh.  It's just another way that someone can insert duplicate records.  I like to handle this in my insert query.

    insert into thetable

    (f1, f2, etc)

    select distinct

    value1, value2, etc

    from some_small_table

    where you don't already have that record

    Owainnorth
    Inspiring
    October 5, 2010

    Dan, I genuinely don't know how yourself (and Adam) have the patience to deal with posts like this politely so often; many a time I've nearly sent a finger straight back but have stopped myself at the last minute.

    existdissolve
    Inspiring
    October 5, 2010

    Such as??