CF 9.0.1 stops accepting/processing HTTP requests after DB connection failure
Hi all, I'm posting here in the hope that this list can shed some light on an issue I keep encountering with CF 9.0.1 running on Windows Server 2008 R2. My CF instance sometimes stops responding to and/or properly process HTTP requests. When this happens I see the following symptoms: - my monitoring software reports HTTP failure, 'Unable to contact web server at website.com/index.cfm' - Pingdom reports website as down - the CF service is running seemingly normally - another non-CF site on the same server works fine (more or less eliminating IIS as a cause) - a server restart will fix the issue (temporarily until the next 'event') - A CF service restart often hangs so I end up rebooting the server - (potentially unrelated: the CF service does not start up after server reboot even though it is set to automatic, a manual start of the service works) Last night at 00:20am UTC another outage occurred. This time I could tie it to an external event. At precisely that time, Amazon Web Services performed a planned update to their RDS service (MySQL basically) which CF connects to as a datasource. Note that I run RDS in multi-AZ mode which means that when the database shuts down for any reason it fails over to another instance with identical credentials. However it appears CF was never able to reconnect, not even when the original DB came back a few mins later. Moreover not only did the DB connection fail, but CF also stopped processing HTTP requests - no pages (even those without cfquery tags) would load (well they may have done, but see below for how long they suddenly take to process). I noticed in my CF logs: server.log (hundreds of these entries right after the DB connection failed): Warning,jrpp-25682,11/18/12,00:28:08,,Thread: jrpp-25682, processing template: C:\inetpub\wwwroot\scribblar.com\...\index.cfm, completed in 314 seconds, exceeding the 30 second warning limit application.log Error,jrpp-25680,11/18/12,00:19:54,scribblar,Error Executing Database Query.Server shutdown in progress The specific sequence of files included or processed is: C:\inetpub\wwwroot\page.cfm Error,jrpp-25678,11/18/12,00:20:05,scribblar,Error Executing Database Query.Communications link failure The last packet successfully received from the server was 53,418 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. The specific sequence of files included or processed is: C:\inetpub\wwwroot\...page.cfm Error,jrpp-25682,11/18/12,00:21:29,scribblar,Error Executing Database Query.Could not create connection to database server. Attempted reconnect 3 times. Giving up. [these logs then repeat a lot of times] (notice the pages in the server.lo0g take forever to load - to a user they don't work at all as noone waits 5 mins...) Every single page requests after the original 'Error Executing Database' takes several minutes according to the logs. exception.log: (loads of these, I picked one as a sample) Error,jrpp-25779,11/18/12,07:57:02,scribblar,Error Executing Database Query.Could not create connection to database server. Attempted reconnect 3 times. Giving up. The specific sequence of files included or processed is: C:\inetpub\wwwroot\...\index.cfm, line: 8 coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfindex2ecfm507991868.runPage(C:\inetpub\wwwroot\...\index.cfm:8) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:360) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at
CF 9.0.1 stops accepting/processing HTTP requests after DB connection failure
Hi all, I'm posting here in the hope that this list can shed some light on an issue I keep encountering with CF 9.0.1 running on Windows Server 2008 R2. My CF instance sometimes stops responding to and/or properly process HTTP requests. When this happens I see the following symptoms: - my monitoring software reports HTTP failure, 'Unable to contact web server at website.com/index.cfm' - Pingdom reports website as down - the CF service is running seemingly normally - another non-CF site on the same server works fine (more or less eliminating IIS as a cause) - a server restart will fix the issue (temporarily until the next 'event') - A CF service restart often hangs so I end up rebooting the server - (potentially unrelated: the CF service does not start up after server reboot even though it is set to automatic, a manual start of the service works) Last night at 00:20am UTC another outage occurred. This time I could tie it to an external event. At precisely that time, Amazon Web Services performed a planned update to their RDS service (MySQL basically) which CF connects to as a datasource. Note that I run RDS in multi-AZ mode which means that when the database shuts down for any reason it fails over to another instance with identical credentials. However it appears CF was never able to reconnect, not even when the original DB came back a few mins later. Moreover not only did the DB connection fail, but CF also stopped processing HTTP requests - no pages (even those without cfquery tags) would load (well they may have done, but see below for how long they suddenly take to process). I noticed in my CF logs: server.log (hundreds of these entries right after the DB connection failed): Warning,jrpp-25682,11/18/12,00:28:08,,Thread: jrpp-25682, processing template: C:\inetpub\wwwroot\scribblar.com\...\index.cfm, completed in 314 seconds, exceeding the 30 second warning limit application.log Error,jrpp-25680,11/18/12,00:19:54,scribblar,Error Executing Database Query.Server shutdown in progress The specific sequence of files included or processed is: C:\inetpub\wwwroot\page.cfm Error,jrpp-25678,11/18/12,00:20:05,scribblar,Error Executing Database Query.Communications link failure The last packet successfully received from the server was 53,418 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. The specific sequence of files included or processed is: C:\inetpub\wwwroot\...page.cfm Error,jrpp-25682,11/18/12,00:21:29,scribblar,Error Executing Database Query.Could not create connection to database server. Attempted reconnect 3 times. Giving up. [these logs then repeat a lot of times] (notice the pages in the server.lo0g take forever to load - to a user they don't work at all as noone waits 5 mins...) Every single page requests after the original 'Error Executing Database' takes several minutes according to the logs. exception.log: (loads of these, I picked one as a sample) Error,jrpp-25779,11/18/12,07:57:02,scribblar,Error Executing Database Query.Could not create connection to database server. Attempted reconnect 3 times. Giving up. The specific sequence of files included or processed is: C:\inetpub\wwwroot\...\index.cfm, line: 8 coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfindex2ecfm507991868.runPage(C:\inetpub\wwwroot\...\index.cfm:8) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:360) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at
stefanrichter
Thank you for your reply, but that sounds like a bug then, doesn't it? I mean there is no db problem as such, it just so happens that the db server may need rebooting from time to time. Would the same happen if a network error was to occur between CF and the db server? You mention cfthread, do you mean a general CF thread of the cfthread tag specifically? I'm not using the cfthread tag if that's what you mean. I admit I don't understand the difference between what I am encountering and DSN failing. If the datasource is unavailable (even temporarily) isn't that something that can happen fairly naturally? It seems to be a huge issue to me that such an incident can effectively bring down the entire CF service :-/ Unfortunately I run CF Standard. Will check out Fusion Reactor. Could you explain what this will allow me to do apart from finding the source of the problem (which in this case I am 99% sure is related to the DB server being offline temporarily). Cheers Stefan If a cf thread hangs trying to connect to a database then it will hang indefinitely because this is a native java thread which cannot be killed. So what happens is that all your requests will hang until you reach the maximum and further requests will be queued and will never complete. There isn't really any solution to this issue I have found other tham to sort out the db problem as native threads cannot be killed. This is not the same as your dsn failing to.connect to the db server, which will result in an error and the request will end. You can use your built in server monitor to check this and see the running requests and threads and stack trace them. If you do not have cf enterprise then try fusion reactor. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine ~| 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:353235 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: error converting docs using cfdocument and openoffice
I'm doing a lot of PPT/PPTX and DOC conversion in one of my apps. Usually I need to convert to image formats, but PDF would be similar: it sometimes simply fails. I think it's because some Office docs have too much gimmicky stuff packed into them. In any case I use some of the Aspose libraries to do the conversion, maybe give that a try. Solutions which require Office or Openoffice on the server seemed slow and not very scalable to me. Aspose is not without its faults, and it isn't cheap, but it does not require any form of Office and it's pretty fast. Regards, Stefan On 26 Jul 2011, at 18:24, David Moore wrote: I allow clients to convert MS office files to PDF documents within my content management system. I was using easyPDF, but since upgrading to CF9, I am attempting to use cfdocument and openoffice. In testing I am finding it works sometimes and sometimes not. When it does not, I get a PDF document which is bascially scambled text. Has anyone else expereinced this or have some suggestions on how to better use the techology. Thank you, David G. Moore, Jr. UpstateWeb, LLC ~| 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:346352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Email Management Software
If you are on a Mac you could give Direct Mail a try. http://ethreesoftware.com/directmail/index.php I've bought the Pro version and have been using it to manage lists with more than 20,000 subscribers for several years to send monthly newsletters. I like the fact that it can connect directly to your database server, meaning you can run simple queries inside the tool. It also handles the usual tasks like mail merge, bounces and reporting. It may not be the best tool on the market but as far as value for money goes I'm very happy as managing large lists can be quite costly using hosted services (which btw Direct Mail also offers - you can have them send your emails). Regards, Stefan On 22 Jul 2011, at 03:18, Matt Quackenbush wrote: I have no experience with MailChimp or ExactTarget, but I bought a copy of Admin Pro Tools Mail List Manager a number of years back. It was a complete waste of money (we ran it for about 1 week), and their support was non-existent. I would certainly steer well clear of that. /.02 On Thu, Jul 21, 2011 at 4:53 PM, Jason Fisher ja...@wanax.com wrote: If you're doing large volumes, I recommend ExactTarget. CF can't actually manage things like bounce-backs, since that's all on the email server-side. You could write all those hooks yourself, if your email server allows you to embed applications, but it's more efficient to let the pro's handle it for you, at least in my experience. Subscriptions you can certainly do with CF, but you can just as easily have your CF subscription system write back to ExactTarget when necessary, so they're not exclusive, depending on your needs. On 7/21/2011 5:05 PM, Russ Michaels wrote: You really should look outside the coldfusion box on this one. take a look at www.mailchimp.com It is free for lists up to 500 users. It has an API and is pretty easy to integrate with and also has a Gmail/Google Apps plugin. I'm sure many others will back me up on how good Mailchimp is. -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| 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:346303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: System.Runtime.InteropServices.ExternalException
Thank you Dave, unfortunately I am a bit hopeless when it comes to debugging these types of issues. However I persevered and managed to get some clues from various .NET posts, some of which pointed at file system problems. I was able to determine that I was trying to write to a non-existent directory when calling the img.save in .NET. I fixed that directory path and it solved my issue. I think I'll write a brief blog post about this as the error message is so non-descriptive that it could be a real pain to debug in some situations. I know why I love CF - at least we get decent error messages (usually anyway). Cheers Stefan On 8 Jul 2011, at 10:50, Dave Watts wrote: My CF 9 machine on EC2 has suddenly started throwing this error (which I am catching): System.Runtime.InteropServices.ExternalException I am logging Type, Message and Detail but this is all I see - System.Runtime.InteropServices.ExternalException I guess this points again at the .NET integration I am running? Or does anyone else know what may cause this? Yes, this is a .NET error. I don't know if it's being thrown by your library or by the .NET integration service library, though. You might try enabling some form of logging within your library, or try running your library from another .NET client with the same inputs. 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:346151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
System.Runtime.InteropServices.ExternalException
My CF 9 machine on EC2 has suddenly started throwing this error (which I am catching): System.Runtime.InteropServices.ExternalException I am logging Type, Message and Detail but this is all I see - System.Runtime.InteropServices.ExternalException I guess this points again at the .NET integration I am running? Or does anyone else know what may cause this? 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:346131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Speeding up .NET dlls
The docs? Ah yes.. that would make sense :-) Thanks, I'll check it out. Stefan On 1 Jul 2011, at 18:17, Leigh wrote: initialises a .NET dll. The first request takes a very long time, and subsequent ones are much quicker. Did you check the documentation on .net assemblies? It mentions creating proxies the first time you create .net objects and some tools for creating proxies. Might be what you are looking for ..? http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec13e1a-7ffd.html ~| 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:346060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Speeding up .NET dlls
Hi all, this should be an easy one. I've noticed a very slow startup when my site initialises a .NET dll. The first request takes a very long time, and subsequent ones are much quicker. I presume that the dll is somehow stored in memeory and I wonder if and how I could have it ready as soon as the first request comes in. Maybe by somehow keeping the Application alive all the time (this site is purely there to handle file conversions, it's an API without user facing pages), and/or pre-initialise the DLLs on Application startup? I'm not sure how CF handles this, but if I run this line somewhere in my app/site cfobject type=.NET name=presentation class=Aspose.Slides.Presentation assembly=#slidesDLL# does that mean that other pages in the same app/site will have a quicker access to that object since it has already been loaded once, or does the performance improvement only happen if the same page is hit more than once in a certain timeframe? 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:346024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Help with .NET DLL - Again...
Hi guys, I could use some advice. I'm trying to use some methods from a .NET assembly. I'm instantiating it like this: cfset DLL = #Expandpath('./')#\Aspose.Words.dll cfobject type=.NET name=doc class=Aspose.Words.Document assembly=#DLL# If I dump the doc variable I see all the assembly methods. So far so good. I recall that I need to call init in CF to invoke the constructor, but when I do that (and pass a path to the document) I get the error: Unable to find a constructor for class Aspose.Words.Document that accepts parameters of type ( coldfusion.runtime.LocalScope ). According to the docs http://www.aspose.com/documentation/.net-components/aspose.words-for-.net/aspose.words.documentconstructor2.html I believe that I need to pass a string. In C# the example code looks like this: Document doc = new Document(MyDir + Document.doc); I was trying cfset file = #Expandpath('./')#\test1.doc cfset doc.init(#file#) but receive the above error. I admit I am a bit out of my depth here, but previously I have used similar libraries successfully after some initial struggles and help from this list. Any tips appreciated. 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:345966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help with .NET DLL - Again...
Thanks, the server is 9.01 and I already have a very similar other DLL from the same company working on the same machine. I believe I updated the .NET connector previously after having some issues first time round. The OS is 64bit Win 2008. I'm not sure about the DLL itself, it was not marked as 32 or 64 bit. Any way to tell? Regards Stefan On 30 Jun 2011, at 18:09, Scott Stewart wrote: Just out of curiosity, 1) What version of CF and 2) 32 bit or 64 bit OS 3) 32 bit or 64 bit dll If it's CF 9.01 you need to update the .net connector as well, and some manual configuration to get it to work.. Secondly there are issues with 32 bit dll's running in a 64 bit environment. On Thu, Jun 30, 2011 at 12:59 PM, Stefan Richter ste...@flashcomguru.com wrote: Hi guys, I could use some advice. I'm trying to use some methods from a .NET assembly. I'm instantiating it like this: cfset DLL = #Expandpath('./')#\Aspose.Words.dll cfobject type=.NET name=doc class=Aspose.Words.Document assembly=#DLL# If I dump the doc variable I see all the assembly methods. So far so good. I recall that I need to call init in CF to invoke the constructor, but when I do that (and pass a path to the document) I get the error: Unable to find a constructor for class Aspose.Words.Document that accepts parameters of type ( coldfusion.runtime.LocalScope ). According to the docs http://www.aspose.com/documentation/.net-components/aspose.words-for-.net/aspose.words.documentconstructor2.html I believe that I need to pass a string. In C# the example code looks like this: Document doc = new Document(MyDir + Document.doc); I was trying cfset file = #Expandpath('./')#\test1.doc cfset doc.init(#file#) but receive the above error. I admit I am a bit out of my depth here, but previously I have used similar libraries successfully after some initial struggles and help from this list. Any tips appreciated. 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:346001 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help with .NET DLL - Again...
Good point, I'll try with a different naming convention. Regards Stefan On 30 Jun 2011, at 18:10, Leigh wrote: cfset file = #Expandpath('./')#\test1.doc cfset doc.init(#file#) Does #file# actually resolve to a string or a structure? Historically #file# was a reserved word like CFFILE. ~| 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:346002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help with .NET DLL - Again...
BINGO! I think that was indeed the issue. I renamed the file variable and bam, no more error. Thanks very much. Man, I love this list. Stefan On 30 Jun 2011, at 21:41, Stefan Richter wrote: Good point, I'll try with a different naming convention. Regards Stefan On 30 Jun 2011, at 18:10, Leigh wrote: cfset file = #Expandpath('./')#\test1.doc cfset doc.init(#file#) Does #file# actually resolve to a string or a structure? Historically #file# was a reserved word like CFFILE. ~| 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:346003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Synonym Dictionary
To create a catalog or do the synonym lookup on the fly you could use Wolfram: http://www.wolframalpha.com/input/?i=synonym+for+bike They have a (commercial) API. The difference with Wolfram as opposed to a Google search is that Wolfram will compute and return the results directly to you rather than provide links to sites with potential results. Stefan On 30 Apr 2011, at 16:26, Richard White wrote: Hi, We use ColdFusion and MySQL (innodb) in our applications and when users search for data we want it to also find records containing related words / synonyms. What is the best way to achieve this? 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:344088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Synonym Dictionary
Wolfram sounds like a good fit in that case. I can refer you to the right people if you like. Their pricing is, I found, reasonable. S On 30 Apr 2011, at 16:41, Richard White wrote: thanks for your reply... yes your example is exactly what we want, except as you have indicated the scope is unfortunately large! we basically need our application linked to some form of existing thesaurus that we can query for synonyms, and then in our code make sure it also searches for those words. Basically, our software is used for medical data, and we are finding users typing words such as 'mother' when another user entered the data as 'maternal', therefore the data is not being found. This happens on various different scenarios and is why we are thinking rather than attempting to build our own, we could possibly utilize an existing synonym dictionary plug-in ... if one exists! thanks for any pointers ~| 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:344090 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
Thanks, How would I go about saving the image with cfhttp directly? Do you mean using cffile to save the cfhttp.Filecontent? Regards, Stefan On 20 Apr 2011, at 00:00, Leigh wrote: 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:343866 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
Great, thanks Dave. On 20 Apr 2011, at 15:07, Dave Watts wrote: How would I go about saving the image with cfhttp directly? Do you mean using cffile to save the cfhttp.Filecontent? Use the PATH and FILE attributes of CFHTTP to save the file directly. No need to use CFFILE here at all. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7ffc.html 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:343872 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
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
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
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
Creating COM object - troubleshooting
Hi all, I'm trying to use a third party DLL called ACA Webthumb http://www.acasystems.com/en/web-thumb-activex/ I've installed this on a Windows 2008 server running CF 9.0.1 I'm having issue instantiating the library in CF. I'm using the supplied sample file that came with ACA. Here's the problematic line from it: WebThumbMaker = CreateObject(Com, ACAWebThumb.ThumbMaker, local); This results in error: An exception occurred when instantiating a COM object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed. 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. Does anyone have any tips? Best wishes, 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:343806 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 should also add that the PHP example works fine on the same box: $t_xMaker = new COM(ACAWebThumb.ThumbMaker) Also on the same server I am able to use other (.NET) DDLs, for example in this way: cfobject type=.NET name=presentation class=Aspose.Slides.Pptx.PresentationEx assembly=#slidesDLL# cfset presentation.init(#pptFile#) Regards, Stefan Hi all, I'm trying to use a third party DLL called ACA Webthumb http://www. acasystems.com/en/web-thumb-activex/ I've installed this on a Windows 2008 server running CF 9.0.1 I'm having issue instantiating the library in CF. I'm using the supplied sample file that came with ACA. Here's the problematic line from it: WebThumbMaker = CreateObject(Com, ACAWebThumb.ThumbMaker, local); This results in error: An exception occurred when instantiating a COM object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed. 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. Does anyone have any tips? Best wishes, 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:343807 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 Mark. 32/64bit: there seems to be only one DLL in the program's directory, and it's in x86 so I guess it's 32bit only. The server is a 64bit machine. Do I somehow need to 'tell' CF that we are looking at a 32bit DLL here? I take your point on .NET and COM, I was just goofing around to see if it would work :-) I agree that it's likely to be a COM. As for 'is it registered': how can I tell? I'm not that clued up on these things, but I did use OLE Viewer and saw 'ACAWebThumb 1.0 Type Library' under 'Type Libraries'. Is that confirmation? Does the fact that the straight forward PHP call works tell us anything? Cheers Stefan On 18 Apr 2011, at 16:18, Mark A. Kruger wrote: FYI - .NET and COM are very (very very) different - I would not expect this DLL to work both ways. It's either a COM or an assembly. I would suspect it's a COM (the path activeX control gives it away). Also - you are sure the COM is registered? -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Monday, April 18, 2011 9:38 AM To: cf-talk Subject: Creating COM object - troubleshooting Hi all, I'm trying to use a third party DLL called ACA Webthumb http://www.acasystems.com/en/web-thumb-activex/ I've installed this on a Windows 2008 server running CF 9.0.1 I'm having issue instantiating the library in CF. I'm using the supplied sample file that came with ACA. Here's the problematic line from it: WebThumbMaker = CreateObject(Com, ACAWebThumb.ThumbMaker, local); This results in error: An exception occurred when instantiating a COM object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed. 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. Does anyone have any tips? Best wishes, 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:343810 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
Thank you. Is this a restriction via CF then or why is it so easy to do it in PHP? Is it because CF will run in 64bit mode and PHP is not? Regards, Stefan On 18 Apr 2011, at 16:47, Mark A. Kruger wrote: Stefan, If you are running 64bit you will need a 64bit version of the COM. I know of no way around that. I would contact the vendor. If it's .NET you can use it through the .NET integration services (either 32 or 64) but there are a good number of nuances to that as well. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Monday, April 18, 2011 10:41 AM To: cf-talk Subject: Re: Creating COM object - troubleshooting Thanks Mark. 32/64bit: there seems to be only one DLL in the program's directory, and it's in x86 so I guess it's 32bit only. The server is a 64bit machine. Do I somehow need to 'tell' CF that we are looking at a 32bit DLL here? I take your point on .NET and COM, I was just goofing around to see if it would work :-) I agree that it's likely to be a COM. As for 'is it registered': how can I tell? I'm not that clued up on these things, but I did use OLE Viewer and saw 'ACAWebThumb 1.0 Type Library' under 'Type Libraries'. Is that confirmation? Does the fact that the straight forward PHP call works tell us anything? Cheers Stefan On 18 Apr 2011, at 16:18, Mark A. Kruger wrote: FYI - .NET and COM are very (very very) different - I would not expect this DLL to work both ways. It's either a COM or an assembly. I would suspect it's a COM (the path activeX control gives it away). Also - you are sure the COM is registered? -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Stefan Richter [mailto:ste...@flashcomguru.com] Sent: Monday, April 18, 2011 9:38 AM To: cf-talk Subject: Creating COM object - troubleshooting Hi all, I'm trying to use a third party DLL called ACA Webthumb http://www.acasystems.com/en/web-thumb-activex/ I've installed this on a Windows 2008 server running CF 9.0.1 I'm having issue instantiating the library in CF. I'm using the supplied sample file that came with ACA. Here's the problematic line from it: WebThumbMaker = CreateObject(Com, ACAWebThumb.ThumbMaker, local); This results in error: An exception occurred when instantiating a COM object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed. 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. Does anyone have any tips? Best wishes, 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:343812 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, 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:343822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
I've not used RDS (yet) due to the costs involved but it certainly is an attractive option as your operations grow as backup and replication are 'built in'. Overhead that would make it unusable? Why do you think that? It's designed to perform well. However what I have used (in fact just put live into production recently) is MySQL on EC2 using two micro instances in a Master-Slave setup. Arguably this will work fine for small to medium sized sites which run less complex queries. So far it is working a treat for a site that pushes around 2,000 daily sessions and a few thousand inserts (mainly logging) and a few simple CRUD queries. My setup is as follows: - 2 EC2 micro instances running Ubuntu 10.10 and MySQL 5.1 - One MySQL instance configured as master, the other as slave. CF talks to the master. This allows me to dump the slave daily without table locks on the master database. - MySQL dumps daily to S3 using s3fs (allows you to mount an S3 bucket as a filesystem) - slave talks to master on the EC2 private IP - if my master was to go down for any reason I could switch the elastic IP over to the slave and resume very quickly that way. With EC2 this can also be automated I'm by no means an EC2 expert but have spent the last two weeks experimenting a lot with the platform. The more I learn about it the better it gets. One thing that I have not yet figured out is how to work around the one-IP-per-instance limit - I need two services on port 80 (FMS and Apache) on another instance but this does not seem possible at this time... :-/ Regards, Stefan On 18 Feb 2011, at 04:57, Chris . wrote: Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept from what I'm reading at least, sounds great. I currently use shared hosting with CF and MySQL. I'm pouring over the documentation but most of it is over my head as I'm not familiar with Amazon web services and/or MySQL server administration. From what I'm getting though, I can create the MySQL database there, import data into it, and then connect to it from the CF server during CFQUERY calls. Has anyone looked into this or tried something like this? I'm skeptical and imagine there'd be overhead that would make it unusable but I'm not finding anything to back that up.. ~| 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:342420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
Try http://www.scribblar.com/latestrooms.cfm The CF server is UK racked, the DB is US-East on EC2 (micro instance, RDS would arguably perform better). The page runs an uncached query to grab the latest rooms. The plan is to move everything onto EC2. Cheers Stefan On 18 Feb 2011, at 10:47, Jochem van Dieten wrote: On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote: Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept from what I'm reading at least, sounds great. I currently use shared hosting with CF and MySQL. I'm pouring over the documentation but most of it is over my head as I'm not familiar with Amazon web services and/or MySQL server administration. From what I'm getting though, I can create the MySQL database there, import data into it, and then connect to it from the CF server during CFQUERY calls. In theory yes. In practice you may encounter the following problems: - firewalls preventing your shared host from connecting to the database; - latency between your shared host and the database. The last one can be a killer. Let's presume the network latency is about 50 ms. For setting up a database connection you first have the TCP SYN/ACK and then MySQL authentication. Your best case scenario is now 100 ms to set up the connection. Doing a query? First send the PREPARE statement, then execute it. So that is another 100 ms. But wait, once the results are in the driver will do additional calls to get the metadata that describe the columns. So doing a query over a new connection is now 250 ms, and over an existing connection 150 ms. And that is without the unpredictability of the latency inside the Amazon cloud. Amazon RDS may be a good solution if your app is hosted at Amazon too, but otherwise I don't think it is a good idea for interactive applications. And if you are hosting your servers on Amazon, why not load MySQL on your instance there? But the great thing about all the Amazon Cloud services is the cost for a short test. Since it costs you about 0.11$ per hour to just test it, so why not try it and tell us how it goes :) Jochem ~| 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:342424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using Google Apps/Gmail for CFMail - limitations?
I've been using MailEnable (free version) for years and I'm quite happy with it. On another box I paid for Kerio Mailserver, again a good product IMO. I've now moved all mail for my domains to Google Apps and use my mailserver for sending. If you are handling newsletter I recommend a service such as Mailchimp, or if you want to manage it yourself (as I do right now) and you are on OSX then check out Direct Mail: http://ethreesoftware.com/directmail/index.php I send 10,000 emails bi-weekly using Direct Mail and it does the job very nicely indeed. I like the fact that you can run queries directly against remote datasources to pull your list into the app. Regards, Stefan On 17 Feb 2011, at 02:10, Pete Ruckelshaus wrote: I think that'd be overkill, given the relatively low volume. FWIW, I'm with KickAssVPS and have been happy with them now that I have my server set up. Pete On Wed, Feb 16, 2011 at 9:01 PM, Sean Corfield seancorfi...@gmail.comwrote: I think you should serious consider something like a PowerMTA server at your hosting company... On Wed, Feb 16, 2011 at 4:51 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm switching several domains over from multiple shared hosting accounts to a virtual private server. For a number of reasons (server resources, managing accounts), I am using the Gmail that comes with Google Apps for domain email for each domain.Without an SMTP server, I'll need to use GMail for mail sending. I've found references to others doing that here, but I'm wondering what the limits are for sending email? Does Google throttle or otherwise inhibit email? One of the domains has about 5k users in an opt-in email list, and I want to make sure I'm not going to cause myself problems. Emails are sent from this site once, perhaps twice per week, so I think I'm looking at 10,000 outgoing emails ~| 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:342367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Errr... I am not sure. I put it right after the opening cfcomponent tag. I previously tried cfset in the same place, as well as in the onApplicationStart. Neither seemed to stick - yes I saw the variables when I iterated over the application variables but the S3 stuff did not work. Once I got it working it choked on those modified date fields :-/ Any pointers welcome. Regards, Stefan On 10 Feb 2011, at 02:07, Raymond Camden wrote: DId you run that code in the constructor area of the CFC? On Wed, Feb 9, 2011 at 1:59 PM, Stefan Richter ste...@flashcomguru.com wrote: Warming up an old thread as I've had the same issue. It seems to me that the following did not work in my App.cfc: cfcomponent cfset this.s3.accessKeyId = xx cfset this.s3.awsSecretKey = xx; ... However using this syntax worked: cfcomponent cfscript this.s3.accessKeyId = xx; this.s3.awsSecretKey = xx; /cfscript ... It does not make much sense. In both cases I was able to see the variables being set properly. Once I got it working using cfscript I encountered other problems, specifically An error occurred when performing a file operation lastModified on file /myfolder. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not determine the last modified timestamp of s3://blah.site.com/myfolder.. Using an FTP client I noticed that some folders did not show a last modified or created date. Not sure why they didn't, but it certainly made CF choke big time when trying to list files. Thought I'd throw that out there. Cheers 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:342089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Sure, it is simply this: cfset files = directoryList(s3://blah.site.com) cfdump var=#files# Is that what you need? The above worked yesterday (falling over on the modified date issue), but I've just tried again and now it won't work at all. Now I get this error when trying to list by bucket root contents: An error occurred when performing a file operation listFiles on file /. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not list the contents of s3://blah.site.com/ because it is not a folder.. If I try a subfolder inside my bucket the same thing happens. I then tried using the 'real' domain ending in s3.amazon.com instead of my CNAME and got the same error. If you could file the bug on that initial issue then I'd appreciate it. Cheers Stefan On 10 Feb 2011, at 12:19, Raymond Camden wrote: So while it won't help, can you show the tag based code you used that did not work - the complete code please. On Thu, Feb 10, 2011 at 6:18 AM, Raymond Camden rcam...@gmail.com wrote: Dangit - I can verify the bug too. I made a folder in the s3 console, it had no last modified, and CF borked on it. Can you file a bug report for it or would you like me? On Thu, Feb 10, 2011 at 4:48 AM, Stefan Richter ste...@flashcomguru.com wrote: Errr... I am not sure. I put it right after the opening cfcomponent tag. I previously tried cfset in the same place, as well as in the onApplicationStart. Neither seemed to stick - yes I saw the variables when I iterated over the application variables but the S3 stuff did not work. Once I got it working it choked on those modified date fields :-/ ~| 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:342093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Hmm I am getting confused now. Here's what I tried: cfcomponent cfset this.Sessionmanagement=true cfset this.s3.accessKeyId = x cfset this.s3.awsSecretKey = ... However when I tried again now it seemed to work (setting the keys that is)... but I got the same error about my bucket not being a folder. I made sure to re-init those vars. Regards, Stefan On 10 Feb 2011, at 13:23, Raymond Camden wrote: No, you said a script based App.cfc worked, but not tag based. I'd like to see your tag based App.cfc that failed. On Thu, Feb 10, 2011 at 7:09 AM, Stefan Richter ste...@flashcomguru.com wrote: Sure, it is simply this: cfset files = directoryList(s3://blah.site.com) cfdump var=#files# Is that what you need? The above worked yesterday (falling over on the modified date issue), but I've just tried again and now it won't work at all. Now I get this error when trying to list by bucket root contents: An error occurred when performing a file operation listFiles on file /. I'll file a bug report on it. ~| 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:342096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Ok, I may have missed the name out, but other times I definitely had a name specified. When I said same error I meant the one where S3 support in CF now stopped working completely for me as it won't list any folder contents as it apparently does not recognise anything as a folder anymore. Yesterday I got a bit further, CF saw folders and tripped up over the modified date but today I don't even get that far... Maybe you could supply me with an App.cfc that you think should work, and I'll try that with my directory listing logic? Cheers Stefan On 10 Feb 2011, at 14:26, Raymond Camden wrote: If your code _really_ looks like that - your problem may be the lack of a name for the application. You said same error, do you mean the one we both verified? I wasn't saying _that_ would go away. I was more concerned with why your script based setup worked and not your tag based. On Thu, Feb 10, 2011 at 7:35 AM, Stefan Richter ste...@flashcomguru.com wrote: Hmm I am getting confused now. Here's what I tried: cfcomponent cfset this.Sessionmanagement=true cfset this.s3.accessKeyId = x cfset this.s3.awsSecretKey = ... However when I tried again now it seemed to work (setting the keys that is)... but I got the same error about my bucket not being a folder. I made sure to re-init those vars. Regards, Stefan On 10 Feb 2011, at 13:23, Raymond Camden wrote: No, you said a script based App.cfc worked, but not tag based. I'd like to see your tag based App.cfc that failed. On Thu, Feb 10, 2011 at 7:09 AM, Stefan Richter ste...@flashcomguru.com wrote: Sure, it is simply this: cfset files = directoryList(s3://blah.site.com) cfdump var=#files# Is that what you need? The above worked yesterday (falling over on the modified date issue), but I've just tried again and now it won't work at all. Now I get this error when trying to list by bucket root contents: An error occurred when performing a file operation listFiles on file /. I'll file a bug report on it. ~| 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:342106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Ah ok. I tested with the inline credentials - same error. An error occurred when performing a file operation listFiles on file /. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not list the contents of s3://x:yy...@media.muchomedia.com/ because it is not a folder.. media.muchosmedia.com is my bucket name. When I log onto my S3 account in Transmit I see it as a bucket, opening it reveals files and folders so I think I should be able to list it - and I was able to yesterday apart from the modified date issue. Moreover I was able to create folders via CF yesterday and list their content (not tried again today). Regards, Stefan On 10 Feb 2011, at 14:48, Raymond Camden wrote: In my testing all I did was do a cfdirectory on a bucket. In my case I emdedded the auth stuff in the dir. I basically had: cfset dir = s3://x:y...@s3.coldfusionjeid.com/ Where s3.coldfusionjedi.com was my bucket. Ignoring the fact that I put my auth in there - does your code use a similar dir, specifically s3://bucket/ On Thu, Feb 10, 2011 at 8:36 AM, Stefan Richter ste...@flashcomguru.com wrote: Ok, I may have missed the name out, but other times I definitely had a name specified. When I said same error I meant the one where S3 support in CF now stopped working completely for me as it won't list any folder contents as it apparently does not recognise anything as a folder anymore. Yesterday I got a bit further, CF saw folders and tripped up over the modified date but today I don't even get that far... Maybe you could supply me with an App.cfc that you think should work, and I'll try that with my directory listing logic? ~| 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:342110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Oh nice one thanks. I'll give it a try. S On 10 Feb 2011, at 19:21, Raymond Camden wrote: lTo your directory list issue - I have good news. For some reason, directoryList() works fine. Just don't use listinfo=query. On Thu, Feb 10, 2011 at 9:32 AM, Raymond Camden rcam...@gmail.com wrote: You got me then. Looks right to me. ~| 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:342119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Charts - QR Code - cfimage
Yes that's what I found too when using an API that returned images that did not have an 'image' url. Appending a .jpg or similar did not help either. In the end I did something like this (I knew that gifs were returned): cfhttp url=#image.src# resolveurl=No /cfhttp cfset resImg = cfhttp.fileContent.toByteArray() / cfset imagename = CreateUUID() cfimage action = write destination = #THISFOLDER#/#imagename#.gif source = #resImg# overwrite=true Cheers Stefan On 9 Feb 2011, at 19:26, Dan G. Switzer, II wrote: JD, In my experience, the image functions generally want an extension for the input so the image libraries know how to handle the image. Since the URL doesn't have a .png in the filename, I think that's the problem. You may need to use CFHTTP to save the image as a PNG on a filesystem and then read the image off disk. -Dan ~| 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:342062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Warming up an old thread as I've had the same issue. It seems to me that the following did not work in my App.cfc: cfcomponent cfset this.s3.accessKeyId = xx cfset this.s3.awsSecretKey = xx; ... However using this syntax worked: cfcomponent cfscript this.s3.accessKeyId = xx; this.s3.awsSecretKey = xx; /cfscript ... It does not make much sense. In both cases I was able to see the variables being set properly. Once I got it working using cfscript I encountered other problems, specifically An error occurred when performing a file operation lastModified on file /myfolder. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not determine the last modified timestamp of s3://blah.site.com/myfolder.. Using an FTP client I noticed that some folders did not show a last modified or created date. Not sure why they didn't, but it certainly made CF choke big time when trying to list files. Thought I'd throw that out there. Cheers Stefan I am having this same problem. But I am pretty sure my server is running the latest update: Version: 9,0,1,274733 Could anything else cause this. I have restarted the app and see the s3 variables in there using application.getApplicationSettings(). --- David Mineer Jr ~| 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:342067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9.01 S3:// not working
Digging a bit deeper, I don't seem to be able to list ANY folder contents in my S3 bucket unless I create that folder wit CF. Any of the existing folders (created mainly using Transmit) will throw an error: An error occurred when performing a file operation lastModified on file /temp. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not determine the last modified timestamp of s3://blah.site.com/temp.. Any ideas? At this stage the S3 support in CF does seem very shaky at best. Stefan On 9 Feb 2011, at 19:59, Stefan Richter wrote: Warming up an old thread as I've had the same issue. It seems to me that the following did not work in my App.cfc: cfcomponent cfset this.s3.accessKeyId = xx cfset this.s3.awsSecretKey = xx; ... However using this syntax worked: cfcomponent cfscript this.s3.accessKeyId = xx; this.s3.awsSecretKey = xx; /cfscript ... It does not make much sense. In both cases I was able to see the variables being set properly. Once I got it working using cfscript I encountered other problems, specifically An error occurred when performing a file operation lastModified on file /myfolder. The cause of this exception was: org.apache.commons.vfs.FileSystemException: Could not determine the last modified timestamp of s3://blah.site.com/myfolder.. Using an FTP client I noticed that some folders did not show a last modified or created date. Not sure why they didn't, but it certainly made CF choke big time when trying to list files. Thought I'd throw that out there. Cheers Stefan I am having this same problem. But I am pretty sure my server is running the latest update: Version: 9,0,1,274733 Could anything else cause this. I have restarted the app and see the s3 variables in there using application.getApplicationSettings(). --- David Mineer Jr ~| 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:342072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Query of query help
Hi all, hoping for some advice with querying a query - at least I think that's what's a good fit here but feel free to advise otherwise. I've got a folder which contains 35,000 folders. I've also got a table with lots of records, where the roomid column matches the name of one of the folders. I know some folders do not have a matching record, and I want to identify those records. cfdirectory action=list name=roomList type=dir directory=#roomsDir# cfquery datasource=#dsn# name=roomsDB SELECT roomid from rooms /cfquery I *think* I need to do something along these lines: cfquery name=orphanRooms dbtype=query select * from roomList WHERE name ... /cfquery But somehow I cannot figure out the correct syntax. The resultset from orphanRooms should contain all the records that are in roomList but not in roomsDB. Any help appreciated. 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:341722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query of query help
Thanks. Guess what I was trying to avoid was a loop with 35,000 queries... I was trying to come up wit a clever way to do this in one SQL statement. One issue I noticed is that QoQ does not to seem to (easily?) support joins. Then again I'm no SQL ninja by any means. S On 31 Jan 2011, at 17:54, Jason Fisher wrote: Yes, QoQ will work here. !--- get your folders --- cfdirectory action=list name=roomList type=dir directory=#roomsDir# !--- get the rooms from the DB --- cfquery datasource=#dsn# name=roomsDB SELECT roomid FROM rooms /cfquery cfoutput query=roomList !--- loop through the folders and check against the rooms in the DB --- cfquery dbtype=query name=orphanRoom SELECT name FROM roomsDB WHERE roomid = '#name#' /cfquery cfif not orphanRoom.recordCount !--- flag this as a room without a folder --- /cfif /cfoutput ~| 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:341732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query of query help
Thanks Dave, listing the folders performs a lot better than I expected, so that's not my issue here. Cheers Stefan On 31 Jan 2011, at 17:57, Dave Watts wrote: I've got a folder which contains 35,000 folders. Setting aside your QoQ question, you may have problems simply traversing a folder with this many items in it. 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:341733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query of query help
I was trying something like this: cfquery name=orphanRooms dbtype=query select * from roomList WHERE name = 'x' cfloop query=roomsDBOR roomList.name = '#roomid#' /cfloop /cfquery I think I am getting somewhere with it. Anything inherently wrong with this? Stefan On 31 Jan 2011, at 17:54, Raymond Camden wrote: Um, did you try the where clause? You said it didn't work - how did it not work? Can you show us the full code and the error? On Mon, Jan 31, 2011 at 11:48 AM, Stefan Richter ste...@flashcomguru.com wrote: Hi all, hoping for some advice with querying a query - at least I think that's what's a good fit here but feel free to advise otherwise. I've got a folder which contains 35,000 folders. I've also got a table with lots of records, where the roomid column matches the name of one of the folders. I know some folders do not have a matching record, and I want to identify those records. cfdirectory action=list name=roomList type=dir directory=#roomsDir# ~| 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:341737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query of query help
Ah great, an interesting approach. Many thanks. Stefan On 31 Jan 2011, at 20:10, Jason Fisher wrote: Stefan, This might work ... can't remember if the IN () function works in QoQ or not. !--- get a list of all the rooms from the DB (after you query) --- cfset roomList = valueList(roomsDB.roomid) / !--- now query to get folders that are not in the rooms DB list --- cfquery dbtype=query name=roomsOK SELECT * FROM roomList WHERE name NOT IN ( cfqueryparam cfsqltype=cf_sql_varchar value=#roomList# list=true / ) /cfquery ~| 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:341738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with jpedal java integration
Works. A. treat. Thank you, and thanks Mark Mandel. Stefan On 24 Jan 2011, at 14:42, Leigh wrote: But the fact that the two jars seem to conflict with one another throws a real spanner into the works... Is there any way I could separate them and have both present in CF? Try using the javaLoader http://javaloader.riaforge.org/ ~| 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:341168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfpdf action=getinfo returns incorrect PDF sizes
Something seems wonky with cfpdf. I've looked at JPedal for my PDF to image conversion because cfpdf action=thumbnail would produce images that were not at 1:1 scale with the original PDF, instead they were smaller. When I open the PDF in Acrobat at 100% and measure via an on screen ruler I get a width of roughly 690pixels. CF tells me the width is 505. Height is also incorrect by the same ratio. I've now noticed that cfpdf action=getinfo also gives those same (and what I think are wrong) results for the dimensions. Bug? Or is Acrobat showing me the wrong size when I tell it to show me the PDF at 100%? To be fair I think it's CF that's getting it wrong. Anyone else noticed the same? 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:341170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfpdf action=getinfo returns incorrect PDF sizes
Hmm, looking at this more closely, if I 'Get info' on a PDF in the OSX Finder I see the same small dimensions as the ones that CF reports. But the 100% view in Acrobat is clearly the authored size, more or less an A4 page on screen. Maybe this is some specific 'feature' of the PDF format? Stefan On 25 Jan 2011, at 15:51, Stefan Richter wrote: Something seems wonky with cfpdf. I've looked at JPedal for my PDF to image conversion because cfpdf action=thumbnail would produce images that were not at 1:1 scale with the original PDF, instead they were smaller. When I open the PDF in Acrobat at 100% and measure via an on screen ruler I get a width of roughly 690pixels. CF tells me the width is 505. Height is also incorrect by the same ratio. I've now noticed that cfpdf action=getinfo also gives those same (and what I think are wrong) results for the dimensions. Bug? Or is Acrobat showing me the wrong size when I tell it to show me the PDF at 100%? To be fair I think it's CF that's getting it wrong. Anyone else noticed the same? 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:341174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Help needed with jpedal java integration
I'm trying to use a Java library called jpedal (http://www.jpedal.org) in order to convert PDF files to images. The following works great from the commandline on my Mac: java -cp ./jpedal_trial.jar org/jpedal/examples/images/HiResThumbnailExtractor test.pdf jpg However I'm not sure how to invoke the same from CF. I added the jpedal trial jar to ColdFusion9/lib and then tried the following: cfset jpedal = createObject(java,org/jpedal/examples/images/HiResThumbnailExtractor) / and got the error: An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: IllegalName: org/jpedal/examples/images/HiResThumbnailExtractor. I've spoken to the developer of jpedal, Mark Stephens, who told me that HiResThumbnailExtractor is not an interface or abstract class. As some of you may know, jpedal is already part of CF as Adobe have licensed the library for some of their PDF handling. I wondered if this was causing problems, but even after removing the original jpedal.jar from CF I got the same error. I was using CFPDF up until now to do the conversion but find the resulting images not good enough in terms of quality. For example even after specifying scale=100 in cfpdf, the resulting images are smaller than the original PDF. Any tips on how I can use the .jar file successfully would be much appreciated. 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:341119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with jpedal java integration
I've figured out the Java image part: cfset jpg = ImageNew(foo) cfimage action=write source=#jpg# destination=test.jpg overwrite=yes This works. But the fact that the two jars seem to conflict with one another throws a real spanner into the works... Is there any way I could separate them and have both present in CF? Regards, Stefan On 24 Jan 2011, at 13:30, Stefan Richter wrote: I've got two further questions. Now that I got the syntax right I can run cfset jpedal = createObject(java,org.jpedal.examples.images.HiResThumbnailExtractor) / cfset jpedal.init() cfset img = jpedal.getHiresPage(1, 1, '/Applications/MAMP/htdocs/testbed/test.pdf') and I get back a java.awt.image.BufferedImage What's the best/easiest way to now save this as a jpg to disk? Also the jpedal.jar that comes with CF seems to be interfering with the one I'd like to use. I can only get my example to work if I remove the CF version of the jar - but I think this will break other core CF features. Is there a way so that I can use both jars even though they contain some overlapping classes? Apparently the CF version is a custom version of jpedal and not the same as the one I downloaded from their site. Regards, Stefan On 24 Jan 2011, at 12:53, Stefan Richter wrote: DOH! Thanks Scott! On 24 Jan 2011, at 12:47, Scott Stewart wrote: Should be org.jpedal. rest of path On Jan 24, 2011 7:18 AM, Stefan Richter ste...@flashcomguru.com wrote: I'm trying to use a Java library called jpedal (http://www.jpedal.org) in order to convert PDF files to images. The following works great from the commandline on my Mac: java -cp ./jpedal_trial.jar org/jpedal/examples/images/HiResThumbnailExtractor test.pdf jpg However I'm not sure how to invoke the same from CF. I added the jpedal trial jar to ColdFusion9/lib and then tried the following: cfset jpedal = createObject(java,org/jpedal/examples/images/HiResThumbnailExtractor) / and got the error: An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: IllegalName: org/jpedal/examples/images/HiResThumbnailExtractor. I've spoken to the developer of jpedal, Mark Stephens, who told me that HiResThumbnailExtractor is not an interface or abstract class. As some of you may know, jpedal is already part of CF as Adobe have licensed the library for some of their PDF handling. I wondered if this was causing problems, but even after removing the original jpedal.jar from CF I got the same error. I was using CFPDF up until now to do the conversion but find the resulting images not good enough in terms of quality. For example even after specifying scale=100 in cfpdf, the resulting images are smaller than the original PDF. Any tips on how I can use the .jar file successfully would be much appreciated. 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:341121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfimage write problems
Just to follow up on this: adding something like ext=.gif did *not* work. Sorry Ray ;-) If I try this: cfset THISFOLDER = #Expandpath('./')# cfimage action = write destination = #thisFolder# source = http://www4b.wolframalpha.com/Calculate/MSP/MSP602219e3e3996gh5hbc15fea4b2e9h4g4ccc?MSPStoreType=image/gifs=16ext=.gif; then CF still complains: The /calculate/msp/msp602219e3e3996gh5hbc15fea4b2e9h4g4ccc image format is not supported on this operating system. CF seems to ignore anything after the ? As mentioned before I managed to work around this by fetching the image over cfhttp but cfimage would have been a lot more convenient. Cheers Stefan On 17 Jan 2011, at 15:20, Raymond Camden wrote: Yeah I seem to remember that trick working in the past. You have to assume your remote service doesn't care about a url param called ext. To be safe, I'd use: rayrules=.gif On Mon, Jan 17, 2011 at 9:13 AM, Stefan Richter ste...@flashcomguru.com wrote: Ah I see. Guess I could try this by appending ext=.gif to the URL then... Thanks. On 17 Jan 2011, at 14:41, Raymond Camden wrote: I think - stress think - CF handles the result based on the file name in the URL. So if CF had seen foo.gif at the end, it would have assumed a gif. In your case there is no obvious extension so maybe CF didn't know what to assume. ~| 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:341123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfimage write problems
Thanks, I tried that (using action=info) but got the same error under CF9. It falls over as soon as it encounters the cfimage tag. Cheers Stefan On 24 Jan 2011, at 15:04, Azadi Saryev wrote: just tested it on Railo (don't have ACF at hand) and it worked fine. you should specify a filename in your destination attribute, though... just to test, do a cfimage action=info ... and cfdump the variable. Azadi On 24/01/2011 22:41 , Stefan Richter wrote: Just to follow up on this: adding something likeext=.gif did *not* work. Sorry Ray ;-) If I try this: cfset THISFOLDER = #Expandpath('./')# cfimage action = write destination = #thisFolder# source = http://www4b.wolframalpha.com/Calculate/MSP/MSP602219e3e3996gh5hbc15fea4b2e9h4g4ccc?MSPStoreType=image/gifs=16ext=.gif; then CF still complains: The /calculate/msp/msp602219e3e3996gh5hbc15fea4b2e9h4g4ccc image format is not supported on this operating system. CF seems to ignore anything after the ? As mentioned before I managed to work around this by fetching the image over cfhttp but cfimage would have been a lot more convenient. Cheers 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:341126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Checkout integration
I'd also be interested in that. And on that note, what does everyone else use when it comes to subscriptions? Paypal is ok for the basics I guess, but I could really use a system that let's me adjust the price from one month to the next for upgrades/downgrades. Any recommendations welcome. Regards, Stefan On 21 Jan 2011, at 00:32, Jeff Gladnick wrote: Does anyone have any code they'd like to share concerning Google checkout integration? The only thing on riaforge is several years old. Anyone out there with newer code, particularly concerning the new subscription features added recently? ~| 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:341079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google Checkout integration
Thanks. What's their API like? Easy to use? Do you use hosted checkout pages or custom ones? Cheers Stefan On 21 Jan 2011, at 10:15, mac jordan wrote: On Fri, Jan 21, 2011 at 10:12 AM, Stefan Richter ste...@flashcomguru.comwrote: And on that note, what does everyone else use when it comes to subscriptions? Paypal is ok for the basics I guess, but I could really use a system that let's me adjust the price from one month to the next for upgrades/downgrades. We use RBS Sagepay for that (used to be WorldPay when we started). We have a client who uses it for subs. ~| 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:341082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfimage write problems
Still not sure why CF complained, but I am having more luck using this: cfhttp url=http://www4d.wolframalpha.com/Calculate/MSP/MSP79419e1a6ei6h30076g3170cdffcai81067?MSPStoreType=image/gifs=55; resolveurl=No /cfhttp cfset resImg = cfhttp.fileContent.toByteArray() / cfimage action = write destination = #THISFOLDER#/#imagename#.gif source = #resImg# overwrite=true Cheers Stefan On 15 Jan 2011, at 19:10, Stefan Richter wrote: Hi all, I'm trying to fetch images from the Wolfram Alpha API. The source for each image is specified in a format such as this: http://www4d.wolframalpha.com/Calculate/MSP/MSP79419e1a6ei6h30076g3170cdffcai81067?MSPStoreType=image/gifs=55 (note this may have expired now) When I check the HTTP response I see that the content-type is correctly specified as image/gif and in the browser the URL results in an image being displayed as expected. However when I try the following cfimage action = write destination = #thisFolder# source = http://www4d.wolframalpha.com/Calculate/MSP/MSP79419e1a6ei6h30076g3170cdffcai81067?MSPStoreType=image/gifs=55; I get an error: The /calculate/msp/msp79419e1a6ei6h30076g3170cdffcai81067 image format is not supported on this operating system. I also tried using ImageNew but got the same error. I'm not sure what to make of this. Does CF expect the URL to end in .gif or why is it complaining? Are there any easy fixes for this or what other ways are there for me to retrieve the image and store it on my server? Thanks for any tips. 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:340923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfimage write problems
Ah I see. Guess I could try this by appending ext=.gif to the URL then... Thanks. On 17 Jan 2011, at 14:41, Raymond Camden wrote: I think - stress think - CF handles the result based on the file name in the URL. So if CF had seen foo.gif at the end, it would have assumed a gif. In your case there is no obvious extension so maybe CF didn't know what to assume. ~| 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:340925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mailing List program
If you are on a Mac then take a look at Direct Mail. I like it as it allows you to pull lists directly from a database and also offers tracking, mail merge and all the core features one would expect. http://ethreesoftware.com/directmail/index.php Obviously this is a desktop app - nothing to do with CF really. Regards, Stefan On 17 Jan 2011, at 16:11, Asim Manzur wrote: I meant the program which I can use to sent mass mail out. like CFMagic List. I don't mind paying but need the solid app which I can modify later for custom requirements. ~| 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:340928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Filezilla Server on a EC2 Windows 2008 Server
Did you make sure that the applied AWS Security Group allows for FTP? A Security Group acts like a firewall and it's separate from your Windows firewall. Regards, Stefan On 6 Jan 2011, at 00:28, Richard Steele wrote: I've successfully installed Filezilla server and it connects to our EC2 Windows 2008 Server 127.0.0.1. However, Our public ip address assigned by Amazon's elastic ip , works for the website, but not for ftp. I've added Filezilla to the Windows Firewall exception list. Not sure what else to try. Thanks in advance. ~| 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:340495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
I'm running a low traffic MySQL install on a micro instance. Works very well. But I think you are pushing things in terms of memory with LCDS and CF as well. Worth a try though. Or you could use MySQL on a separate instance, but then again MySQL is your smallest issue I think :-) The great thing is you could try it (I hope you're planning on using *nix for this as Windows will eat even more resources) and if it does not work detach the EBS volume and use a small instance. You do not have to decide up front what instance type you want, you can start with one and then upgrade/downgrade. Stefan On 6 Jan 2011, at 19:31, Josh Dura wrote: Sorry for the piggyback off of this thread, but I am thinking of running the free micro instance for a year thing to test out a project I am working on (nothing in production :D). I don't have much experience in running a server like this, so I am wondering if it is even feasible to run CF9, LCDS and mySQL on a micro instance? Or would I need to upgrade to one of the larger ones? Josh Dura ~| 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:340535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Amazon provides Windows AMIs so it's very easy to set up a Windows Server, it's a matter of minutes. If you run your server using an EBS backed (which I think is now the default standard for Windows) then you can easily take snapshots in order to backup the entire server in one go. Those snapshots can in turn be used as a new EBS volume so you can essentially clone your server very easily. Should your EC2 instance run into problems (maybe the underlying hardware is having a rough day) you can shut it down, detach the EBS volume and attach it to a new instance. It's a bit like moving a hard drive from box to box except you don't have to actually physically move anything... The whole Amazon stack is very powerful. The concept of having your apps effectively detached from the processing power you need is quite something. You can so very easily boot up new instances of your existing volumes, or increase RAM and CPU capacity in a matter of minutes. I would encourage anyone to have a play using one of the micro instances. They cost next to nothing, and in fact are free up to a limit if you are a new AWS customer. Cheers Stefan On 4 Jan 2011, at 19:46, Richard Steele wrote: Did you find a tutorial on how to set up a Windows 2008 server? There's one online for a non-windows server, but I haven't found one for a Windows 2008 server. Also, I know that Amazon has different levels of guarantee for their s3 storage, but it seems like having it backed up to a different location would be wise. Is that easy to accomplish? 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:340416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: S3 Setup Process
Let your client sign up unless you want to pay his bill :-) He can then set you up as a user with privileges to match the type of access you need. Cheers Stefan On 27 Dec 2010, at 19:42, Dean Lawrence wrote: I've been fooling around with Amazon's S3 service and am getting ready to implement it for a client. However, I'm unsure of the process for signing up for a client account. Do I just have my client create the account and then supply me with the credentials or do I need to use my developer credentials in some way? Thanks, Dean ~| 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:340284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Bug in CFAdmin?
Using CF 9,0,1,274733 Standard. I've set up a scheduled task in CF Admin which runs fine. When I now come back to the Scheduled Tasks page I see my task listed and right underneath CF throws the following error: 12/23/2010 10:34:24 AM is an invalid date format. (which is my current date and time) The error occurred in scheduletasks.cfm: line 497 Called from scheduletasks.cfm: line 442 Called from scheduletasks.cfm: line 419 Called from scheduletasks.cfm: line 180 Called from scheduletasks.cfm: line 1 -1 : Unable to display error's location in a CFML template. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 Remote Address 83.67.80.146 Referrerhttp://www.sharemyslides.com/CFIDE/administrator/navserver.cfm Date/Time 23-Dec-10 10:35 AM Stack Trace at cfscheduletasks2ecfm231417246._factor22(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:497) at cfscheduletasks2ecfm231417246._factor24(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:442) at cfscheduletasks2ecfm231417246._factor30(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:419) at cfscheduletasks2ecfm231417246._factor31(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:180) at cfscheduletasks2ecfm231417246.runPage(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:1) coldfusion.runtime.locale.CFLocaleDateFormatException: 12/23/2010 10:34:24 AM is an invalid date format. at coldfusion.util.DateUtils.formatDate(DateUtils.java:758) at coldfusion.runtime.CFPage.LSDateFormat(CFPage.java:1622) at coldfusion.runtime.CFPage.LSDateFormat(CFPage.java:1615) at cfscheduletasks2ecfm231417246._factor22(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:497) at cfscheduletasks2ecfm231417246._factor24(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:442) at cfscheduletasks2ecfm231417246._factor30(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:419) at cfscheduletasks2ecfm231417246._factor31(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:180) at cfscheduletasks2ecfm231417246.runPage(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Not sure what to make of this. Regards, Stefan
Re: Bug in CFAdmin?
Thanks, I'm aware of the implications of having the CF Admin public. Stefan On 23 Dec 2010, at 13:32, Dorioo wrote: Can't speak to the error but you may want to make your administrator be not publicly accessible. http://www.sharemyslides.com/CFIDE/administrator/ Generally a good idea but specifically because of stuff like this http://www.procheckup.com/vulnerability_manager/vulnerabilities/pr10-07 http://www.adobe.com/support/security/bulletins/apsb10-18.html - Gabriel On Thu, Dec 23, 2010 at 5:37 AM, Stefan Richter ste...@flashcomguru.comwrote: Using CF 9,0,1,274733 Standard. I've set up a scheduled task in CF Admin which runs fine. When I now come back to the Scheduled Tasks page I see my task listed and right underneath CF throws the following error: 12/23/2010 10:34:24 AM is an invalid date format. (which is my current date and time) The error occurred in scheduletasks.cfm: line 497 Called from scheduletasks.cfm: line 442 Called from scheduletasks.cfm: line 419 Called from scheduletasks.cfm: line 180 Called from scheduletasks.cfm: line 1 -1 : Unable to display error's location in a CFML template. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 Remote Address 83.67.80.146 Referrer http://www.sharemyslides.com/CFIDE/administrator/navserver.cfm Date/Timehttp://www.sharemyslides.com/CFIDE/administrator/navserver.cfm%0ADate/Time 23-Dec-10 10:35 AM Stack Trace at cfscheduletasks2ecfm231417246._factor22(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:497) at cfscheduletasks2ecfm231417246._factor24(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:442) at cfscheduletasks2ecfm231417246._factor30(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:419) at cfscheduletasks2ecfm231417246._factor31(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:180) at cfscheduletasks2ecfm231417246.runPage(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:1) coldfusion.runtime.locale.CFLocaleDateFormatException: 12/23/2010 10:34:24 AM is an invalid date format. at coldfusion.util.DateUtils.formatDate(DateUtils.java:758) at coldfusion.runtime.CFPage.LSDateFormat(CFPage.java:1622) at coldfusion.runtime.CFPage.LSDateFormat(CFPage.java:1615) at cfscheduletasks2ecfm231417246._factor22(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:497) at cfscheduletasks2ecfm231417246._factor24(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:442) at cfscheduletasks2ecfm231417246._factor30(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:419) at cfscheduletasks2ecfm231417246._factor31(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:180) at cfscheduletasks2ecfm231417246.runPage(E:\cf9_updates_rc\cfusion\wwwroot\CFIDE\administrator\scheduler\scheduletasks.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke
Re: Bug in CFAdmin?
Thanks Steve. The problem I have is that this is in CF Admin after simply navigating to the scheduled tasks page. I'm not sure where this date comes from or why and it's certainly not based on user input either. Regards, Stefan On 23 Dec 2010, at 14:09, Steven Durette wrote: I had an error like this once. I copy and pasted the date to another program (I don't remember which it was a long time ago) and it showed me I had a high character that displayed as a blank. I wiped out the field and re-entered the date. The problem went away. Steve Sent from my iPhone ~| 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:340251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
Thanks, I'm aware of the implications of having the CF Admin public. What, and you don't care? Hehe I did not say that. Yes, you are right for slapping my wrists but this is a VM which I'm in the process of clearing out and shutting down so it's just not that high on my priority list. I usually make a bit more of an effort. Cheers Stefan Best solution (IMO) and pretty painless to implement - just disable anonymous access to the administrator folder either in IIS or using .htaccess with Apache. You can still access it from anywhere you want but you don't have to worry so much about being hacked. (unlessy ou truly don't care about running an insecure server) Rick ~| 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:340259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
Thanks, deleting and re-entering the task fixed it. Cheers Stefan On 23 Dec 2010, at 16:15, Steven Durette wrote: If you go into the details of the scheduled task and wipe out and reenter the date. I ended up doing each one until I got the one that caused the error in cfadmin. It was one of the entries that showed up before the error. If I remember correctly I had two of them. Fixed one then got more tasks listed. Then went through those until I found the other one. Then the error went away. ~| 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:340260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
Booo I spoke too soon. It worked once or twice when I went back into scheduled tasks but now it's back. :-/ Stefan On 23 Dec 2010, at 21:41, Stefan Richter wrote: Thanks, deleting and re-entering the task fixed it. Cheers Stefan On 23 Dec 2010, at 16:15, Steven Durette wrote: If you go into the details of the scheduled task and wipe out and reenter the date. I ended up doing each one until I got the one that caused the error in cfadmin. It was one of the entries that showed up before the error. If I remember correctly I had two of them. Fixed one then got more tasks listed. Then went through those until I found the other one. Then the error went away. ~| 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:340261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bug in CFAdmin?
Ah I can now see where the supposedly wrong date format comes from. It's the value of the 'Last run' column for the task. Hmmm not sure how I could possibly fox that since it is CF that generates that date every time the task runs... But why would it think that 12/23/2010 9:45:24 PM is a wrong date format anyway? Looks like a date (and time) to me. Stefan On 23 Dec 2010, at 21:41, Stefan Richter wrote: Thanks, deleting and re-entering the task fixed it. Cheers Stefan On 23 Dec 2010, at 16:15, Steven Durette wrote: If you go into the details of the scheduled task and wipe out and reenter the date. I ended up doing each one until I got the one that caused the error in cfadmin. It was one of the entries that showed up before the error. If I remember correctly I had two of them. Fixed one then got more tasks listed. Then went through those until I found the other one. Then the error went away. ~| 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:340263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: Problems with CF9 Mac Install W/Mamp
FWIW I am running CF9 on OSX with MAMP so maybe my post will help: http://www.flashcomguru.com/index.cfm/2009/11/2/cf9-mamp-snowleopard Cheers Stefan On Dec 16, 2010, at 9:15 PM, Gerald Guido gerald.gu...@gmail.com wrote: I have a nice shiny Mac Pro and CF9 and/or Apache is being difficult. The web connector ran fine but I am DL'ing index.cfm as a file when I try to hit http://localhost/cfide/administrator/index.cfm. I am also getting a 403 message when I hit the root with out specifying index.cfm if that is of any matter. Everything else (php and html files) works fine. The apache error log did to show anything. On linux a reboot usually fixes the problem with DL'ing index.cfm but I have tried restarting CF, Apache and rebooting to no avail. I Googled it and could not find anything that helped. I am 2 days into being a Mac owner so I am a total noob. Though I do know my way around Linux/LAMP if that helps any. Fresh patched OSX 10.6 install Mamp 1.9.4 Any suggestions would be greatly appreciated Thanx G! ~| 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:340102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: mySQL administration
+1 for Navicat. Well worth it. That reminds me - I bought a Windows copy of Navicat for MySQL and then moved back to Mac... It's for the MySQL (Windows) Non-Commercial Edition version 9 so if you decide to purchase drop me a line. Stefan On 10 Dec 2010, at 04:27, Azadi Saryev wrote: SQLYog (http://www.webyog.com/en/) and Navicat (http://navicat.com/) both are great MySQL administration tools and both have very feature-rich free editions. MySQL GUI Tools bundle (http://dev.mysql.com/downloads/gui-tools/5.0.html) is another alternative. Azadi ~| 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:339965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Schedule task more frequent than 1 inute
Thanks for all the replies. Some background info. My app converts Office documents and each conversion may run for a few minutes which is why I did not want to run this 'inline' but break the upload away from the conversion. For this reason I have a scheduled task that checks the database for new uploads and then converts them. 99% of the time there will not be a new file, but when there is then I'd like to minimise the time between upload and conversion start. I considered threads but heard that there is a limit on CF Standard - potential headache if things get busy. Schedule the same task as many times per minute you need, starting at different times. I thought that too but what happens on server restart? Do all tasks re-init themselves at the same time? In the end I think once a minute is ok, but I will also ping now the page that handles the conversion shortly after the upload is complete. Out of interest: am I correct in thinking that if one task is running a conversion and the scheduled task fires again then this second process will not have to wait for the first conversion process to complete? So in essence I can achieve a level of multithreading in this way? 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:339805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Schedule task more frequent than 1 inute
Is there any way to schedule a task in CFadmin more frequently than once a minute? I need to run it 2-3 times minute if possible. 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:339728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
.NET errors after CF 9.01 Update
I updated my Windows 2008 R2 64Bit server to 9.01. After I had some issues with the invocation of .NET assemblies I uninstalled and then reinstalled the ColdFusion 9.0.1 .NET Integration Service Installer. Still I cannot use any dlls now. The error I get has little details but looks like this: coldfusion.runtime.dotnet.ProxyGenerationException at coldfusion.runtime.dotnet.ProxyGenerator._executeProxyGen(ProxyGenerator.java:192) at coldfusion.runtime.dotnet.ProxyGenerator.executeProxyGen(ProxyGenerator.java:149) at coldfusion.runtime.dotnet.ProxyGenerator.generateProxy(ProxyGenerator.java:118) at coldfusion.runtime.dotnet.Assembly.generateProxy(Assembly.java:299) Any tips? 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:339682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: .NET errors after CF 9.01 Update
E so I tried rebooting the server... now getting a blank page which is much, much better. Will keep you posted but it seems ok now. S ~| 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:339685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail 'from' seems to get ignored
thanks everyone. I'll try it using my GApps account instead - I do have the site set up under it already so hopefulyl that'll work. Cheers 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:339423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail 'from' seems to get ignored
Hmm that didn't really work either (Google Apps). I've got site.com set up under my google Apps account as an authorised domain. However when I send mail via CF and specify the sender as i...@site.com it now shows as my primary Google Apps domain. So I guess unless I set up a standalone Apps account I won't be able to send mail this way. I'll probably have to use my own mailserver then? 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:339424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMail 'from' seems to get ignored
Hi all, I've configured mail in CF Admin using smtp.gmail.com with my personal GMail account details (username and password). Mail is being sent without problems. However users of one of the websites where I use the CFMAIL tag and a 'from' address of i...@site.com tell me that the email arrives as having been sent from me, using my GMail address. What am I missing? Shouldn't the 'from' in CFMail take priority? That's what I seem to remember always happened when I used my own SMTP server in the past. BTW I am not specifying server details or credentials in the CFMail tag itself, they are only specified in CFadmin. Cheers 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:339402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
I need to warm this thread up again - I am s close... As explained before I was able to use the .NET Bitmap's save method to save an image: cfobject type=.NET name=presentation class=Aspose.Slides.Presentation assembly=#slidesDLL# cfset presentation.init(#Expandpath('./')#ppt\test2.ppt) cfset slide = presentation.GetSlideByPosition(1) cfset img = slide.GetThumbnail(1,1) cfset i = img.Save(#Expandpath('./')#ppt\myfile.jpg) The resulting image appears to be a valid JPG image. I say appears because the CFIMAGE tag falls over if I try to read it back into CF. cfimage action = info source = #Expandpath('./')#ppt\myfile.jpg structname = objImage Error: ColdFusion was unable to create an image from the specified source file. Ensure that the file is a valid image file. So I thought ok, let's try and pass an Imageformat to the Bitmap's save method. http://msdn.microsoft.com/en-us/library/aa903826%28v=VS.71%29.aspx I can do this: cfobject type=.NET name=imageformat class=System.Drawing.Imaging.ImageFormat assembly=C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Drawing.dll cfset v = imageformat.Get_Jpeg() But if I then try to pass that to the Save method it errors again: The Save method was not found. Either there are no methods with the specified method name and argument types or the Save method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. I'm banging my head now. I also tried imageformat.Jpeg but no dice. Element JPEG is undefined in IMAGEFORMAT. Any tips appreciated. 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:338937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
I've now worked around this to some degree by saving the initial image with a .png extension and then re-saving it using cfimage. This seems to work. I'd still like to find out why the other approach with .NET classes didn't work. It's so confusing... Cheers 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:338944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Back to .NET integration - Enumeration issue
Hi all, I'm back working with the Aspose .NET ddls and have a question. First I do this: cfobject type=.NET name=presentation class=Aspose.Slides.Presentation assembly=#slidesDLL# cfset presentation.init(#pptFile#) Now in order to save this presentation in another format the docs state that I need to do call the Save method of the Presentation class. It accepts two parameters, a string describing the file location, the second is constant described by this class: C# public enum SaveFormat Members Member Name Description Value Ppt Save presentation in PPT format.0 Pps Save presentation in PPS format.0 Pdf Save presentation in PDF format.1 Xps Save presentation in XPS format.2 PptxSave presentation in PPTX format. 3 PpsxSave presentation in PPSX format. 4 TiffSave presentation as multi-page TIFF image. 5 Question: How do I use this in CF? I've tried the following: cfset p = presentation.Save(#clientdir#/#uniqueID#.pdf, Pdf) and cfset p = presentation.Save(#clientdir#/#uniqueID#.pdf, 1) but both throw errors: The Save method was not found. Either there are no methods with the specified method name and argument types or the Save method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If I dump an instance of the SaveFormat class I see this: Field Value Aspose.Slides.Export.SaveFormat Pdf Aspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat Pps Aspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat PpsxAspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat Ppt Aspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat PptxAspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat TiffAspose.Slides.Export.SaveFormat Aspose.Slides.Export.SaveFormat Xps Aspose.Slides.Export.SaveFormat Any tips appreciated. 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:338840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
So try grabbing a reference to the Aspose.Slides.Export.SaveFormat. Then use: YourReference.Pdf Awesome, that worked! Many thanks. I now only need to figure out how to convert/cast a .NET instance of System.Drawing.Bitmap to something I can save in CF as a JPG or similar. Cheers 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:338842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
Thanks Dave but how do I do this in CF? When I dump the object of type System.Drawing.Bitmap it does not show me a Save method. I'm not a backend programmer and C# is pretty alien to me. I understand this would all be much simpler in pure C# I guess but I feel I'm close now, all that's left is to somehow save the C# Bitmap to an image... Any pointers much appreciated. Stefan Class Name System.Drawing.Bitmap Methods Method Return Type Clone(System.Drawing.RectangleF, System.Drawing.Imaging.PixelFormat) System.Drawing.Bitmap Clone(System.Drawing.Rectangle, System.Drawing.Imaging.PixelFormat) System.Drawing.Bitmap FromHicon(System.IntPtr)System.Drawing.Bitmap FromResource(System.IntPtr, java.lang.String) System.Drawing.Bitmap GetHbitmap(System.Drawing.Color)System.IntPtr GetHbitmap()System.IntPtr GetHicon() System.IntPtr GetPixel(int, int) System.Drawing.Color LockBits(System.Drawing.Rectangle, System.Drawing.Imaging.ImageLockMode, System.Drawing.Imaging.PixelFormat, System.Drawing.Imaging.BitmapData) System.Drawing.Imaging.BitmapData LockBits(System.Drawing.Rectangle, System.Drawing.Imaging.ImageLockMode, System.Drawing.Imaging.PixelFormat)System.Drawing.Imaging.BitmapData MakeTransparent() void MakeTransparent(System.Drawing.Color) void SetPixel(int, int, System.Drawing.Color)void SetResolution(float, float) void UnlockBits(System.Drawing.Imaging.BitmapData) void http://msdn.microsoft.com/en-us/library/system.drawing.image.save%28VS. 80%29.aspx ~| 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:338844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
Thanks again. Do you know how to instantiate System ddls? I keep getting errors when I try either cfobject type=.NET name=image class=System.Drawing.Image assembly=C:\Windows\Microsoft.NET\Framework\v4.0.30319\System.Drawing.dll or cfobject type=.NET name=image class=System.Drawing.Image Class System.Drawing.Image not found in the specified assembly list. Cheers 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:338847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Back to .NET integration - Enumeration issue
BTW you were right, I can call Save() on Bitmap :-) 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:338848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Am I running CF 9 64bit or not?
Hi all, silly question but how do I tell if I am running CF9 64bit or 32bit? I need to apply the updater and I am unsure which version to use. The machine itself is Windows 2008, on 64bit hardware. 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:338826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Help needed with .NET integration
Hi all, Just the disclaimer upfront again, I'm primarily a Flex developer so please be gentle :-) I'm trying to invoke some .NET dlls using Aspose components which facilitate (amongst other things) conversions of Office documents to other formats. Here I'm trying to convert PPT files to images. I've managed to successfully invoke the dll like this: cfobject type=.NET name=presentation class=Aspose.Slides.Presentation assembly=#Expandpath('./')#\libs\Aspose.Slides.dll cfset presentation.init(#Expandpath('./')#ppt\test1.ppt) I can also get the page count for the PPT file like so: cfset pageCount = presentation.Get_Slides().Get_Count() I can also convert one slide to a Bitmap (according to the Aspose docs, that's what getThumbnail does http://www.aspose.com/documentation/.net-components/aspose.slides-for-.net/creating-slide-thumbnail-image-1.html): cfset slide1 = presentation.GetSlideByPosition(1) cfset img = slide1.GetThumbnail(1, 1) This is where I get stuck. How can I write this bitmap to disk now? The Aspose C# example looks liek this: Bitmap bmp = sld.GetThumbnail(1f, 1f); bmp.Save(d:\\pptx\\ContentBG_tnail.jpg, System.Drawing.Imaging.ImageFormat.Jpeg); I'd like to do the equivalent in CF. BTW I tried to use cfset img = slide1.GetThumbnail(1f, 1f) which threw an error but cfset img = slide1.GetThumbnail(1, 1) seemed to work. Am I correct up to that point? I think once I know how to write the image to disk I will be able to figure out how to loop over all available slides and write them out one by one. Any help appreciated. 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:338780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration
One quick addition: if I cfdump the img variable it shows up as a System.Drawing.Bitmap Class. Not sure if that helps at all. Regards, Stefan Hi all, Just the disclaimer upfront again, I'm primarily a Flex developer so please be gentle :-) I'm trying to invoke some .NET dlls using Aspose components which facilitate (amongst other things) conversions of Office documents to other formats. Here I'm trying to convert PPT files to images. I've managed to successfully invoke the dll like this: cfobject type=.NET name=presentation class=Aspose.Slides. Presentation assembly=#Expandpath('./')#\libs\Aspose.Slides.dll cfset presentation.init(#Expandpath('./')#ppt\test1.ppt) I can also get the page count for the PPT file like so: cfset pageCount = presentation.Get_Slides().Get_Count() I can also convert one slide to a Bitmap (according to the Aspose docs, that's what getThumbnail does http://www.aspose.com/documentation/. net-components/aspose.slides-for-.net/creating-slide-thumbnail-image-1. html): cfset slide1 = presentation.GetSlideByPosition(1) cfset img = slide1.GetThumbnail(1, 1) This is where I get stuck. How can I write this bitmap to disk now? The Aspose C# example looks liek this: Bitmap bmp = sld.GetThumbnail(1f, 1f); bmp.Save(d:\\pptx\\ContentBG_tnail.jpg, System.Drawing.Imaging. ImageFormat.Jpeg); I'd like to do the equivalent in CF. BTW I tried to use cfset img = slide1.GetThumbnail(1f, 1f) which threw an error but cfset img = slide1.GetThumbnail(1, 1) seemed to work. Am I correct up to that point? I think once I know how to write the image to disk I will be able to figure out how to loop over all available slides and write them out one by one. Any help appreciated. 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:338781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration [spamtrap heur]
Thank you for the reply. cfset img = slide1.GetThumbnail(1f, 1f) According to the docs this would produce a full scale image (I assume same size as slide). cffile's not doing the trick? http://bit.ly/bxlt88 or fileWrite (if cf9) http://bit.ly/a1XD1L if that's not working, then maybe image? http://bit.ly/967gKy Thanks, will try that. 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:338783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration [spamtrap heur]
Ok I tried CFFILE and that did indeed write a JPG, but it was only 23bytes in size and my local machine moaned about it not being a valid JPG file. I'm sure I am missing something. The C# example also has this: //Getting the thumbnail image of the slide of a specified size Image image = slide.GetThumbnail(new Size(290, 230)); How would I do the equivalent in CF? How can I pass a new Size object in this way? Sorry if this is obvious but I'm struggling here. 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:338785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration [spamtrap heur]
Thanks for the reply Paul but I am unsure how to use the snippet you posted below. Where is the .save method coming from, what object is that? Stefan On 11/3/2010 4:00 PM, Stefan Richter wrote: cfset img = slide1.GetThumbnail(1, 1) uh, did you try? jpg=createObject(.NET,System.Drawing.Imaging.ImageFormat.Jpeg); img.save(yourFileName,jpg); ~| 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:338786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration [spamtrap heur]
jpg=createObject(.NET,System.Drawing.Imaging.ImageFormat.Jpeg); img.save(yourFileName,jpg); Obviously I am lacking understanding how the .NET dlls work. When I run cfset jpg=createObject(.NET,System.Drawing.Imaging.ImageFormat.Jpeg) it throws an error Class System.Drawing.Imaging.ImageFormat.Jpeg not found in the specified assembly list. I also tried instantiating the Size class but the same thing happens there, whereever I look (System.Windows, System.Windows.WindowsBase etc) it gives me the same error. I've installed .NET 4 if that makes any difference. I also tried specifying the assembly as C:\Windows\Microsoft.NET\Framework\v4.0.30319\WPF\WindowsBase.dll since the .NET docs say that it contains Size. I'm about to give up and just convert to PDF since I know that works. I hate doing it though as I feel I'm quite close here. At this stage I'd be happy to pay someone to help me out with this. 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:338787 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with .NET integration [spamtrap heur]
Thanks all. I'm getting somewhere but have given up on GetThumbnail for now. The .NET libs also contain a method to save SVG files so now I do this: cfloop from=1 to=#lastSlide# index=i cfset slide = presentation.GetSlideByPosition(#i#) cfset img = slide.GetThumbnail() cfset svgFile = '#Expandpath('./')#ppt\test#i#.svg' cfset svg = slide.SaveToSVG(svgFile) /cfloop I'm then using Batik to convert to PNG. This produces some pretty good results. The Batik install and invocation of Java objects was another challenge in itself but I got there in the end by trial and error. I'm quite pleased with myself now :-) Cheers 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:338797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Shorter URLs - How?
Hi all, I'm a Flex developer with just enough CF skills to be dangerous :-) and need some guidance here. My website allows users to access specific pages via a unique id/parameter such as this: http://www.scribblar.com/rooms/index.cfm?r=k3ns5 What's involved in terms of CF code to shorten this to http://www.scribblar.com/rooms/k3ns5 or even better still http://www.scribblar.com/k3ns5 I'm unsure as to how to achieve this. In case it makes a difference I am using a Windows box with IIS7. Cheers Stefan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Powerpoint question
Hi all, sorry for the OT question but I think someone here may be able to advise. Is it technically possible to keep an application (for example a Windows executable of some kind) on top of a Powerpoint presentation which is in fullscreen, presenter mode? Imagine I was presenting a PPT file and wanted to annotate it live on my screen by drawing on top of it using a simple freehand drawing tool. For this to happen the drawing app would need to have focus which means the PPT snaps out of presentation mode. Any ideas welcome. Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Date format question
My CF app stores dates in a MySQL database which I often submit simply using NOW() in my SQL statement. The resulting database entry has this format: 2008-01-29 11:08:40 Other times I am using a default MYSQL value of CURRENT_TIMESTAMP in a timestamp field, which results in the same format. I have a public API which returns the date in the same format. Now one of my clients told me this: .Net functions do not recognize the date/time strings that the API returns making all date/times invalid. Is that really the case? Am I doing something wrong, or is he? Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MySQL TimeStamp error
Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under 'Connection String' in CF Admin: noDatetimeStringSync=truezeroDateTimeBehavior=convertToNull My questions is: does anyone have a more elegant solution to this? Is there a way to avoid this error without having to remember to edit new datasources first? And should this error even be thrown - after all the value is not an invalid date/time value so why does CF have issues with it? Cheers Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion could not delete the file
Hi all, what may be causing the following error and what - if anything - could I do to prevent it? This is on a Windows server with CF8. ColdFusion could not delete the file C:\Inetpub\...\folder\file.ppt for an unknown reason. This happens when I run cfdirectory action=delete directory=C:\Inetpub\...\folder recurse=yes Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion could not delete the file
Thanks Barney, I'm already catching it. I was wondering if there's a way to force delete it somehow - any process that is still hanging onto it would likely be CF or the webserver. On the other hand, how can I find out what's holding onto it? I know how to do this on OSX... Cheers Stefan On 7 Dec 2009, at 15:40, Barney Boisvert wrote: If you just want to silently ignore, wrap with CFTRY..CFCATCH and nothing in the CFCATCH. Typically windows has this problem if another process has the file open for some reason (or just hasn't cleaned up it's handles). cheers, barneyb On Mon, Dec 7, 2009 at 7:37 AM, Stefan Richter ste...@flashcomguru.com wrote: Hi all, what may be causing the following error and what - if anything - could I do to prevent it? This is on a Windows server with CF8. ColdFusion could not delete the file C:\Inetpub\...\folder\file.ppt for an unknown reason. This happens when I run cfdirectory action=delete directory=C:\Inetpub\...\folder recurse=yes Regards, Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion could not delete the file
excellent, thanks On 7 Dec 2009, at 16:07, Barney Boisvert wrote: procexp (Process Explorer) from sysinternals (http://www.sysinternals.com/ or http://live.sysinternals.com/procexp.exe) will let you browse open handles on files and see what process(es) have them open. I don't know how to do it programatically (like from CF), but you might find a command-line utility in the sysinternals package that you can run with CFEXECUTE if you dig a bit. There's all kinds of goodies in there. cheers, barneyb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of query with cfdirectory
Hi all, The task at hand is to find a series of orphaned folders. I want to delete all folders in a certain directory which do not have a matching DB record. I was wondering if this is possible (or accept any other tips): I have a 'query' which is the result of a cfdirectory action=list. I now would like to find any records in that query that do not exist in the resultset of a second query (this second one is a database query). Is there a way to combine these two queries to get a resultset that just holds those items which do not exist in the second query? I know i could loop and query each record but wondered if there's a more efficient way, maybe a query of two other queries? Cheers Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problems with CF-9 install on a Mac
I've got my story about Snow Leopard, CF9 and Mamp here: http://www.flashcomguru.com/index.cfm/2009/11/2/cf9-mamp-snowleopard If you do a standalone install it'll probably be a lot easier. Cheers Stefan On 17 Nov 2009, at 16:17, Rick Mason wrote: Tony, I will consider it but quite frankly a lot of the locals are having problems with CF-9 and Snow Leopard. In fact if you do a quick google search you will find far more CF-9 install woes under Snow Leopard than its predecessor. I thought for sure there had to be somebody on here that experienced the same problem. Why did it think that I was running CF-9 during the install program when I wasn't? I did have a working copy of CF-8 running but on the pc side CF has no problem with that and even shuts down the CF-8 instance for you. Rick On Mon, Nov 16, 2009 at 2:22 PM, Tony Bentley t...@tonybentley.com wrote: Try upgrading to Snow Leopard. It is cheap and solves a number of OS issues. I installed CF9 on a fresh copy of SL and it took about 3 minutes. Also, if you want to use some of the additional document functions, I suggest installing Open Office before installing CF9. I've never had a CF install go so well as this last one FYI. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of query with cfdirectory
Thank you. With the help of a friend we've now come up with this which seems to do the job: cfquery datasource=datasource name=getSlides SELECT myslide from slides /cfquery cfdirectory action=list directory=C:\uploadsdir name=uploads cfquery dbtype=query name=orphans SELECT * FROM uploads WHERE uploads.name not in (#QuotedValueList(getSlides.myslide)#) /cfquery Stefan On 17 Nov 2009, at 16:31, b...@bradwood.com wrote: Try Googling left outer join in a ColdFusion query of query. If you have the two result sets there, left outer the DB list to the directory list to find items in the directory for which there is no matching database record. As for performance, depending on the size of the result sets (less than 5-6 thousand records), you might get just as much performance by simply looping over the directory list and doing a q of q for each item on the database list. Just try it see how it performs. If this is just a nightly job you might not even care how long it takes. ~Brad Original Message Subject: Query of query with cfdirectory From: Stefan Richter ste...@flashcomguru.com Date: Tue, November 17, 2009 10:13 am To: cf-talk cf-talk@houseoffusion.com Hi all, The task at hand is to find a series of orphaned folders. I want to delete all folders in a certain directory which do not have a matching DB record. I was wondering if this is possible (or accept any other tips): I have a 'query' which is the result of a cfdirectory action=list. I now would like to find any records in that query that do not exist in the resultset of a second query (this second one is a database query). Is there a way to combine these two queries to get a resultset that just holds those items which do not exist in the second query? I know i could loop and query each record but wondered if there's a more efficient way, maybe a query of two other queries? Cheers Stefan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4