I usually just set a "live" toggle in the table. Once the end users
approves, she can click the "post" or "I love it now make it live" button,
and you flip that bit to "on" or "true" or 1 or whatever :-)
IOW, you write each form submission to the DB, and display it in it's
intended final state (graphics, etc), as often as needed. Then you make it
live on the "approved" posting.
HTH-YMMV,
Jeff
> -----Original Message-----
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 29, 2000 11: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.