Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 12th, 2005, 07:29 AM
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Recordset Update question

Hi,

i am coding in classic asp and have the following problem:

website showing addresses, that users can update through a form. users update a specific recordset, whcih requires review & approval by myself. before i have reviewed & approved the recordset, the old version should still be online. as soon as i approve the update request, the old version gets updated.

how can i manage to do that?

thanks for your help, mark

  #2 (permalink)  
Old March 12th, 2005, 08:13 AM
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Have one extra field in your database along with address as "verified" (it can be MS Access Yes/No or SQL Server bit field). in your admin related form also have a checkbox "verified". Once you have reviewed the address check the checkbox which will eventually update that db field and then and then only user will be able to see the updated address.
  #3 (permalink)  
Old March 14th, 2005, 03:57 AM
Authorized User
 
Join Date: Aug 2003
Location: Jakarta, DKI Jakarta, Indonesia.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sherief Send a message via Yahoo to sherief
Default

I think you need a temporary table which its fields just exactly like the real table and 1 field as your reference to real table, when users update it's stored in this temporary table, and when you approve, it updates the real table and deletes data on the temporary.

example:

tblUsers (the real one)
---------
record_id
name
address

tblUsersTemp (the temporary)
------------
record_id
users_id (reference to record_id in tblUsers)
name
address

Regards,
Sherief C. Mursyidi


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update Recordset using oledb.command jmhemadri Classic ASP Databases 5 September 11th, 2008 03:46 PM
Diff between Recordset.update & insert cmd mp3pm VB Databases Basics 6 September 1st, 2006 03:54 PM
Select and Recordset question iacon Beginning VB 6 4 June 24th, 2006 09:37 AM
Question regarding recordset emachines Access VBA 3 March 3rd, 2005 08:52 AM
Update table with a recordset - help!!! chacquard Access VBA 3 February 17th, 2004 08:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.