Kinda what I'm doing (not a staged database but "staged" table which stores all previous states which is useful)... the boolean thang isn't necessary if you're creating static pages cos you can just edit away until you choose to publish.
I was just wondering if there was anyone doing anything radically different really... ----- Original Message ----- From: "Snake Hollywood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 10, 2003 2:56 PM Subject: RE: [ cf-dev ] General CMS question > The simplest way is just to store content in the same database, do not > use a staged database. You simply set flags for the content as > ACTIVE/Archived/APPROVAL/ > > Obviously content that needs approval is not live. When a moderator has > checked a piece of content they simply mark it ACTIVE. If you are > replacing an existing piece of content, you mark the old one as ARCHIVED > so that it can be rolle dback if neccesary. > The same way if u are generating static files, u just create the file > when it is marked as ACTIVE, and the ARCHIVED one will still exist in > the database. > > 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] > > > > -----Original Message----- > > From: Damian Watson [mailto:[EMAIL PROTECTED] > > Sent: 10 October 2003 14:35 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] General CMS question > > > > > > 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]
