I do use that as well...however, you want the editor to be working on data whilst on the live site everything is as normal until the editor decides they've finished editing / updating and choose to click the big "don't click this button" button that publishes the content.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 2:48 PM Subject: Re: [ cf-dev ] General CMS question > > you could also add a boolean or numeric field to the relevant tables, > called Publish or something similar. If it's 0 don't publish it, but put > it in the 'proof-read this' list. Once it's been proofed, they choose to > Publish it and you set this value to 1. If you have more than 2 states, > just have different values for each state and use an integer field. > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > "Damian Watson" > <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> > ign.co.uk> cc: > Subject: [ cf-dev ] General CMS question > 10/10/2003 14:35 > Please respond to dev > > > > > > Hey y'all > > I've made quite a few CMS now and got a fairly standardised template thang > going. However one thing that always niggles me is the publishing of > content > onto the live website. I've tried two approaches to avoid immediate > publishing once data is changed: > > 1) when a user chooses content to edit it goes over to a staged db table > (i.e. myContentStaged) and then is published once they proof read; and > 2) user makes changes in db and then publishes flat files of content > (i.e.myContent.htm), writing them onto the live server after proof reading. > > I'm sure this is all very familiar but does anyone have any preferences or > alternative methods?? > > Cheers > d > ...and don't let this stop you from Friday beer \~/ > > > ----- Original Message ----- > From: "Snake Hollywood" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 10, 2003 2:21 PM > Subject: RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool > > > > Me a beginner. Heheh!!!! > > > > Once upon a time Allan I used to answer the questions on list before the > > questions even appeared... > > > > Russ Michaels > > Macromedia/Allaire Certified ColdFusion Developer > > > > CFDeveloper > > The free resource and community for ColdFusion developer. > > http://www.cfdeveloper.co.uk > > > > Join the CFDeveloper discussion lists. > > To subscribe send an e-mail to [EMAIL PROTECTED] > > > > > -----Original Message----- > > > From: Allan Cliff [mailto:[EMAIL PROTECTED] > > > Sent: 10 October 2003 13:16 > > > To: [EMAIL PROTECTED] > > > Subject: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool > > > > > > > > > I have been on this mail for maybe a year now and I think we > > > all have a fair idea of each others cf level and areas of expertise. > > > > > > As I understand it Russ is setting up CFMXHosting.co.uk and > > > we can gather from that, that he is not a beginner to CF or SQL. > > > > > > So I really think this reply is an insult to his level of > > > intellingence. > > > > > > In fact I have seen that Neil Robertson has had some > > > attention drawn to his answers of late. I think that if you > > > are not prepared to give the answer asked for then just let > > > someone else answer. > > > > > > Who is this guy anyway? He must spend all damn day writing > > > emails as he is always on cfdev, cftalk and farcry and god > > > knows how many more lists. > > > > > > My two pennies worth. As it is Friday. > > > > > > Allan > > > ----- Original Message ----- > > > From: Robertson-Ravo, Neil (RX) > > > To: '[EMAIL PROTECTED]' > > > Sent: Friday, October 10, 2003 12:49 PM > > > Subject: [cfmail] RE: [ cf-dev ] Database schema tool > > > > > > > > > well... > > > > > > select name from sysobjects where type = 'U' > > > > > > will give you all user tables.... > > > > > > > > > > > > -----Original Message----- > > > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > > > Sent: 10 October 2003 11:48 > > > To: [EMAIL PROTECTED] > > > Subject: [ cf-dev ] Database schema tool > > > > > > > > > I know someone here, possibly Spike, wrote a tag to query the system > > > tables and give back all user tables and column info for a specified > > > database. > > > Anyone got a copy to save me writing it. > > > > > > Russ Michaels > > > Macromedia/Allaire Certified ColdFusion Developer > > > > > > Satachi Internet Development > > > > > > Phone: 0870 787 3610 > > > Tech Support: 0906 9607800 > > > FAX: 0709 2212 636 > > > http://www.satachi.com > > > email general: [EMAIL PROTECTED] > > > email support: [EMAIL PROTECTED] > > > > > > Join our ColdFusion Developer discussion lists. > > > Send an e-mail to [EMAIL PROTECTED] > > > > > > > > > -- > > > ** Archive: > > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > ** Archive: > > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]