Duplicates created when refreshed

Results 1 to 2 of 2

Thread: Duplicates created when refreshed

  1. #1
    Join Date
    Dec 1969

    Default Duplicates created when refreshed

    The problem below was asked a while back but wasnt answered. Im having the same problem now : <BR><BR><BR>Im having trouble with my guestbook page. I used the insert into method and everything seems to be working except that everytime people would view the results page or refreshes the page the record duplicates. How can I get that to stop. <BR><BR>--------------------------------------------------------------------------------<BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Duplicates created when refreshed

    a couple of things to look at<BR><BR>Have you clear out your SQL statement.<BR><BR>lsSql = ""<BR>lsSql = lsSql &"STATEMENT IN HERE"<BR>Set lRecordSet = Db.Execute(lsSql) <BR><BR>have you close off recordset and set the recordset to nothing.<BR><BR>recordset.close<BR>db.close<BR>Rec ordset = nothing<BR>db = nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts