SOT: SQL Server Data Archival - my solution

2010-07-30 Thread Pete Ruckelshaus
I know a lot of time people (including myself) come here with questions, and don't have many opportunities to offer solutions to share. I had a need to store a record of changes to records in database tables for a content management system. I wanted to keep things simple, without requiring a

RE: SQL Server Data Archival - my solution

2010-07-30 Thread DURETTE, STEVEN J (ATTASIAIT)
Pete, This is awesome! I'm going to consider using it for certain tables that we have problems with. I might suggest that you add in the user name and/or ip that made the change. That can help if you need to find out who made specific changes! Thanks, Steve -Original Message- From:

Re: SQL Server Data Archival - my solution

2010-07-30 Thread Pete Ruckelshaus
Steve, to keep things simple(r), I would store that info at the source table level. Since it's a web site, there's a single generic user account at the database level, but I do track user and IP at the CF application level in the table that specific data is stored...it's just not shown in the

RE: SQL Server Data Archival - my solution

2010-07-30 Thread Robert Harrison
be either/or.  It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com

sensitive data collection practices with cf

2010-07-30 Thread cfcom
Question about collecting sensitive data. We have a form set up with an ssl cert On the form there is an tax id number / social security box The data gets posted to a mysql database a) do you recommend adding additional encryption to the data when we put it into the database b) there is an auto

Re: sensitive data collection practices with cf

2010-07-30 Thread Dave Watts
Question about collecting sensitive data. Any answer you're likely to get here will be incomplete - including mine. You may have specific statutes with which you must comply, also. We have a form set up with an ssl cert On the form there is an tax id number / social security box The data

Re: sensitive data collection practices with cf

2010-07-30 Thread Scott Stewart
b) there is an auto email sent to the client's backoffice where the data is received - what is a good practice for handling the sensitive data on the email? Dont.. set up an admin interface and let them know they have data to attend to. Sending SSN's and TIN's over email is a bad idea. Stick

RE: sensitive data collection practices with cf

2010-07-30 Thread cfcom
Thank you Dave, you made some good points and I'm grateful for your feedback. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 2010-07-30 11:38 To: cf-talk Subject: Re: sensitive data collection practices with cf Question about collecting sensitive data. Any

RE: sensitive data collection practices with cf

2010-07-30 Thread cfcom
That's an excellent point - thank you Scott -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: 2010-07-30 11:38 To: cf-talk Subject: Re: sensitive data collection practices with cf b) there is an auto email sent to the client's backoffice where the data

RE: sensitive data collection practices with cf

2010-07-30 Thread Robert Harrison
from ESET Smart Security, version of virus signature database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com

Re: SQL Server Data Archival - my solution

2010-07-30 Thread Pete Ruckelshaus
Security, version of virus signature database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe

RE: sensitive data collection practices with cf

2010-07-30 Thread cfcom
database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp

RE: sensitive data collection practices with cf

2010-07-30 Thread Robert Harrison
signature database 5326 (20100730) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael

Re: SOT: SQL Server Data Archival - my solution

2010-07-30 Thread Maureen
you could do this with an ALTER TABLE SQL command, however it will fail if the contents of your text or ntext fields exceeds the capacity of varchar(max) On Fri, Jul 30, 2010 at 7:19 AM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: Unfortunately, as updates to system tables are not allowed

Output newest one item from each category

2010-07-30 Thread Les Mizzell
reasons. I've not been able to exactly get a query of queries to work either. Can someone point me in the correct direction here please? __ Information from ESET NOD32 Antivirus, version of virus signature database 5326 (20100730) __ The message was checked by ESET NOD32

Re: ColdFusion 9 ajax controls

2010-07-30 Thread Scott Stewart
Victor, provided that you use JQuery in no conficts mode they should work together http://docs.jquery.com/Using_jQuery_with_Other_Libraries On Fri, Jul 30, 2010 at 1:16 PM, Victor Moore victor.mo...@gmail.com wrote: Hi, I have two questions: 1. I was wondering if it's possible to use

Re: ColdFusion 9 ajax controls

2010-07-30 Thread Ian Skinner
On 7/30/2010 10:16 AM, Victor Moore wrote: Hi, I have two questions: 1. I was wondering if it's possible to use cflayout witn no borders between regions (like a glorified div structure) Just to let you know cflayout... *IS* a glorified div structure.

ColdFusion 9 ajax controls

2010-07-30 Thread Victor Moore
Hi, I have two questions: 1. I was wondering if it's possible to use cflayout witn no borders between regions (like a glorified div structure) 2. Using cftree is it possible to load tree nodes dynamically (ajax call) when clicking on the parent? Examples will be great. For some reason I find

Re: ColdFusion 9 ajax controls

2010-07-30 Thread Victor Moore
Hi Scott, yes, I know that. I was wondering if it's a good idea to mix them. The advantage with cf ajax control is that you can get some quick functionality relatively easy. The problem is that if you need more customization it's harder to know exactly where to dig. Thanks Victor On Fri, Jul

Re: Need a west coast (US) based CF host

2010-07-30 Thread Peter Amiri
Charlie, If the code can run on Railo, we have shared servers in our LA data center. But then again if the code can run in Railo you could set the time zone for each virtual host separately. ;-) -- Peter Amiri Founder | Alurium Hosting 949-338-3862 | pe...@alurium.com | http://www.alurium.com

RE: ColdFusion 9 ajax controls

2010-07-30 Thread Andrew Scott
Ian, I really hate to burst your bubble but all Ajax controls are either glorified div tags or tables. What did you think they would be? Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Saturday, 31 July 2010