Home | Advertising Info8 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Monday, May 20, 2024  

  Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - General
 PowerASP Code Help Area : Classic ASP - General
Subject Topic: preventing duplicate record insertions Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
DevDevil
Newbie
Newbie


Joined: January/06/2006
Location: United States
Online Status: Offline
Posts: 1
Posted: January/06/2006 at 9:20am | IP Logged Quote DevDevil

Anybody know the best way to prevent the same information from being inserted into a db table from a form. If someone refreshes a page once they've added a record it adds another duplicate record... that's what I'm trying to prevent.

Thanks



__________________
It is the mark of an educated mind to be able to entertain a thought without accepting it.
-Aristotle
Back to Top View DevDevil's Profile Search for other posts by DevDevil Visit DevDevil's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Posts: 137
Posted: January/22/2006 at 1:36pm | IP Logged Quote cwilliams

search the newsgroups via google... these are things I found real quick

http://groups.google.com/group/macromedia.ultradev/browse_th read/thread/2727b27d7c8e9575/dbece651e44f9fa0?lnk=st&q=d uplicate+records+asp+database&rnum=2#dbece651e44f9fa0

http://groups.google.com/group/microsoft.public.inetserver.a sp.general/browse_thread/thread/bae34177c7ee05a7/96fe551b1bd bdb78?lnk=st&q=duplicate+records+asp+database&rnum=8 #96fe551b1bdbdb78



__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other posts by cwilliams
 
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Posts: 27
Posted: February/06/2006 at 12:58pm | IP Logged Quote mjunior
Another way to do it will be setting thie variable as primary key on your table and treat the db error by displaying some advertisement to the user...

__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other posts by mjunior
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

   Active Server Pages Rule The World
 Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2024 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
 STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com