Can you place a unique index on the table(s) you are inserting on. Then the
duplicate record would fail due to the unique constraint ... you could
trap/catch this error and return to regular process flow.
Bill Reichard
Willow Gold
[EMAIL PROTECTED]
http://www.willowgold.com
In a message dated 1/17/01 12:27:22 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
>
> Anyone know of a way to stop records from being reinserted into a
> database when a user hits the back button? I have a page that checks
> for duplications in a database, and if it finds no duplicate, then it
> will insert it into the database. Problem is, when a user hits the back
> button, it inserts the record again. Its not finding duplicates more
> than likey because the query is being cached so it doesnt know to look
> again. But how can I get it to either do nothing including not
> inserting the record a second time or atleast recheck again to see if
> its a duplicate record? I can't take caching off this machine as these
> are some monster queries and performance is greatly improved by caching
> queries.
>
> Thanks
>
> ***********************************
> Misty Woodward
> ODS Decision Support
> tel: 913.315.6583
> email: [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
