Home | Advertising Info51 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Wednesday, May 01, 2024  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - General
 PowerASP Code Help Area : Classic ASP - General
Subject Info: preventing duplicate record insertions A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
DevDevil
Newbie
Newbie


Joined: January/06/2006
Location: United States
Online Status: Offline
Info: 1
Added: 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 info by DevDevil Visit DevDevil's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: 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 info by cwilliams
 
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: 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 info by mjunior
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   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.

vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com