have the action page of your form do the insert, then use CFLOCATION to send
the user to the result page. have not HTML/other markup in your action
page. this effectively removes the action page from the user's "back"
history.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 10:25 AM
To: CF-Talk
Subject: duplicating inserts
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
