RE: cfftp with SSL (Coldfusion 8)
Neither CF8 or CF9 support SFTP using CFFTP. However, like Russ mentioned, you can use some java libraries as an alternative. One project I worked on that required connecting to an sftp server we used the apache commons-net library (commons.apache.org/net) and it worked like a charm. Not nearly as simple as a cfftp tag, but once I got it working, it's been rock solid. Being an apache project, their documentation is pretty good, although geared towards a java dev, so you'll have to translate it into your cf code. Good luck! James ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
QoQ DataType Error
Hey all, got a brain buster for you: I have a query object "result" that I'm building out in a function. I've defined all my query column datatypes. The problem is that for one column, the datatype is varchar, but the data in this particular instance is all numeric, save 1 row that is an empty string. Note: The data being all numeric is coincidental. The field is user-defined data, which is why it was declared a varchar field. When I do a query of queries on "result", I get an error thrown saying "The value '' cannot be converted to a number". Double checked myself by dumping getMetaData(result), and sure enough, the column data type is varchar. Even doing SELECT * FROMresult Throws the same error! I know ColdFusion is seeing all the numeric values, and casting it as a numeric variable behind the scenes, but this is NOT what I want it to do. How can I get the blasted QoQ to work without throwing the error?!? James Davis Software Engineer Kaleida Systems, Inc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFEclipse with Aptana
Pete, Make sure you check the "Show Line Numbers" under the CFEclipse options. That threw me off when i first started using it. In the Preferences, it's under CFEclipse>Editor. If you're just checking under General>Editors>Text Editors, that "Show Line Numbers" option will not show line numbers in CFM pages. James Davis Kaleida Systems From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Sat 2/2/2008 9:38 AM To: CF-Talk Subject: CFEclipse with Aptana I've been using Aptana (http://www.aptana.org/) with my students in my web design class (I teach in a public school district and didn't inherit any budget for software, Aptana is both free and very very good). I've actually grown to prefer it over HomeSite+ for HTML, JS, and CSS; it's based on Eclipse, so you can install Eclipse plug-ins -- including cfeclipse -- with no problem. The only thing that's keeping me from using it for all of my ColdFusion development is that for some reason, I can't get line numbers to show when editing CFM files, and the "show line numbers" setting in the settings applet won't save the setting. Has anyone else encountered this issue, and if so, is there a fix? Thanks, Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297993 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF Support with CF8 - Can this be done?
Sorry..typo writing my email. Might be a case of the Mondays? :) Yes, I used action="merge", NOT action="mArge". Any other ideas? James Davis Software Engineer Kaleida Systems, Inc. -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 1:15 PM To: CF-Talk Subject: Re: PDF Support with CF8 - Can this be done? Did you try action="merge"? :) On Nov 5, 2007 12:15 PM, James Davis <[EMAIL PROTECTED]> wrote: > I'm trying to do something similar as well, but trying to merge database > content into a PDF form then generate 1 large PDF with multiple pages. > > Is this possible with the new tags? When I tried using cfpdfform > action="marge" on a directory of PDF's. They were all blank. > > James Davis > Software Engineer > Kaleida Systems, Inc. > ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF Support with CF8 - Can this be done?
I'm trying to do something similar as well, but trying to merge database content into a PDF form then generate 1 large PDF with multiple pages. Is this possible with the new tags? When I tried using cfpdfform action="marge" on a directory of PDF's. They were all blank. James Davis Software Engineer Kaleida Systems, Inc. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 02, 2007 1:38 PM To: CF-Talk Subject: Re: PDF Support with CF8 - Can this be done? Yes, CF8 can do what you need to do very easily. Damon >What I need to do is take information posted from a web form and merge it >into an existing PDF with place holders >and then save the file and email it as an attachement. > >Can CF 8 do the PDF portion natively? ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Archiving SQL table data
We're using SQL Server 2000 on a Quad Xeon 3.2 Ghz Processor w/3 GB RAM. I always lean towards proper indexing, however I'm looking to convince the higher-ups that this Archive Solution is not necessary and won't have a positive impact on performance. James Davis Software Engineer Kaleida Systems, Inc. -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 4:10 PM To: CF-Talk Subject: Re: Archiving SQL table data What database are you using? Any enterprise DBMS is built to handle millions of records. If its running on decent hardware there should be no problem. Given your scenario, there seems to be no reason to worry about archiving your data into other tables. 20k-40k records is nothing. Steve -Original Message----- From: "James Davis" <[EMAIL PROTECTED]> Sent 9/21/2007 4:00:26 PM To: "CF-Talk" Subject: Archiving SQL table dataIn general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the "archived" tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Archiving SQL table data
In general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the "archived" tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java Database Queries in ColdFusion
Thanks Dave. That was exactly the problem. I added the path to my database driver jar file to coldfusion and worked like a charm. James Davis Kaleida Systems, Inc. [EMAIL PROTECTED] -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 17, 2006 1:23 PM To: CF-Talk Subject: RE: Java Database Queries in ColdFusion > I have a Java object that runs a routine on our database (MSSQL). The > routine does financial calculations based on selection queries and > then inserts these calculated values back into the database. > > When I run the Java manually through a java stub program, I can see > the hits on the database via SQL Profiler, so I know that the java is > talking with the database fine. Presumably, your Java program uses JDBC to invoke a database driver, etc. When you run it by itself, presumably that database driver is in the classpath and can be found by your program. When you run your program from within CF, however, it probably won't be able to find or use it. It would be easier, generally, to let CF handle your data retrieval, and simply perform your calculations in your Java class. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Java Database Queries in ColdFusion
Here's my dilemma: I have a Java object that runs a routine on our database (MSSQL). The routine does financial calculations based on selection queries and then inserts these calculated values back into the database. When I run the Java manually through a java stub program, I can see the hits on the database via SQL Profiler, so I know that the java is talking with the database fine. However, when I put the java object in a ColdFusion program and run it, nothing. SQL Profiler doesn't show a hit on the database. ColdFusion does not display an error. I know the java object is being correctly instantiated since I can call other methods in the object that do not require information from the database, and it returns the correct values. Here's the CF code: #ret.getRegionID()# #ret.getClosureNo()# #ret.getNewClaimCount()# I want to use the Java object since Java will handle financial calculations better than ColdFusion, and a Stored Procedure (which is how it is currently done in our production code) puts too much of a processing load on the database server, effecting performance. Any thoughts? Anybody ran into this before? Any help is much appreciated. James Davis Kaleida Systems, Inc. [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
