Re: which is better - cfx_image or cfimage?
Cfimage has performance issues and tends to break down under load esp on shared servers. So even if you are not putting it under load, is anyone else? I don't think we have had any issues from customers using cfx_image Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 20 May 2014 04:42, Matthew Smith chedders...@gmail.com wrote: Rather than having the site owner have to create thumbnails for each product, I was planning on having cfimage resize the images as needed. I am having a security issue that support is working on with me. The cfimage only needs to run once so performance is not a huge issue. Looking through the SBA knowledge base, I saw an article on cfx_image. Is this a better solution? My current solution uses a background color that matches the site's, so I am not sure if this is possible with CFX_image. Anyone know? Thanks! ~| 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:358662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: security issue with reading file with cfimage read and write
What is the security issue exactly? Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 20 May 2014 03:19, Matthew Smith chedders...@gmail.com wrote: /Had it working a couple of times but I think I am having pathing issues here and there. NOt sure where I am off... Any help is appreciated... cftry cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1# cfcatch cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/#qry_allItemsInProductKeyList.largepic1# !--- Set the square size of the thumb --- cfset sq_size = 333 !--- Write the result to a file. --- cfset ImageSetAntialiasing(myImage,on) cfset ImageScaleToFit(myImage,sq_size,sq_size) !--- Calculate the x and y position to paste the image --- cfif myImage.width GTE myImage.height cfset x = 0 cfset y = ceiling((myImage.width - myImage.height)/2) cfelse cfset x = ceiling((myImage.height - myImage.width)/2) cfset y = 0 /cfif cfset newimg = ImageNew(,sq_size, sq_size, rgb, c4cba9) cfset ImagePaste(newimg, myImage, x, y) cfset ImageWrite(newimg,/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1#) /cfcatch /cftry ~| 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:358663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: which is better - cfx_image or cfimage?
I have also seen random issues with CFimage in 8 and 9, where it will not load an image due to image format. Things like the color map used for a jpg. Cfx_image seems to be able to handle most conversions more gracefully. Byron Mann Lead Engineer Architect HostMySite.com On May 19, 2014 11:42 PM, Matthew Smith chedders...@gmail.com wrote: Rather than having the site owner have to create thumbnails for each product, I was planning on having cfimage resize the images as needed. I am having a security issue that support is working on with me. The cfimage only needs to run once so performance is not a huge issue. Looking through the SBA knowledge base, I saw an article on cfx_image. Is this a better solution? My current solution uses a background color that matches the site's, so I am not sure if this is possible with CFX_image. Anyone know? Thanks! ~| 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:358664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: security issue with reading file with cfimage read and write
The try catch seems peculiar. If the first CFimage fails and throws an error, things go inside the cfcatch. The first line inside there is the same as the very first, so I would assume you are really getting 2 of the same errors in a row, and not catching the second. I can only see this working, if some code just wrote the original file and is locked on the first try but not the second try when reading the file. Byron Mann Lead Engineer Architect HostMySite.com On May 19, 2014 10:19 PM, Matthew Smith chedders...@gmail.com wrote: /Had it working a couple of times but I think I am having pathing issues here and there. NOt sure where I am off... Any help is appreciated... cftry cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1# cfcatch cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/#qry_allItemsInProductKeyList.largepic1# !--- Set the square size of the thumb --- cfset sq_size = 333 !--- Write the result to a file. --- cfset ImageSetAntialiasing(myImage,on) cfset ImageScaleToFit(myImage,sq_size,sq_size) !--- Calculate the x and y position to paste the image --- cfif myImage.width GTE myImage.height cfset x = 0 cfset y = ceiling((myImage.width - myImage.height)/2) cfelse cfset x = ceiling((myImage.height - myImage.width)/2) cfset y = 0 /cfif cfset newimg = ImageNew(,sq_size, sq_size, rgb, c4cba9) cfset ImagePaste(newimg, myImage, x, y) cfset ImageWrite(newimg,/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1#) /cfcatch /cftry ~| 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:358665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: security issue with reading file with cfimage read and write
The first call is to the ./resize/ directory for the already processed image. If that fails, the source image is read, processed, and saved into the ./resize/ directory. At a glance it seems like this code should work OK. I'm no sure what Matthew's question is either. (As long as allItemsInProductKeyList.largepic1 isn't user-defined that is.) On 5/20/14, 3:22 AM, Byron Mann wrote: The try catch seems peculiar. If the first CFimage fails and throws an error, things go inside the cfcatch. The first line inside there is the same as the very first, so I would assume you are really getting 2 of the same errors in a row, and not catching the second. I can only see this working, if some code just wrote the original file and is locked on the first try but not the second try when reading the file. Byron Mann Lead Engineer Architect HostMySite.com On May 19, 2014 10:19 PM, Matthew Smith chedders...@gmail.com wrote: /Had it working a couple of times but I think I am having pathing issues here and there. NOt sure where I am off... Any help is appreciated... cftry cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1# cfcatch cfimage action=read name=myImage source=/site_theartoflovingcatsanddogs_com/taolcad_images/products/#qry_allItemsInProductKeyList.largepic1# !--- Set the square size of the thumb --- cfset sq_size = 333 !--- Write the result to a file. --- cfset ImageSetAntialiasing(myImage,on) cfset ImageScaleToFit(myImage,sq_size,sq_size) !--- Calculate the x and y position to paste the image --- cfif myImage.width GTE myImage.height cfset x = 0 cfset y = ceiling((myImage.width - myImage.height)/2) cfelse cfset x = ceiling((myImage.height - myImage.width)/2) cfset y = 0 /cfif cfset newimg = ImageNew(,sq_size, sq_size, rgb, c4cba9) cfset ImagePaste(newimg, myImage, x, y) cfset ImageWrite(newimg,/site_theartoflovingcatsanddogs_com/taolcad_images/products/resize/#qry_allItemsInProductKeyList.largepic1#) /cfcatch /cftry ~| 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:358666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue with cfspreadsheet
Hi All - I am creating multiple sheets of data using cfspreadsheet and using the script here http://cfsimplicity.com/16/forcing-values-to-be-inserted-into-spreadsheets-as-textto force few columns to be treated as text. The issue I am facing is, when number of records for all the sheets combined reaches few thousands, the columns I am using for text formatting are automatically getting bolded font and gray background. I was wondering if anyone has faced this issue and if there is a way to fix this? Below is the code cfset REQUEST.gen_Excel = spreadsheetNew(Sheet1,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet1) cfscript REQUEST.gen_Excel= spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query1, columnNumbersToFormatAsText=[1,3,4,5], addedHeaderRow=true ); /cfscript cfset REQUEST.gen_Excel = spreadsheetNew(Sheet2,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet2) cfscript REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query1, columnNumbersToFormatAsText=[1,3,4,5], addedHeaderRow=true ); /cfscript cfset REQUEST.gen_Excel = spreadsheetNew(Sheet3,true) cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet3) cfscript REQUEST.gen_Excel = spreadsheetAddRowsForceTextFormat ( spreadsheetObject=REQUEST.gen_Excel, data=query3, columnNumbersToFormatAsText=[1,3,4], addedHeaderRow=true ); /cfscript cfset spreadsheetsetActiveSheet(REQUEST.gen_Excel,Sheet1) ~| 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:358667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
I'm running into issues with this and the new CF11. The same server has CF9 on it and it's a Windows 2008 R2 system so I had already worked though getting the Access files working in a 64bit environment by using the 32bit ODBC to add them before adding them in CF. However now in CF11 when I try to add them I always get the The ColdFusion ODBC Server service is not running or has not been installed. You may also use the 'MS Access with Unicode' driver to connect to MS Access datasources. error. So I went through all the suggestions found here and none of them have worked. I checked the ODBC Server Agent services exist and are running. There are no system log or CF log entries from them. I shut down the CF9 ODBC services just in case they were conflicting then restarted CF11. I deleted the trace files. I can successfully add and use MS-SQL datasources though. ~| 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:358668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
I'm running into issues with this and the new CF11. The same server has CF9 on it and it's a Windows 2008 R2 system so I had already worked though getting the Access files working in a 64bit environment by using the 32bit ODBC to add them before adding them in CF. However now in CF11 when I try to add them I always get the The ColdFusion ODBC Server service is not running or has not been installed. You may also use the 'MS Access with Unicode' driver to connect to MS Access datasources. error. So I went through all the suggestions found here and none of them have worked. I checked the ODBC Server Agent services exist and are running. There are no system log or CF log entries from them. I shut down the CF9 ODBC services just in case they were conflicting then restarted CF11. I deleted the trace files. I can successfully add and use MS-SQL datasources though. It turns out my issue is actually a bug in CF11. https://bugbase.adobe.com/index.cfm?event=bugid=3759846 If you had CF10 installed then install CF11 the system will only use the CF10 ODBC services and not the CF11 ones. We had installed CF10 but it's disabled now. ~| 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:358669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
not the first time they have done that either, had the same issue with a previous version of cf as well. On Tue, May 20, 2014 at 5:52 PM, Leith Tussing ltuss...@ist.ucf.edu wrote: I'm running into issues with this and the new CF11. The same server has CF9 on it and it's a Windows 2008 R2 system so I had already worked though getting the Access files working in a 64bit environment by using the 32bit ODBC to add them before adding them in CF. However now in CF11 when I try to add them I always get the The ColdFusion ODBC Server service is not running or has not been installed. You may also use the 'MS Access with Unicode' driver to connect to MS Access datasources. error. So I went through all the suggestions found here and none of them have worked. I checked the ODBC Server Agent services exist and are running. There are no system log or CF log entries from them. I shut down the CF9 ODBC services just in case they were conflicting then restarted CF11. I deleted the trace files. I can successfully add and use MS-SQL datasources though. It turns out my issue is actually a bug in CF11. https://bugbase.adobe.com/index.cfm?event=bugid=3759846 If you had CF10 installed then install CF11 the system will only use the CF10 ODBC services and not the CF11 ones. We had installed CF10 but it's disabled now. ~| 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:358670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfqueryparam to varchar raw problem
I may be outside of the CF bounds here, but this problem wasn't showing up until we added CFQueryParams. We are in CF9. I am adding CFQueryparams to an INSERT. The item that I am sending over to the oracle 11g db is empty text. The CFQueryParam is varchar because I am sending it over as text. From there, it is encrypted and a Cast_to_RAW is done on it to be put in a RAW field. This is failing with an invalid hex number error. Overall, I don't receive the error consistently. However, I haven't been able to reproduce this without the CFQueryparam. Any thoughts on this? Or any clarification questions? ~| 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:358671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
On the whole, posting the code rather than describing the code is more helpful in these situations. The before and after versions might be helpful too. Did anything other than the usage of cfqueryparam change? -- Adam On 20 May 2014 20:01, daniel kessler dani...@umd.edu wrote: I may be outside of the CF bounds here, but this problem wasn't showing up until we added CFQueryParams. We are in CF9. I am adding CFQueryparams to an INSERT. The item that I am sending over to the oracle 11g db is empty text. The CFQueryParam is varchar because I am sending it over as text. From there, it is encrypted and a Cast_to_RAW is done on it to be put in a RAW field. This is failing with an invalid hex number error. Overall, I don't receive the error consistently. However, I haven't been able to reproduce this without the CFQueryparam. Any thoughts on this? Or any clarification questions? ~| 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:358672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm