Re: Sort by file extension in CFDIRECTORY
It does, unfortunately it doesn't have the file extension as part of the object, so you'll need to add that column to the query object and run through the results separating the file name and filee xtension out to then sort by either column interchangeably. Nick I'd look at putting it into a custom query object and using queries of queries. So loop over the cfdirectory output inserting into a new query object that has file extension as a column and use a call like (filename,listLen(filename,.)-1,.) to retrieve the extension. Once it's stored it's a simple matter of query of queries to sort the results. I'm pretty sure that CFDIRECTORY returns a query object that can directly be sorted using query of queries. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:359047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Invalid Data for Parameter but which one?
thanks guys, bit sounds good! Actually, the error is telling you exactly what is wrong. You are sending a string value of false to a field that only allows a maximum of 1 character. More than likely, you are trying to send a true/false value to a char(1) field. Try either converting your true/false value to 1/0. Also, I do believe that if you use cfqueryparam (which you should be already) and specify the sql type for the field is bit, it will properly convert your true/false values to 1/0 for you. ~| 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:359048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Encrypting Zip File
Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| 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:359049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypting Zip File
Maybe http://www.andyscott.id.au/blog/getting-better-zip-support-in-coldfusion-with-zip4j On Thu, Jul 31, 2014 at 12:18 PM, Richard White rich...@re-base.net wrote: Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| 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:359050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: Encrypting Zip File
In addition to zip4j, you can also look at installing 7Zip (http://www.7-zip.org/) on the server (if possible) and using the CLI interface to that via cfexecute. -- Jeff Original Message From: Richard White rich...@re-base.net Sent: Thursday, July 31, 2014 9:19 AM To: cf-talk cf-talk@houseoffusion.com Subject: Encrypting Zip File Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| 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:359051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypting Zip File
cfzip supports encryption out-of-box I believe zip cfzip required file = absolute pathname One of the following: source = source directory cfzipparam source = source directory ... optional encryptionAlgorithm = standard|AES-128|AES-256 password = password string action = zip filter = file filter overwrite = yes|no prefix = string recurse = yes|no storePath = yes|no Should be able to just put in the encryption algorithm and password and have it taken care of. Nick Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| 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:359052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sort by file extension in CFDIRECTORY
It does, unfortunately it doesn't have the file extension as part of the object, so you'll need to add that column to the query object and run through the results separating the file name and filee xtension out to then sort by either column interchangeably. Good point! Sometimes I forget we can't just use ANSI SQL-92 substring functions in query of queries. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:359053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm