>- see footer for list info -< What if you want to keep multiple copies or have version control? Usually nicer to have one Version History table to store Object Versions of all types - allowing you to rollback like I noted before.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Damian Watson Sent: 02 March 2005 15:41 To: Coldfusion Development Subject: Re: [CF-Dev] Publishing content >- see footer for list info -< I think the original point is you have a live column and a dev column in the data row rather than flagging whether it's live or not... which is a nice idea- saves having a whole extra table which always felt a little superfluous to me. d Robertson-Ravo, Neil (RX) wrote: >>- see footer for list info -< >> >> >Yes, AND and not OR. > >>From what I understand here is this (if its different, please correct).... > >1. Row of content with a Flag for live & not live. >2. I am assuming that this row is also the row used for content on the site? >3. If the Selects on the front-end look for live=1 then it will disregard >non-live > >So with this, you can never have Live and Not Live content on a site of data >in that row. > >Neil > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Russ Michaels >(Snake) >Sent: 02 March 2005 15:00 >To: 'Coldfusion Development' >Subject: RE: [CF-Dev] Publishing content > > > >>- see footer for list info -< >> >> >So having content that can be marked as LIVE or NOT live does allow for live >and not-live content? > >Perhaps you better rethink what you just said neil. > >Russ > > > >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of >>Robertson-Ravo, Neil (RX) >>Sent: 02 March 2005 09:37 >>To: Matt Horn; Coldfusion Development >>Subject: RE: [CF-Dev] Publishing content >> >> >> >>>- see footer for list info -< >>> >>> >>That approach does not allow for LIVE and non-Live content >>though? We tend to go for the Holiding Table approach where >>you have dupe copies of each record OR we have a Version >>History type object ala Spectra (was my tool of choice for my sins). >> >> >> >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of Matt Horn >>Sent: 02 March 2005 09:39 >>To: Coldfusion Development >>Subject: Re: [CF-Dev] Publishing content >> >> >> >>>- see footer for list info -< >>> >>> >>well I normally have a "LIVE" column in my content table and >>toggle that >> >> >>----- Original Message ----- >>From: "Damian Watson" <[EMAIL PROTECTED]> >>To: "Coldfusion Development" <[email protected]> >>Sent: Wednesday, March 02, 2005 11:37 AM >>Subject: [CF-Dev] Publishing content >> >> >> >> >>>>- see footer for list info -< >>>> >>>> >>>Hi all, >>> >>>Just a general question about publishing content in a CMS. I've seen >>>(and used) two main approaches: >>> >>>1. Have content saved into database and when content is >>> >>> >>published, write >> >> >>>it to static htm or xml files >>>2. Have "staged" and "live" tables in the db. When content >>> >>> >>is published, >> >> >>>copy from one t'other >>> >>>Anyone have any preferences or alternatives, resource links, books? >>> >>>d >>>_______________________________________________ >>> >>>For details on ALL mailing lists and for joining or leaving >>> >>> >>lists, go to >>http://list.cfdeveloper.co.uk/mailman/listinfo >> >> >>>-- >>>CFDeveloper Sponsors:- >>> >>> >>>>- Hosting provided by www.cfmxhosting.co.uk -< >>>>- Forum provided by www.fusetalk.com -< >>>>- DHTML Menus provided by www.APYCOM.com -< >>>>- Lists hosted by www.Gradwell.com -< >>>>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>>> >>>> >>help -< >> >>_______________________________________________ >> >>For details on ALL mailing lists and for joining or leaving >>lists, go to >>http://list.cfdeveloper.co.uk/mailman/listinfo >> >>-- >>CFDeveloper Sponsors:- >> >> >>>- Hosting provided by www.cfmxhosting.co.uk -< >>>- Forum provided by www.fusetalk.com -< >>>- DHTML Menus provided by www.APYCOM.com -< >>>- Lists hosted by www.Gradwell.com -< >>>- CFdeveloper is run by Russ Michaels, feel free to >>> >>> >>volunteer your help -< >>This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, >>Richmond, Surrey, TW9 1DL, United Kingdom), a division of >>Reed Business, >>Registered in England, Number 678540. It contains >>information which is >>confidential and may also be privileged. It is for the >>exclusive use of the >>intended recipient(s). If you are not the intended >>recipient(s) please note >>that any form of distribution, copying or use of this >>communication or the >>information in it is strictly prohibited and may be unlawful. >> If you have >>received this communication in error please return it to the >>sender or call >>our switchboard on +44 (0) 20 89107910. The opinions >>expressed within this >>communication are not necessarily those expressed by Reed Exhibitions. >>Visit our website at http://www.reedexpo.com >>_______________________________________________ >> >>For details on ALL mailing lists and for joining or leaving >>lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo >> >>-- >>CFDeveloper Sponsors:- >> >> >>>- Hosting provided by www.cfmxhosting.co.uk -< >>>- Forum provided by www.fusetalk.com -< >>>- DHTML Menus provided by www.APYCOM.com -< >>>- Lists hosted by www.Gradwell.com -< >>>- CFdeveloper is run by Russ Michaels, feel free to >>> >>> >>volunteer your help -< >> >> >> > > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go to >http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< >> >> >This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, >Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, >Registered in England, Number 678540. It contains information which is >confidential and may also be privileged. It is for the exclusive use of the >intended recipient(s). If you are not the intended recipient(s) please note >that any form of distribution, copying or use of this communication or the >information in it is strictly prohibited and may be unlawful. If you have >received this communication in error please return it to the sender or call >our switchboard on +44 (0) 20 89107910. The opinions expressed within this >communication are not necessarily those expressed by Reed Exhibitions. >Visit our website at http://www.reedexpo.com >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > > >>- Hosting provided by www.cfmxhosting.co.uk -< >>- Forum provided by www.fusetalk.com -< >>- DHTML Menus provided by www.APYCOM.com -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< >> >> > > > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
