Re: manipulating Excel files

2010-08-31 Thread marc --
I am aware of the POI utility. Would appreciate an answer to my question if possible. I don't think it's as simple as converting from binary to text and back again (as you've discovered). There's no guarantee that there'll be a one-to-one correspondence between the content of the binary file

Re: manipulating Excel files

2010-08-31 Thread marc --
There's no guarantee that there'll be a one-to-one correspondence between the content of the binary file and the content of the text you pull out. Yes, I figure it has to do with the way binary files like Excel are laid out. If it were straight as I supposed I should be able to do the

ODBC (microsoft access) DSN's not working

2010-08-31 Thread Russ Michaels
I am having issues with the Microsoft Access DSN’s on a cf9 server (windows 2000) Here is the original problem I had after upgrading from CF8 to CF9, which as you can see I solved

Re: Git, CF and best practices

2010-08-31 Thread Mallory Woods
Thank you all for the information. I will be reading a lot and trying to make the best decision! On Tue, Aug 31, 2010 at 12:24 AM, Kym Kovan dev-li...@mbcomms.net.auwrote: On 31/08/2010 11:16, Mallory Woods wrote: I just started looking a git to use for source control for our CF

optimizing CFIDE for cfform

2010-08-31 Thread Steve Logan
I'm becoming a little obsessed with that damn YSlow meter trying to wring some more performance out of our web server. My last hangup is the 20 javascript and CSS files that a having a simple cfform and cfwindow causes to load. Is there any tips for reducing that or are all 20 files really

Re: optimizing CFIDE for cfform

2010-08-31 Thread Russ Michaels
The only way to reduc ethat is you use your own solution instead of the built in ones, then you can choose a smaller JS library. However don;t forget that these files are only loaded once and then are cached by the browser. Russ Michaels www.cfmldeveloper.com - FREE cfml hosting for developers

(ot) FTP Servers with DB integration

2010-08-31 Thread Rick Root
Anyone out there have any experience with FTP server software that integrates with a external database for things like authentication and directory access? I need an FTP server where a user can log in using their web site username/password, and based on that information, have their FTP session

Re: ODBC (microsoft access) DSN's not working

2010-08-31 Thread Brian Anderson
I am having issues with the Microsoft Access DSN’s on a cf9 server (windows 2000) Here is the original problem I had after upgrading from CF8 to CF9, which as you can see I solved http://russ.michaels.me.uk/index. cfm/2010/3/5/Mi

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Won Lee
On Tue, Aug 31, 2010 at 10:46 AM, Rick Root rick.r...@gmail.com wrote: Anyone out there have any experience with FTP server software that integrates with a external database for things like authentication and directory access? I need an FTP server where a user can log in using their web

Re: optimizing CFIDE for cfform

2010-08-31 Thread Gerald Guido
The only way to reduc ethat is you use your own solution instead of the built in ones, +1. I am not a fan of CF's Ajax stuff for just that reason. CF form yes. CFForm is only 15k to 30k depending on your version of CF. But once you start getting into the AJAX-y stuff CF seems to use monolithic

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Rick Root
On Tue, Aug 31, 2010 at 10:54 AM, Won Lee won...@gmail.com wrote: Axway.com.  The whole purpose of their Gateway product is for B2B secure file transfer.  We use it to trade files between pharma companies and also to send files to the FDA.  Another, but pricey option, is to setup a point to

cfcontent to serve PDF files hanging

2010-08-31 Thread Jason Fill
Our application uses cfcontent to serve back some PDF files and several times per day, the request for a pdf will just hang, like 300,000 + milliseconds to bring back a PDF that is already created. The code we are using is quite simple and each users file is fully generated before this call

RE: (ot) FTP Servers with DB integration

2010-08-31 Thread Justin Scott
Anyone out there have any experience with FTP server software that integrates with a external database for things like authentication and directory access? Some editions of Serv-U can be set to use ODBC for authentication and user settings (like home directory and folder access, etc.). We've

Re: cfcontent to serve PDF files hanging

2010-08-31 Thread Jake Churchill
The only think I could think of is use application/pdf for the Content-Type (that is technically the correct mime type). -Jake On Tue, Aug 31, 2010 at 10:33 AM, Jason Fill jasonf...@gmail.com wrote: Our application uses cfcontent to serve back some PDF files and several times per day, the

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread JediHomer
Hi, Rather than looking for an FTP that uses a DB backend, how about an FTP server that stores the User accounts as text files, then on User change reset this file... From this http://forum.filezilla-project.org/viewtopic.php?f=6t=11170 it would appear FileZilla Server uses text based user

RE: cfcontent to serve PDF files hanging

2010-08-31 Thread Mark A. Kruger
Good call I think Jake... -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Tuesday, August 31, 2010 11:02 AM To: cf-talk Subject: Re: cfcontent to serve PDF files hanging The only think I could think of is use application/pdf for the Content-Type (that is

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Gerald Guido
We have used GlobalScape EFT Server with success. http://www.cuteftp.com/eft/index.aspx It can authenitcate against Active Directory, LDAP , ODBC (database) and NTLM. The LDAP is only on the Enterprise version. As an added bonus, it has a COM interface that allows you to talk to it with CF. My

RE: cfcontent to serve PDF files hanging

2010-08-31 Thread Mark A. Kruger
ON the other hand... I would expect a mime/type problem to result in an error on the browser - not a hanging request, unless of the course the hanging is the browsers cycling through choices to figure out how to display the file. How may files are in the directory in question? Do you perhaps

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Gerald Guido
We got it to do basically the same thing you are looking to do (and more). Like I said we got it to play nice with CF and got it to do most FTP and administrative operations (Authenticate, create delete Accounts etc.) programatically via the COM based API. HTH G! We have a system where,

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Matthew Williams
You never mentioned the server OS and SQL type? There's a ton of open source FTP daemons that will do this on the linux side, proftpd being one of them. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Order

extend application.cfc based upon condition

2010-08-31 Thread Matthew Smith
Using a shared host, and currently serving several different sites based upon conditional code. I have just done a site in fw/1, and would like to incorporate the site into the codebase. The fw/1 app has this in application.cfc: cfcomponent extends=org.corfield.framework output=false Is there

Re: optimizing CFIDE for cfform

2010-08-31 Thread Peter Boughton
However don;t forget that these files are only loaded once and then are cached by the browser. Not guaranteed in all cases, and also the first impression can be the most important one, so definitely worth looking at a custom solutionm based on jQuery (or other established framework) Also,

Check out this... code....

2010-08-31 Thread Rick Root
Three fun pieces of code I found today while doing some maintenance on code I did not write: #1 - here's what happens when you use varchar fields for numeric data! SELECT SUM(CAST(FLOOR(CAST(OI.ItemQuantity AS float)) AS int) * round(CAST(OI.ItemPrice AS float),2) * ((100-CAST(OI.ItemDiscount

Re: (ot) FTP Servers with DB integration

2010-08-31 Thread Rick Root
On Tue, Aug 31, 2010 at 12:32 PM, Matthew Williams mai...@geodesicgrafx.com wrote:  You never mentioned the server OS and SQL type? In my first message, I devoted an entire paragraph to the OS type :) Windows. In my second message I also mentioned SQL Server, from which you can generally

Re: Check out this... code....

2010-08-31 Thread Bryan Stevenson
Just goes to showpeople will make things work no matter how convoluted the code may become ;-) 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: br...@electricedgesystems.com web:

Re: optimizing CFIDE for cfform

2010-08-31 Thread Raymond Camden
I'm a huge fan of jQuery as well - but remember that for a _lot_ of folks, jQuery is going to be far too difficult. CF's Ajax stuff provide a _super_ easy way to do Ajaxy stuff. :) On Tue, Aug 31, 2010 at 10:13 AM, Gerald Guido gerald.gu...@gmail.com wrote: The only way to reduc ethat is you

Re: optimizing CFIDE for cfform

2010-08-31 Thread Michael Grant
If jQuery is too difficult for a dev I posit that that dev should not be a dev. ;) On Tue, Aug 31, 2010 at 3:17 PM, Raymond Camden rcam...@gmail.com wrote: I'm a huge fan of jQuery as well - but remember that for a _lot_ of folks, jQuery is going to be far too difficult. CF's Ajax stuff

Re: optimizing CFIDE for cfform

2010-08-31 Thread Claude Schnéegans
If jQuery is too difficult for a dev May be too difficult is not the right term, I would say needlessly complex. Personally I do all my Ajax stuff with only two functions, on for method GET, one for a POST. About 40 lines of code, including a function to display a dump in a new window in case

Re: extend application.cfc based upon condition

2010-08-31 Thread Matthew Smith
Ok, here is what I tried: I removed the cfcomponent tags in the org.corfield.framework file, and copied them to a folder. I tried adding this: cfif findnocase(domain.com,request.currentSiteDomain,1) cfinclude template=/fw1/fw1.cfm cfinclude template=/fw1/settings-domain-com.cfm cfelse !---

Re: extend application.cfc based upon condition

2010-08-31 Thread Dave Watts
I removed the cfcomponent tags in the org.corfield.framework file, and copied them to a folder. I tried adding this: cfif findnocase(domain.com,request.currentSiteDomain,1)  cfinclude template=/fw1/fw1.cfm cfinclude template=/fw1/settings-domain-com.cfm cfelse    !--- All my other stuff

Re: Check out this... code....

2010-08-31 Thread Eric Cobb
I'm glad you posted this today, I just found this one a few minutes ago: #Year(DateAdd(, 1, Now()))-1# Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Rick Root wrote: Three fun pieces of code I found today while doing some maintenance on code

RE: Check out this... code....

2010-08-31 Thread Andy Matthews
You're right. The correct version should be: #Year(DateAdd(, 0, Now()))# No need for the -1. andy -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Tuesday, August 31, 2010 4:13 PM To: cf-talk Subject: Re: Check out this... code I'm glad you posted

ORM tables?

2010-08-31 Thread Glyn Jackson
Just want to make sure I am on the right path with my first jump into CF9 ORM. below are two tables. I user can have many monsters assigned to them, and a monster can belong to many users. is there anything wrong with below so far? /** * monsters */ component output=false persistent=true {

RE: Check out this... code....

2010-08-31 Thread Rick Eidson
Must be going through some of my old code... :) I find some shtuff in my own code all the time. Rick -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Tuesday, August 31, 2010 4:25 PM To: cf-talk Subject: RE: Check out this... code You're right.

(ot) Perl Groups

2010-08-31 Thread Duane Boudreau
Hi All, Since many of you out there are multi-talented developers, I was hoping I could ask if anyone is on a similar list for Perl or wouldn't mind answering a Perl question off list? Thanks, DUANE BOUDREAU | SANDY BAY NETWORKS PRESIDENT AND CHIEF TECHNOLOGY OFFICER P: 902.735. x222

Re: Check out this... code....

2010-08-31 Thread Eric Cobb
Exactly! :) Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Andy Matthews wrote: You're right. The correct version should be: #Year(DateAdd(, 0, Now()))# No need for the -1. andy -Original Message- From: Eric Cobb

Re: ODBC (microsoft access) DSN's not working

2010-08-31 Thread Russ Michaels
thanks for the Idea Brian, sadly no dice. And to the other person who asked, yes the unicode driver works. I also just noticed something new. It is only new DSN's (created via the adminapi) that are not working. Existing MSACCESS DSN's are actually still working, they will verify ok from the