Jeff,
Absolutely possible.
When the user originally inserts the information through the form, add a
column in the database like "live"... when they initially insert that
information, set live = 'no'
Then preview the information
When they are sure they want the information up on the site, update the
table setting live = 'yes', and your query on the news page should look like
select *
from news
where live = 'yes'
Aaron
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 29, 2000 8:01 AM
To: Cf-Talk
Subject: Is it possible to have a preview of records before going live??
Hey everyone,
I have a site where the users can add text to a form that will then
go to database, and from that a "news page" will get it's
information. Easy.
But, my client wants a way to add the text, hit enter, then preview
it with the ability to make changes before it goes live. After the
preview/change process he can hit another submit button to have the
info go live.
I'm looking for ideas as to where to start. Is this possible? Do I
need 2 tables, a beta table that is used before it goes live to the
final table? I'd need to figure out how to get the record from the
beta table to the live table.
Any better/other ideas? All help or suggestions are appreciated on
this one...
Jeff F.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
