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]
