RE: FN-FORUM: ASP/MS Access Help

date posted 24th August 2007 11:15

Why not simply use one table and have live fields and preview fields and
copy the data from one field to the other on publish.

e.g. table structure

id
title_pre
title_live
content_pre
content_live
etc
etc

On save the preview fields are updated (this could be done via Ajax
automatically every 10 secs or so to be safe from session timeouts.) On
publish he preview fields are simply copied to the live fields. ID's stay
the same and everything is simple.

Regards
Sam Morgan
WiredEyes Media / ServWise Advanced Hosting

tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 773 6543
web : www.wiredeyes.com / www.servwise.com
----
umop ap!sdn w,! aw dlaH
----
==========================
Summer Sale 50% off all ServWise
hosting, use coupon code : HALFPRICE
==========================

> -----Original Message-----
> Hi All,
>
> I have created an ASP web page which is updateable via MS Access db.
> All data
> is stored in 1 table in the db, I have created a 2nd table which is
> identical
> and is used to display the data for the live page.
>
> Basically the user can make amendments to the web page and when there
> happy
> with it they click a button and all data is transferred from one table
> to
> another.
>
> At the moment I have created 3 script files:
> script1: deletes the live db redirect to script2 with ID1
> script2: gets the ID1 of the none live db, if EOF redirect to home page
> script3: writes ID1 to live db, redirect back to script2 with ID2
>
> This works only if the ID numbers are in consecutive order,
> unfortunately
> they're not.
>
> Can anyone suggest another way of doing this?
>
> TIA