That is not a true / valued comparison but yeah, it is a specific requirement and agree 100% on that front.
"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 -----Original Message----- From: Snake <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Thu Jul 06 20:34:54 2006 Subject: RE: Old code woes That is a very specific requirement. You could use the same type of rule to say don't use stored procs and always put your SQL inline. But that would not be a good best practice either. Snake -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 06 July 2006 20:01 To: CF-Talk Subject: Re: Old code woes This is good and bad example. You may want the date in the DB with an offset with multiple webservers in a follow the sun approach write to a single DB in one location. A call to GetDate in this instance would lead to the same date/time for each you may not want. "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 -----Original Message----- From: Snake <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Thu Jul 06 20:01:21 2006 Subject: RE: Old code woes Or passing the data to the database using #NOW()# instead of using the database equivlant function, such as GetDate() -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 06 July 2006 18:00 To: CF-Talk Subject: Re: Old code woes One of my favourites in other's code was getting the date from the database instead of using Now() (trust me....no reason to do this in the context of the app) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54