>- see footer for list info -< yeah!! not my DB design - system is pretty big and complex actually
On 5/17/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > You could do this via a View and with the extra columns,....but I suppose > you have most of this in place so it may harder to change at this stage.. > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Richard Lovelock > Sent: 17 May 2005 11:37 > To: Coldfusion Development > Subject: Re: [CF-Dev] CFTRANSACTION and DELETEs > > >- see footer for list info -< > OK thanks guys some useful info there > > Info about erroring is useful and that it won't rollback if no deletion > done. > > Second table is an action table to record a host of different actions > being performed on a business area - they want an audit trail of the > deletion and from which table > > On 5/17/05, Robertson-Ravo, Neil (RX) > <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > > Better practice would be to perform a logical delete rather than a > physical. > > Add the following columns to the main table.... bDeleted (bit), dDeletedBy > > (varchar/ID as you see fit), dDateDeleted (datetime) column to the table > and > > perform the deletes that way. What purpose would adding and writing > another > > table to track deletes etc when you can do it all in one. > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Richard Lovelock > > Sent: 17 May 2005 11:19 > > To: cfdev > > Subject: [CF-Dev] CFTRANSACTION and DELETEs > > > > >- see footer for list info -< > > I have a block of code that needs to delete a record from a table and > > insert an action audit trail of the deletion in to a different table. > > > > Something like: > > > > Delete from X where ID = 1 > > > > Insert into Y Values 1, deleted > > > > Is this a good place to use CFTRANSACTION around the whole block of two > > queries? > > > > As I understand - the cftransaction will not perform the second query > > if the first is not successful. If the first query didn't find any > > matching records to delete (i.e. not on the table), would this count > > as 'not successful' and therefore skip the bottom query? > > > > Hope that's clear!? > > > > -- > > > > Richard Lovelock > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go to > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > > > >- 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 > -< > > > > -- > > Richard Lovelock > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > > >- 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 -< > -- Richard Lovelock _______________________________________________ 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 -<
