CF 9.0.1 stops accepting/processing HTTP requests after DB connection failure

2012-11-18 Thread Stefan Richter
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

CF 9.0.1 stops accepting/processing HTTP requests after DB connection failure

2012-11-18 Thread Stefan Richter
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

stefanrichter

2012-11-18 Thread Stefan Richter
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,

Re: error converting docs using cfdocument and openoffice

2011-07-27 Thread Stefan Richter
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

Re: Email Management Software

2011-07-22 Thread Stefan Richter
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

Re: System.Runtime.InteropServices.ExternalException

2011-07-08 Thread Stefan Richter
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

System.Runtime.InteropServices.ExternalException

2011-07-07 Thread Stefan Richter
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

Re: Speeding up .NET dlls

2011-07-02 Thread Stefan Richter
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

Speeding up .NET dlls

2011-07-01 Thread Stefan Richter
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

Help with .NET DLL - Again...

2011-06-30 Thread Stefan Richter
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

Re: Help with .NET DLL - Again...

2011-06-30 Thread Stefan Richter
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

Re: Help with .NET DLL - Again...

2011-06-30 Thread Stefan Richter
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

Re: Help with .NET DLL - Again...

2011-06-30 Thread Stefan Richter
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

Re: Synonym Dictionary

2011-04-30 Thread Stefan Richter
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

Re: Synonym Dictionary

2011-04-30 Thread Stefan Richter
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

Re: Writing transparent gifs makes them grey

2011-04-20 Thread Stefan Richter
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

Re: Writing transparent gifs makes them grey

2011-04-20 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-19 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-19 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-19 Thread Stefan Richter
, 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

Writing transparent gifs makes them grey

2011-04-19 Thread Stefan Richter
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

Creating COM object - troubleshooting

2011-04-18 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-18 Thread Stefan Richter
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#

Re: Creating COM object - troubleshooting

2011-04-18 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-18 Thread Stefan Richter
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

Re: Creating COM object - troubleshooting

2011-04-18 Thread Stefan Richter
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

Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?

2011-02-18 Thread Stefan Richter
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

Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?

2011-02-18 Thread Stefan Richter
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,

Re: Using Google Apps/Gmail for CFMail - limitations?

2011-02-17 Thread Stefan Richter
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

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
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

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
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

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
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

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
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 =

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
: 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

Re: CF 9.01 S3:// not working

2011-02-10 Thread Stefan Richter
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

Re: Google Charts - QR Code - cfimage

2011-02-09 Thread Stefan Richter
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#

Re: CF 9.01 S3:// not working

2011-02-09 Thread Stefan Richter
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

Re: CF 9.01 S3:// not working

2011-02-09 Thread Stefan Richter
. 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

Query of query help

2011-01-31 Thread Stefan Richter
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

Re: Query of query help

2011-01-31 Thread Stefan Richter
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

Re: Query of query help

2011-01-31 Thread Stefan Richter
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

Re: Query of query help

2011-01-31 Thread Stefan Richter
: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

Re: Query of query help

2011-01-31 Thread Stefan Richter
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 =

Re: Help needed with jpedal java integration

2011-01-25 Thread Stefan Richter
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

cfpdf action=getinfo returns incorrect PDF sizes

2011-01-25 Thread Stefan Richter
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

Re: cfpdf action=getinfo returns incorrect PDF sizes

2011-01-25 Thread Stefan Richter
? 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

Help needed with jpedal java integration

2011-01-24 Thread Stefan Richter
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

Re: Help needed with jpedal java integration

2011-01-24 Thread Stefan Richter
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

Re: cfimage write problems

2011-01-24 Thread Stefan Richter
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

Re: cfimage write problems

2011-01-24 Thread Stefan Richter
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

Re: Google Checkout integration

2011-01-21 Thread Stefan Richter
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.

Re: Google Checkout integration

2011-01-21 Thread Stefan Richter
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

Re: cfimage write problems

2011-01-17 Thread Stefan Richter
= 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

Re: cfimage write problems

2011-01-17 Thread Stefan Richter
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

Re: Mailing List program

2011-01-17 Thread Stefan Richter
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

Re: Accessing Filezilla Server on a EC2 Windows 2008 Server

2011-01-06 Thread Stefan Richter
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

Re: Amazon EC2 Windows 2008 Coldfusion Server

2011-01-06 Thread Stefan Richter
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

Re: Amazon EC2 Windows 2008 Coldfusion Server

2011-01-04 Thread Stefan Richter
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

Re: S3 Setup Process

2010-12-27 Thread Stefan Richter
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

Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: Bug in CFAdmin?

2010-12-23 Thread Stefan Richter
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

Re: SOT: Problems with CF9 Mac Install W/Mamp

2010-12-17 Thread Stefan Richter
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

Re: mySQL administration

2010-12-10 Thread Stefan Richter
+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:

Re: Schedule task more frequent than 1 inute

2010-12-06 Thread Stefan Richter
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

Schedule task more frequent than 1 inute

2010-12-03 Thread Stefan Richter
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!

.NET errors after CF 9.01 Update

2010-12-01 Thread Stefan Richter
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

Re: .NET errors after CF 9.01 Update

2010-12-01 Thread Stefan Richter
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!

Re: CFMail 'from' seems to get ignored

2010-11-21 Thread Stefan Richter
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!

Re: CFMail 'from' seems to get ignored

2010-11-21 Thread Stefan Richter
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

CFMail 'from' seems to get ignored

2010-11-19 Thread Stefan Richter
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

Re: Back to .NET integration - Enumeration issue

2010-11-08 Thread Stefan Richter
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)

Re: Back to .NET integration - Enumeration issue

2010-11-08 Thread Stefan Richter
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

Back to .NET integration - Enumeration issue

2010-11-05 Thread Stefan Richter
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

Re: Back to .NET integration - Enumeration issue

2010-11-05 Thread Stefan Richter
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

Re: Back to .NET integration - Enumeration issue

2010-11-05 Thread Stefan Richter
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

Re: Back to .NET integration - Enumeration issue

2010-11-05 Thread Stefan Richter
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

Re: Back to .NET integration - Enumeration issue

2010-11-05 Thread Stefan Richter
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:

Am I running CF 9 64bit or not?

2010-11-04 Thread Stefan Richter
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

Help needed with .NET integration

2010-11-03 Thread Stefan Richter
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

Re: Help needed with .NET integration

2010-11-03 Thread Stefan Richter
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

Re: Help needed with .NET integration [spamtrap heur]

2010-11-03 Thread Stefan Richter
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?

Re: Help needed with .NET integration [spamtrap heur]

2010-11-03 Thread Stefan Richter
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 =

Re: Help needed with .NET integration [spamtrap heur]

2010-11-03 Thread Stefan Richter
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

Re: Help needed with .NET integration [spamtrap heur]

2010-11-03 Thread Stefan Richter
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

Re: Help needed with .NET integration [spamtrap heur]

2010-11-03 Thread Stefan Richter
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()

Shorter URLs - How?

2010-09-21 Thread Stefan Richter
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

(ot) Powerpoint question

2010-01-06 Thread Stefan Richter
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

Date format question

2010-01-05 Thread Stefan Richter
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

MySQL TimeStamp error

2009-12-21 Thread Stefan Richter
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

ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
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

Re: ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
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

Re: ColdFusion could not delete the file

2009-12-07 Thread Stefan Richter
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

Query of query with cfdirectory

2009-11-17 Thread Stefan Richter
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

Re: Problems with CF-9 install on a Mac

2009-11-17 Thread Stefan Richter
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

Re: Query of query with cfdirectory

2009-11-17 Thread Stefan Richter
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

  1   2   >