Re: Server slowly dying - Possibly a memory leak --- CF7, MS SQL Server 2005 Express

2009-02-27 Thread Dan Baughman
I've ran a ton of fairly high volume sites and cf7 really seems to have a problem releasing worker threads that are database connection intensive when its really getting nailed. Cf8 has *much* less trouble with sites of the same volume on the same hardware. I'm not talking page load times I'm ta

Re: Semi-OT: SQL question...Select first item for each person for each day

2009-02-24 Thread Dan Baughman
Isn't this way easier and executes way faster? select * from appointment left join ( select patient_id, min(appointment_date) as firstAppt, datepart(yy,appointment_date), datepart(dd,appointment_date), datepart(mm,appointment_date) from appointment group by p

Re: Mailing Label Solutions

2009-02-23 Thread Dan Baughman
Unfortunately in this case the client specifies the label sheets and I just build the reports and they are full sheet stuff.. probably from an ink printer. I've the Dymo's before though. I used CSS and print features to get them to come out alright.. but not great. I happened across this REALLY

CFFTP - Secure connection

2008-03-04 Thread Dan Baughman
OK- Coldfusion 8 uses JSCH as well as the old tag for 7 did. so the same, mis-spelt error mesage lingers in Coldfusion 8 as in 7 with the user-built CFC(cfsftp)... "invaid privatekey: c:\id_dsa.ppk " Does anyone know what file format the private key is expected to be in? Is it it still usable i

SFTP

2008-03-04 Thread Dan Baughman
Hello List, I have an ftp server I'm using WinSCP to connect to. I have a ppk file and I can move it from one computer to another and connect via WinSCP with no issue. I'd very much like to use coldfusion to somehow connect to this server via what I believe to be key authentication and upload file

<    1   2