Re: Creating COM object - troubleshooting
You are right Eric, the 64bit DLL did not work either. Regards, Stefan On 18 Apr 2011, at 22:07, Eric Roberts wrote: We tried that route Stephan...even a 64 bit dll never worked. You can use a .NET object or a JAVA object, but no COM. Again it is has something to do with how MS is depreciating COM in favor of .NET. -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Monday, April 18, 2011 14:12 To: cf-talk Subject: Re: Creating COM object - troubleshooting Thanks, Sounds like the best way forward is to ask the vendor for a 64bit dll... Thanks again, at least I can stop trying now :-) Cheers Stefan On 18 Apr 2011, at 18:48, Dave Watts wrote: I also tried using a tag based syntax specifying the DLL directly: cfobject type=.NET name=aca class=ACAWebThumb.ThumbMaker assembly=C:\Program Files (x86)\ACASystems\ACA WebThumb ActiveX Control\acawebthumb.dll Error: Class ACAWebThumb.ThumbMaker not found in the specified assembly list. The assembly that contains the class must be provided to the assembly attribute. This is a 32-bit .NET assembly. You can tell because it's installed in Program Files (x86) rather than just Program Files. You can only use this from a 32-bit version of CF. Fortunately, you can easily install 32-bit CF on a 64-bit Windows machine, but you'll have to configure the IIS application pool to also be 32-bit. Unfortunately, you lose all the 64-bit advantages when you do this, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ ~| 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:343837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
I'm showing my newbie-ness here but would Java offer a way out of this problem? The vendor offers JAva examples (http://www.acasystems.com/en/web-thumb-activex/faq-convert-html-to-image-in-java.htm) and I'm wondering if it would be (easily?) possible to compile a JAR that exposes the relevant functions of the DLL? Regards, Stefan On 18 Apr 2011, at 23:23, Dave Watts wrote: Again it is has something to do with how MS is depreciating COM in favor of .NET. Well, this is kind of true, but not entirely true. CF uses a third-party Java-COM library from JIntegra. They don't make a 64-bit version of their library. There's nothing (that I know of) stopping them from doing that right now, but you're correct that COM is basically a dead-end - so it makes financial sense for JIntegra not to pursue this. Dave Watts, CTO, Fig Leaf Software 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:343838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
if it is critical for you to use this COM object, then here is one suggestion. Install CF 32 bit on the server as well, and just have one folder on your server set to use the 32bit connectors just so you can use your COM object. On Tue, Apr 19, 2011 at 9:06 AM, Stefan Richter ste...@flashcomguru.comwrote: I'm showing my newbie-ness here but would Java offer a way out of this problem? The vendor offers JAva examples ( http://www.acasystems.com/en/web-thumb-activex/faq-convert-html-to-image-in-java.htm) and I'm wondering if it would be (easily?) possible to compile a JAR that exposes the relevant functions of the DLL? Regards, Stefan On 18 Apr 2011, at 23:23, Dave Watts wrote: Again it is has something to do with how MS is depreciating COM in favor of .NET. Well, this is kind of true, but not entirely true. CF uses a third-party Java-COM library from JIntegra. They don't make a 64-bit version of their library. There's nothing (that I know of) stopping them from doing that right now, but you're correct that COM is basically a dead-end - so it makes financial sense for JIntegra not to pursue this. Dave Watts, CTO, Fig Leaf Software 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:343839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? -Original Message- From: Matt Quackenbush Sent: Tuesday, April 19, 2011 12:20 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness Wild guess: Firebug is turned on and is adding a second click to the flow. ~| 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:343840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
Thanks, It's not totally critical - right now I am using PHP for this one task. Not ideal but it works. Since I am working on bundling all the separate remote files for this Flex app into one CFC it would have been neat to get this one in there as well. Regards, Stefan On 19 Apr 2011, at 11:42, Russ Michaels wrote: if it is critical for you to use this COM object, then here is one suggestion. Install CF 32 bit on the server as well, and just have one folder on your server set to use the 32bit connectors just so you can use your COM object. On Tue, Apr 19, 2011 at 9:06 AM, Stefan Richter ste...@flashcomguru.comwrote: I'm showing my newbie-ness here but would Java offer a way out of this problem? The vendor offers JAva examples ( http://www.acasystems.com/en/web-thumb-activex/faq-convert-html-to-image-in-java.htm) and I'm wondering if it would be (easily?) possible to compile a JAR that exposes the relevant functions of the DLL? Regards, Stefan ~| 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:343841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote: I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? in that case turn it on and look at what the browser is sending... -- Yours, Kym Kovan mbcomms.net.au ~| 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:343842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
Hi Jenny, Thanks for you reply. Apologies for not answering sooner, as I could not connect to houseoffusion.com last Friday (15/4/2011) for some technical reason. No, I have not thought about VPN. Would that allow an upload of up to 50 GB data from UK and downloaded from another European country securely and reliably? What VPN product do I need to consider? Any pointers will be appreciated. Many Thanks, Kamru -- Have you thought of using a VPN? Jenny ~| 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:343843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Writing transparent gifs makes them grey
Hi all, I'm fetching images from a remote URL via CFHTTP. You can see an example here: http://latex.codecogs.com/gif.latex?\LARGE%20a%20+%20b If you open this in a browser and drag te image to your desktop you will notice a transparent background. However when I do the following cfset latexURL = http://latex.codecogs.com/gif.latex?\LARGE; cfhttp url=#latexURL# a + b getasbinary=yes method=get/cfhttp cfset tempimagename = #CreateUUID()#.gif cfimage action = write destination = #Expandpath('./')#/#tempimagename# source = #cfhttp.FileContent# overwrite=true and then open the resulting image, the background color of the gif is a very light grey. Ideally I'd like it to be white, however I do not understand why it's not transparent, but grey instead. My goal: write the gif with white or transparent background, but not grey. Any ideas? Regards, Stefan ~| 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:343844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
is this sharing of files a regular occurrence or a one time thing ? either way you don't need to reinvent this wheel If you regularly do this then a much better solution would be something like SugarSync, we have been using this for ages and it works great, and best of all it is FREE, they do not even stop you going your quota, they just don't backup any data that over http://bit.ly/ffSiND Here is a bunch of other similar solutions http://techcrunch.com/2009/08/08/16-apps-that-make-sharing-large-files-a-snap/ You could also just stick the file on your server and provide FTP access to download it. You may want to consider breaking the file down into smaller parts though, as 50GB is a hefty download. On Tue, Apr 19, 2011 at 12:19 PM, Kamru Miah k.m...@csl.gov.uk wrote: Hi Jenny, Thanks for you reply. Apologies for not answering sooner, as I could not connect to houseoffusion.com last Friday (15/4/2011) for some technical reason. No, I have not thought about VPN. Would that allow an upload of up to 50 GB data from UK and downloaded from another European country securely and reliably? What VPN product do I need to consider? Any pointers will be appreciated. Many Thanks, Kamru -- Have you thought of using a VPN? Jenny ~| 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:343845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinvoke in a CFfunction in a CFC
Your method isn't written correctly. You don't use cfparam to define arguments, but use the cfargument tag instead. Check the docs for the reference, but basically it is cfargument name=name of argument required='true or false and more args On Mon, Apr 18, 2011 at 5:35 PM, Adam Bourg adam.bo...@gmail.com wrote: I've got this form for a user to submit an employment application, I basically create an instance of our CFC as an object. From there I call some method to clean up the data and prevent SQL injection attacks. In this CFC I have a method called: MapFormData, basically it cleans the data, then calls a method to insert the name, email address etc (the generic information) into the database and return the row ID. This behaves perfectly. After that I have CFinvoke, that passes in arguments (Using cfinvokeargument). The method is really big but here it is. Basically what is happening in the Database, nothing but the default values are being inserted, I can change the invokeargs and still nothing changes. Any ideas? Method that does calls: !--- Takes the instance veriables, maps them to the methods to insert the data after validation --- cffunction name=MapFormData access=public returntype=void output=no hint=Maps the data to the method requried to create each unqiue row !--- Sanitize the string properties --- cfset Sanitize() / ~| 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:343846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
Could you not just upload the files using sftp and require an ssh connection to download them? That is really what ftp was designed for. HTTP was never really designed to transmit that large of a file anyway. This would accomplish both of your requirements, in that you would be uploading them securely in the UK and then they would be downloaded securely from any place else. It will also not bring your web server to it's knees like serving up multiple 50GB requests would. Dean On Tue, Apr 19, 2011 at 7:19 AM, Kamru Miah k.m...@csl.gov.uk wrote: Hi Jenny, Thanks for you reply. Apologies for not answering sooner, as I could not connect to houseoffusion.com last Friday (15/4/2011) for some technical reason. No, I have not thought about VPN. Would that allow an upload of up to 50 GB data from UK and downloaded from another European country securely and reliably? What VPN product do I need to consider? Any pointers will be appreciated. Many Thanks, Kamru -- Have you thought of using a VPN? Jenny ~| 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:343847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating COM object - troubleshooting
I'm showing my newbie-ness here but would Java offer a way out of this problem? The vendor offers JAva examples (http://www.acasystems.com/en/web-thumb-activex/faq-convert-html-to-image-in-java.htm) and I'm wondering if it would be (easily?) possible to compile a JAR that exposes the relevant functions of the DLL? You're not really showing any newbie-ness here, most CF programmers never have to worry about this kind of stuff. My guess is that this could work if you could compile Snap.cpp with a 64-bit compiler. However, that basically moves your problem from Java to C++. I don't know enough about C++ on Windows to definitively answer that question. http://www.dnjonline.com/article.aspx?id=jun07_access3264 I don't think that you can invoke a 32-bit native program from a 64-bit JVM JNI call. Honestly, my final recommendation would be to look for an alternative to this library that's written in Java. Dave Watts, CTO, Fig Leaf Software 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:343848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Creating COM object - troubleshooting
Here are the cfcs we developed based off of code originally developed by ben Nadel...some of the modification ideas were based off another site as well and I am drawing a complete blank, at the moment, who that blogger was...so if you remember the convo we had, please pop up ;-) Banner.cfc has some of the functions in imageUtils...tweaked a bit so as to work abit more efficiently. Some of the simpler functions can be replicated using the cfimage tag directly. !---Begin ImageUtils.cfc--- !--- Modified code developed by Eric Roberts based off of code originally developed by Ben Nadel --- cfcomponent output=false hint=Image utility functions that abstract out complex ColdFusion image manipulation processes. cffunction name=Init access=public returntype=any output=false hint=Returns an initialized component. !--- Return This reference. --- cfreturn THIS / /cffunction !--- Function: aspectCrop Author: Emmet McGovern http://www.illequipped.com/blog em...@fullcitymedia.com 2/29/2008 - Leap Day! --- cffunction name=aspectCrop access=public returntype=any output=false hint= !--- Define arguments. --- cfargument name=image type=any required=true hint=The ColdFusion image object or path to an image file. / cfargument name=cropwidth type=numeric required=true hint=The pixel width of the final cropped image / cfargument name=cropheight type=numeric required=true hint=The pixel height of the final cropped image / cfargument name=position type=string required=true default=center hint=The y origin of the crop area. / !--- Define local variables. --- cfset var nPercent = / cfset var wPercent = / cfset var hPercent = / cfset var px = / cfset var ycrop = / cfset var xcrop = / !--- If not image, assume path. --- cfif ( (NOT isImage(arguments.image)) AND (NOT isImageFile(arguments.image)) ) cfthrow message=The value passed to aspectCrop was not an image. / /cfif !--- If we were given a path to an image, read the image into a ColdFusion image object. --- cfif isImageFile(arguments.image) cfset arguments.image = imageRead(arguments.image) / /cfif !--- Resize image without going over crop dimensions--- cfset wPercent = arguments.cropwidth / arguments.image.width cfset hPercent = arguments.cropheight / arguments.image.height cfif wPercent gt hPercent cfset nPercent = wPercent cfset px = arguments.image.width * nPercent + 1 cfset ycrop = ((arguments.image.height - arguments.cropheight)/2) cfset imageResize(arguments.image,px,) / cfelse cfset nPercent = hPercent cfset px = arguments.image.height * nPercent + 1 cfset xcrop = ((arguments.image.width - arguments.cropwidth)/2) cfset imageResize(arguments.image,,px) / /cfif !--- Set the xy offset for cropping, if not provided defaults to center --- cfif listfindnocase(topleft,left,bottomleft, arguments.position) cfset xcrop = 0 cfelseif listfindnocase(topcenter,center,bottomcenter, arguments.position) cfset xcrop = (arguments.image.width - arguments.cropwidth)/2 cfelseif listfindnocase(topright,right,bottomright, arguments.position) cfset xcrop = arguments.image.width - arguments.cropwidth cfelse cfset xcrop = (arguments.image.width - arguments.cropwidth)/2 /cfif cfif listfindnocase(topleft,topcenter,topright, arguments.position) cfset ycrop = 0 cfelseif listfindnocase(left,center,right, arguments.position) cfset ycrop = (arguments.image.height - arguments.cropheight)/2 cfelseif listfindnocase(bottomleft,bottomcenter,bottomright, arguments.position) cfset ycrop = arguments.image.height - arguments.cropheight cfelse cfset ycrop = (arguments.image.height - arguments.cropheight)/2 /cfif !---
Re: Any secure data transfer methods avaiable for very large files?
Hi Russ, Thanks for your suggestions. The secure file transfer requirement is a regular occurrence for multiple users. I had a look at the SugarSync file upload service and it is only free for up to 5GB for a single user. I have asked the vendor to supply more information for my requirement. The other solutions are limited to much small file sizes then SugarSync. Regards, Kamru ~| 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:343850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
Hi Dean, The SFTP and SSH methods you suggested sounds very promising. Is there any products or Coldfusion code example to handle up to 50 GB files available anywhere? Thanks, Kamru ~| 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:343851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
It would a bad idea to try and deliver such big files over CF. A file of that size would take a very long time to download, and the likelihood of the http connection being lost is very high, which means users will need to keep trying to download from scratch, as has been stated, http is not really intended for this. As I suggested previously you could use FTP which would be a much better method as downloads can be resumed. You can provide your users with an FTP link from a webpage, if you need to generate a unique ftp login for each user then this can be done via CF as well using an FTP server with an API, such as gene6 FTP or Filezilla. On Tue, Apr 19, 2011 at 5:32 PM, Kamru Miah k.m...@csl.gov.uk wrote: Hi Dean, The SFTP and SSH methods you suggested sounds very promising. Is there any products or Coldfusion code example to handle up to 50 GB files available anywhere? Thanks, Kamru ~| 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:343852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
Kamru, SFTP is simply ftp over an SSH connection. So what you need is to have SSH running on your ftp server. If you are using Windows, I like ServU-FTP server as it has an SSH server built into it. It is a commercial product though and is Windows only. If you want to go free, OpenSSH is a free SSH Server product if you need one (http://www.openssh.com/) and runs on multiple platforms. Russ mentioned Filezilla, which is a good free ftp server option. The last thing that your users will need is an ftp client that supports SSH connections. Most commercial ftp clients do and there are numerous free ones as well. On Tue, Apr 19, 2011 at 12:32 PM, Kamru Miah k.m...@csl.gov.uk wrote: Hi Dean, The SFTP and SSH methods you suggested sounds very promising. Is there any products or Coldfusion code example to handle up to 50 GB files available anywhere? Thanks, Kamru ~| 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:343853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Any secure data transfer methods avaiable for very large files?
On Tue, Apr 19, 2011 at 12:32 PM, Kamru Miah k.m...@csl.gov.uk wrote: Is there any products or Coldfusion code example to handle up to 50 GB files available anywhere? ColdFusion (or any other web scripting language) is not the proper solution for this problem. It's not even worth trying. It's like asking how many men it takes to throw a two ton boulder over a wall when a perfectly good catapult is sitting there beside you. The men might be able to eventually do it, but just use the catapult. Investigate the SFTP/SSH/VPN/etc solutions instead. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: cameronc@gmail. ~| 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:343854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing transparent gifs makes them grey
Did you try saving it directly to a file via cfhttp? ie Using the path and file attributes? ~| 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:343855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing transparent gifs makes them grey
Cfimage has issues with gif files. Any chance of trying png files instead? -Sent from my Droid On Apr 19, 2011 5:30 PM, Leigh cfsearch...@yahoo.com wrote: Did you try saving it directly to a file via cfhttp? ie Using the path and file attributes? ~| 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:343856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Writing transparent gifs makes them grey
Cfimage has issues with gif files. Any chance of trying png files instead? Saving the image with cfhttp would avoid cfimage altogether. ~| 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:343857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFQUERY update Firefox wierdness
Kym, I figured out what was causing the page to load twice. Within my page I had an abandon background-image:url(); within one of my style tags. Once I removed it everything is working correctly with Firefox on all machines. I guess Firefox tries to fetch the url() and since it's not referring to a url it reloads the same page. This was driving me crazy. Dan -Original Message- From: Kym Kovan Sent: Tuesday, April 19, 2011 7:23 AM To: cf-talk Subject: Re: CFQUERY update Firefox wierdness On 19/04/2011 8:46 PM, Dan Blickensderfer wrote: I checked and it's turned off. This is happening from multiple computers with Firefox. Any other thoughts? in that case turn it on and look at what the browser is sending... -- Yours, Kym Kovan mbcomms.net.au ~| 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:343858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Real head Scratcher
Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? Here's the verbose error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#arguments.photographerid# / 322 : /cfquery 323 : cfreturn qPhotographer / SQLSTATE HY000 SQLSELECT * FROM ipi_photographers WHERE id = (param 1) DATASOURCEphotoeyecom Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 Remote Address 10.10.47.254 Referrer Date/Time 20-Apr-11 01:08 AM Stack Trace at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162) at cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63) at cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:54) at cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1) at cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210) at cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5) at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
Re: Real head Scratcher
Bad data. You have at least one data record with a value that is either null or not an integer. On Tue, Apr 19, 2011 at 10:04 PM, Richard Steele r...@photoeye.com wrote: Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? ~| 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:343860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MySQL Conversion
Oy -- I shouldn't have started this one until the weekend. I'm converting from MS Access to MySQL on one of my ColdFusion sites, and having problems converting my Autonumbered Access tables to MySQL format. They just won't import at all. If I remove the primary key and change the format to Integer instead of Autonumber, the tables import. The real problem is when I try to add data to these tables later. It will take one additional record (numbering it 0), then won't take anymore because then there would be two 0s. How can I get a MySQL table to autonumber like Access? Scott ~| 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:343861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm